Home ›
All Tags » database » SELECT (RSS)

Browse by Tags

Related Posts

  • setting empty text box input on form to null parameter for sql

    Hi, I'm pretty new to ASP.NET and VB, but I'm working on a project which is essentially a staff directory. Using VS 2005, I've setup a basic grid view which connects to an object which connects via a data layer to a SQL database with Name, Surname, Email, Extension No and Department fields. I have it...
    Posted to Data Presentation Controls (Forum) by tomosap on 02-19-2007, 12:00 AM
    Filed under: dataview, string, database, sqldatasource, rows, If Statement, Null, data access layer, specific record, table adapter, mysql, sql, VB, textbox, datatagrid navigarion paging style, FORM, SELECT

  • problem with retrieving/displaying data based on form input

    Hi, I've developed a form which accesses a database through a data layer and sends parameters based on the form input. I have written the following code which works by checking if the textbox is empty and passing a null value as a string to the search parameter in the query, of which there are five:...
    Posted to Data Presentation Controls (Forum) by tomosap on 02-22-2007, 12:00 AM
    Filed under: GridView, problem, string, database, sqldatasource, label, datasource, rows, records, If Statement, Null, GridView asp.net, data access layer, table adapter, databinding, data, ASP.net 2.0 GridView InsertParameters ControlParameter PropertyName, Updateparameters, sql, search, VB, textbox, method, parameter, querystring, ADO.NET, access database, FORM, SELECT

  • Decode query does not take parameter!

    I am trying to use a Decode Query to define a DataTable method which looks like this: SELECT CDTS, '', '', '', LOC, NULL, DECODE(DTYPE, 'L', CONCAT(CONCAT(CONCAT('***** LOI MATCH:', LOI_DATA.NUM_1), ' ADDRESS: '), LOI_DATA.LOC), 'D', CONCAT('CLETS...
    Posted to Data Access and ObjectDataSource Control (Forum) by Chabo on 05-22-2007, 12:00 AM
    Filed under: TableAdapter, TableAdapters, Select, ASP.NET, DataGrid GridView Paging, DataSet, SQL Server ADO.NET Transactions, ADO.NET, Performance : Stored Procedure with many params, Table Adapter, DAL, Data, data Acces, Data Access, Data Access connections, Paramter, outputparameter, data connections, data set, DataAdapter, Database, databind, Asp.Net 2.0, DataSource

  • Re: Custom Paging in a Gridview - Runtime Error When Filtering

    hopeful bump After some more investigating I can see that the error is occuring here: //return how many rows are in the total recordset public int GetTransactionCount( int fkToOrgID) { try { return ( int )Adapter.usp_GetTransactionCount(fkToOrgID); } catch ( Exception err) { //Catch the error here and...
    Posted to Data Presentation Controls (Forum) by glosrob on 11-30-2007, 12:00 AM
    Filed under: GridView, database, paging, sql, SELECT, ASP.NET, Filtering GridView

  • A large number of Records

    how can I display alarge number of records , about 2 million records, in a data grid? how should I select my data? and how should I paging my dataset or datatable? Thanx;
    Posted to Data Access and ObjectDataSource Control (Forum) by amohammadi on 05-01-2007, 12:00 AM
    Filed under: Data, BLL DAL Login Membership SQL Express, DataAdapter Update, DataGrid GridView Paging, TableAdapter, TableAdapters, DAL, Data Access, DataTable.GetError, Database, Table Adapter, DataSet, DataColumn Expression, DataSet Access Parameter C#.NET 2.0, SQL Server ADO.NET Transactions, DataReader, DataTable, ADO.NET, ADO.NET LOCKING BLOCKING data access, DataView SqlDataSource, Data Access Application block, data set, Data Set Binding, ADODB MSDataShape Shaping ASP.NET C# Child Record Sets, DataAdapter, Any help on ADO.NET 2.0 MARS feature, Select, Gridview column visible, databind, STOREd Procedures COMMAND ADO.NET ASP.NET, GridViewiew, data Acces, database connection, SqlDataSource, Data Access connections, data connections
Page 1 of 1 (5 items)

Advertise on ASP.NET

About this Site