Home ›
All Tags » sql » dataset (RSS)

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

  • 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

  • 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: sql, Data Access, DataSet, ADO.NET, C#, Query

  • 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: DAL, SQL, 3-tier architecture, Newbbie, DataTable.Select Method, dataset, Visual Studio 2005, Best Practice, C#, data, help me, newbie, beginner, OOP, xsd, DataSet DataTable TableAdapters, sql express

  • 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, TableAdapter, DataSet, DataTable, AS/400, Report, iseries, system i

  • 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

  • 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: Asp.Net 2.0, Asp.Net 2.0 session, ASP.NET, Asp.Net 1.1, asp.net 2.0 asp.net, GridView field, ASP.NET Sites, VB.Net, asp, DotNet, reports, grid view, ASP.net 2.0 Tutorials, selection, C# code, Asp.NET2.0, ado.net, dataset, datareader, ASP.NET.NET 2.0, postback variables, c#, sql, database, datasource, Asp.Net 2.0 and MS SQL Server 2005, querystring, update, sqldatabase, t code behind, Find Control, excel, asp.net 2.0 export to excel

  • 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

  • Dataset vs SQL access

    Can tell me what the benefits of creating a dataset to access sql data are. Right now I do direct sql database access and don't really see the benefits of creating intermediary datasets.
    Posted to Data Access and ObjectDataSource Control (Forum) by carbog on 01-24-2008, 12:00 AM
    Filed under: SQL, dataset
Page 1 of 1 (10 items)

Advertise on ASP.NET

About this Site