Home ›
All Tags » sql » dataset (RSS)

Browse by Tags

Related Posts

  • DataBinding: 'System.Data.DataRowView' does not contain a property with the name '1'.

    the error: DataBinding: 'System.Data.DataRowView' does not contain a property with the name '1'. my case: getting this error when deleting a row from gridview and reloading the gridview with the changes using a single stored proc to delete and select.. dataset contains column names and...
    Posted to Access Databases and AccessDataSource Control (Forum) by snet on 01-09-2009, 12:00 AM
    Filed under: sql, stored procedure, visual studio, ASP.NET 2.0, c#, DataSet, Gridview Data Sources, .ASPX, GridView

  • 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

  • How to copy data from one excel file to other excel file

    Hi I have two excel file (Ex1 and Ex2), both have same template (headers) and data will be populated from the dataset. Upto this step its works fine. My question : How to copy the data form 6th row to last row of "Ex2" and paste it into the "Ex1" after the last row in Ex1. Advance...
    Posted to Enterprise Services Integration (Forum) by SudhaYogesh on 09-12-2007, 12:00 AM
    Filed under: postback variables, querystring, selection, sql, sqldatabase, t code behind, update, VB.Net, ado.net, asp, ASP.NET, Asp.Net 1.1, Asp.Net 2.0, Asp.Net 2.0 and MS SQL Server 2005, asp.net 2.0 asp.net, asp.net 2.0 export to excel, Asp.Net 2.0 session, ASP.net 2.0 Tutorials, ASP.NET Sites, ASP.NET.NET 2.0, c#, C# code, database, datareader, dataset, datasource, excel, GridView field, Asp.NET2.0, grid view, reports, DotNet, Find Control

  • SQL JOIN between DataTables in a DataSet

    Hello, Am I correct in thinking that it is currently not possible to perform an SQL JOIN across multiple DataTables in a DataSet in .NET? I have a typed DataSet with three relational tables which need to be placed into one flat table, e.g.: Table A : PK, Table A Col 1, Table A Col 2... Table B : PK,...
    Posted to Data Access and ObjectDataSource Control (Forum) by WolfyUK on 07-12-2007, 12:00 AM
    Filed under: sql, DataSet, DataTable

  • DataSet (xsd) Creating a DataTable

    We are trying to grab data from a System i (or iSeries or AS/400) using a DataSet. We have this working and can grab everything from the table. The end result is we want to output a Report (from Visual Studio 2005). The problem is Visual Studio doesn't like my SQL statement: select vcmplntnum, vvltnnum...
    Posted to Data Access and ObjectDataSource Control (Forum) by Koldark on 07-09-2007, 12:00 AM
    Filed under: sql, system i, TableAdapter, AS/400, DataSet, DataTable, iseries, Report

  • Update Database structure after Strongly-Typed DataSet is built

    This is my first 3 tier application... I'm using a Stongly Typed Dataset as DAL. After everything was finished, I realized I had to make 2 changes to the database: 1- Add a new column 2- Change a SQL Data type from int to Bool What is the best way to update my Strongly Typed Dataset and make sure...
    Posted to Data Access and ObjectDataSource Control (Forum) by cunharubens on 06-09-2007, 12:00 AM
    Filed under: newbie, OOP, Visual Studio 2005, beginner, Best Practice, C#, DAL, data, dataset, DataSet DataTable TableAdapters, DataTable.Select Method, help me, xsd, Newbbie, SQL, sql express, 3-tier architecture

  • Re: Ican't update my dataset

    here i post the code that i wrote i take the stage and depId from two textboxs and beging to excute the queries usin tabel adapter and put the desired result in arrayList then because the tableadpter StudentCourses1 can't up date the dataset as contain multiple table so i use table studentCourses...
    Posted to Data Access and ObjectDataSource Control (Forum) by semsem0 on 06-08-2007, 12:00 AM
    Filed under: Query, sql, C#, Data Access, DataSet, ADO.NET

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

Contact | Advertise | Issue Management by Axosoft's OnTime | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.