>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?