Browse by Tags

Related Posts

  • 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: Data, sql, Data Access, Database, DataSet, DataTable, data set, Data Set Binding, DataAdapter, Business Object, ORM
  • Do I do dataset fill operations in a using or try block?

    Hi, I'm not used to using datacontainers, and I generally use a using statement for sql operations such as: using (conn = new SqlConnection(connString)) { //etc } What about if I'm using a dataset or data adapter. I put the connection in the constructor, but should this be inside a using block? Thanks...
    Posted to Data Access and ObjectDataSource Control (Forum) by btipling on 03-25-2007, 12:00 AM
    Filed under: sql, ADO.NET, DataAdapter, using
  • 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: Data, ObjectDataSource DataSet Multitable, sql, Data Access, Database, VB.Net, DataSet, SQL Server ADO.NET Transactions, DataTable, ADO.NET, design, DataView SqlDataSource, passing object, data set, object data source, SQL Performance, Stored Procedures, DataAdapter, Business Object, databind, ASP.NET
  • Missing TableAdapter from DataSet or Business Object Empty

    The Scenario: I created a DataSet called GetHouses.xsd that gets data from a table based on which user is logged in. I named the Return a DataTable Method name: GetDataByUser. I have tried Google and these forums but I haven't found anything matching what I am experiencing. I've done similar...
    Posted to Data Access and ObjectDataSource Control (Forum) by dune44 on 01-31-2008, 12:00 AM
    Filed under: sql, DAL, Table Adapter, DataSet, Gridview, objectdatasource, data set, object data source, DataAdapter, Business Object, Gridview - dataset, datatable tableadapter, Gridview DataGrid, Empty
  • Problem: Dataset into SQL Table

    I am reading a CSV file into a dataset and trying to insert this dataset into an existing SQL table. The problem I am having lies in the fact that the dataset I have contains 2 columns, and the SQL table has 20+ columns. I can't get any data to be inserted into the SQL table from the dataset, I really...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by acoleman on 03-12-2008, 12:00 AM
    Filed under: SQL, dataset, dataadapter, For Each Loops
  • Re: Between sql2005 db, tableAdapters, BLL and Codehinds, How do display data related error messages?

    This is the code for the method in question: 1 [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, false )] 2 public MarketingContacts.OwnershipDataTable GetOwnershipByContactIdAndStaffDivId( int ContactId, int StaffDivId) 3 { 4 return GetOwnershipByContactIdAndStaffDivId...
    Posted to Data Access and ObjectDataSource Control (Forum) by akuyali on 04-18-2008, 12:00 AM
    Filed under: SQL ASP OBJECTDATASOURCE, DataAdapter Update, ObjectDataSource DataSet Multitable, sql, BLL, DataTable, C#, DataAdapter, Insert, DataSource, BLL DAL Tier Separation, ADO.NET data access, strongly typed datatable, insert datatable
Page 1 of 1 (6 items)