Browse by Tags

Related Posts

  • Table Adapter Insert Problem

    Hi Guys I am hoping someone kind person would help me out here, I a have just starting using tableAdapters but I am not quite confident just yet, although I have come a long way in the last few days and " Nights ", the problem I have is very simple I am sure, but I cannot solve it for the life...
    Posted to Data Access and ObjectDataSource Control (Forum) by Web Design Devon on 06-13-2009, 12:00 AM
    Filed under: Data, TableAdapter, TableAdapters, Table Adapter, DataSet, DataSet Access Parameter C#.NET 2.0, DataAdapter, Insert, Data Access Layer, DataAdapter DataTable SQL Server, DataRow, tableadapter dataset datatable, datatable.rows, dataadapter.fill(), insert datatable, database add records, Insert data, tableadapter passing parameter, data accesss layer, Insert Data Values into SQL Database
  • Duplicate Record

    I am working an a n-tiered asp.net application. User's need to be able to select an existing record from a gridview and make changes to the record. After making changes, the record needs to be submitted and a new record needs to appear in the gridview. The user would then see the original record...
    Posted to Data Access and ObjectDataSource Control (Forum) by rmulligan@regionsix.com on 08-09-2008, 12:00 AM
    Filed under: ObjectDataSource RowUpdating, Visual Studio 2008, asp.NET 3.5, binding, bll business layer objects, Data, Data Access, Data Access Layer, DataAdapter, DataRow, insert with GridView, Gridview, .net 2.0, Business Object, insert datatable
  • 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: outputparameter, Paramter, Performance : Stored Procedure with many params, Table Adapter, TableAdapter, TableAdapters, ADO.NET, ASP.NET, Asp.Net 2.0, DAL, Data, data Acces, Data Access, Data Access connections, data connections, data set, DataAdapter, Database, databind, DataGrid GridView Paging, DataSet, DataSource, Select, SQL Server ADO.NET Transactions
  • Saving listbox data - best approach?

    We have an ASP.NET 2.0 site that uses SQL Server 2000/2005. I am working on a page that updates our user table. But it will also update multiple related tables. For example, the user could be a member of several different companies and/or organizations and may have 1 to many roles out of a list of available...
    Posted to Data Access and ObjectDataSource Control (Forum) by nickpup on 04-19-2007, 12:00 AM
    Filed under: object data source, ObjectDataSource DataSet Multitable, passing object, sql, SQL Performance, Stored Procedures, VB.Net, ADO.NET, ASP.NET, Business Object, Data, Data Access, data set, DataAdapter, Database, databind, DataSet, DataTable, DataView SqlDataSource, design, SQL Server ADO.NET Transactions
  • DataSet or Business Objects (IS ORM a better solution?)

    Hello guys, I am in doubt what solution is the best for a case that we have in hand. We have to develop a web application (ASP.NET 2 with loads of reports which I think we will use SSRS) and on this particular project there are about 100 tables involved. As you know we can add a DataSet for each table...
    Posted to Data Access and ObjectDataSource Control (Forum) by Mehdi6002 on 03-07-2007, 12:00 AM
    Filed under: ORM, sql, Business Object, Data, Data Access, data set, Data Set Binding, DataAdapter, Database, DataSet, DataTable
  • How to retrieve data as XML from SQL database

    Hi, I have a website which is designed to search for employee information. I have the search system working which does exactly what I want to, but as an added feature I want there to be a button which, when someone clicks on it, it takes whatever the previous search was and generates a set of data in...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by tomosap on 02-28-2007, 12:00 AM
    Filed under: object data source, objectdatasource, parameter datatype, Stored Procedures, Table Adapter, TableAdapter, TableAdapters, VB.Net, ADO.NET, Columns, combining data sources, DAL, Data, Data Access, DataAdapter, Database, DataGrid GridView Paging, DataSet, DataTable, DataView SqlDataSource, DropDownList, XML, 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: SqlDataSource, STOREd Procedures COMMAND ADO.NET ASP.NET, Table Adapter, TableAdapter, TableAdapters, ADO.NET, ADO.NET LOCKING BLOCKING data access, ADODB MSDataShape Shaping ASP.NET C# Child Record Sets, BLL DAL Login Membership SQL Express, DAL, Data, data Acces, Data Access, Data Access Application block, Data Access connections, data connections, data set, Data Set Binding, DataAdapter, DataAdapter Update, Database, databind, DataColumn Expression, DataGrid GridView Paging, DataReader, DataSet, DataSet Access Parameter C#.NET 2.0, DataTable, DataTable.GetError, DataView SqlDataSource, Gridview column visible, GridViewiew, database connection, Select, Any help on ADO.NET 2.0 MARS feature, SQL Server ADO.NET Transactions
Page 1 of 1 (7 items)