Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dataadapter insert
Message
From
27/09/2013 11:30:23
 
 
General information
Forum:
ASP.NET
Category:
Databases
Environment versions
Environment:
VB 9.0
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01584280
Message ID:
01584329
Views:
35
>Hi, Don,
>
>If you need to manually add rows to an ADO.NET data table, you need to use the ADO.NET object model.
>
>Here is a very simple example of an established DataTable with 2 columns for ID and Name...you'll need to adapt it to your application.
>
>This is basically an "untyped dataset" as opposed to a strongly typed dataset. Typed datasets are often better, but it's best to get the basics down first. Suppose your data table has 2 columns for ID and Name.
>
>
>DataRow dr = dt.NewRow();
> dr["ID"] = 1;
> dr["Name"] = "Kevin";
> dt.Rows.Add(dr);
>
>
>So if you need to add rows to a table before binding the ADO.NET datatable to a grid, that's a very simple example.

Thanks Kevin, I can work with that. Is the dataadapter insert command only used when you need to send new data back to the source table?
Also, any ideas on how to resort the dt after the new row is added?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform