Home ›
All Tags » sql » DataAdapter (RSS)

Browse by Tags

Related Posts

  • Cant get a data

    Hi, all Not much to explain I write this code and I dont get data (if I run the query in the DB it works) 1 private void ShowFullView(String strFullViewName) 2 { 3 OleDbCommand command = new OleDbCommand( "SELECT sCat_Code " + 4 "FROM CATEGORIES_TAB " + 5 "WHERE sName = '...
    Posted to Access Databases and AccessDataSource Control (Forum) by SweeT EviL on 04-10-2009, 12:00 AM
    Filed under: sql, sql queries, sql Statements, access, Access Database, Access db, asp.net, c#, connection string, ConnectionString, data access, DataAdapter

  • 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: ObjectDataSource DataSet Multitable, sql, SQL ASP OBJECTDATASOURCE, strongly typed datatable, ADO.NET data access, BLL, BLL DAL Tier Separation, C#, DataAdapter, DataAdapter Update, DataSource, DataTable, Insert, insert datatable

  • 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, dataadapter, dataset, For Each Loops

  • 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: Empty, object data source, objectdatasource, sql, Table Adapter, Business Object, DAL, data set, DataAdapter, DataSet, datatable tableadapter, Gridview - dataset, Gridview DataGrid, Gridview

  • 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

  • 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

  • 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
Page 1 of 1 (7 items)

Contact | Advertise | Ads by BanManPro | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.