AddNew method

[Martin]

I am fairly new to ADO.NET, is there an ADO.NET method that
is similar to the AddNew method that existed in ADO for adding new
records to a database.

Martin

 

[Calvin Luttrell/ProjectThunder.com]

Martin,

The table object has a NewRow method that will give you a new row instance.
Dim otable As DataTable
otable.NewRow()


-Calvin Luttrell
www.projectthunder.com
Enter to win a XBOX or a Portable DVD Player
Monitored forums www.projectthunder.com/forums

 

[William Ryan eMVP]

I am fairly new to ADO.NET, is there an ADO.NET method that
is similar to the AddNew method that existed in ADO for adding new
records to a database.

Martin

Like Calvin mentions, the .AddNew Method of the dataTable will do it for
you.

DataRow dro = dataTableName.NewRow();
or Dim dro as DataRow = dataTableName.NewRow

at this point, you have a new row with the schema defs of the table, so if
the table had 4 columns, your datarow has 4 columns with the same names,
types etc. BUT it's not added to the datatable yet.

So, you can set the values of each field now or wait until you add it to the
row(usually waiting is a bad idea b/c you'll invariably violate an integrity
rule at some point or even if you don't, forget to set those values).

dataTableName.Rows.Add(dro);
or dataTableName.Rows.Add(dro) (who says VB.NET and C# are that much
differerent ;-) ).

HTH,

Bill



--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/