.addnew for Ado.net?

paulwalker · September 17th, 2003, 12:08 PM

I'm used to using the .addnew command for a recordset to add a new record to a database with the old ADO. Can you use .addnew with ADO.net? And if you can how do you use it? Or is there now a better way?

Thanks.

bani · September 20th, 2003, 10:17 AM

You can use the NewRow() of the DataTable object. Here is a code snippet and C#

Code:

DataTable tbl = new DataTable("Person");
DataColumn col = tbl.Columns.Add("LastName", typeof(tring));
col.MaxLength = 25;
col.AllowDBNull = false;

// Insert a new row
DataRow row = tbl.NewRow();
row["LastName"] = "Walker";
tbl.Rows.Add(row);