Add New

[Paul Ilacqua]

Is there something similar to the
rs.Addnew
....
....
rs.update
from ADO in ADO.Net on an Access or SQL Server database.

Paul

 

[Doug Bell]

Paul,
look at the DataSet, the DataTable and the DataRow
The DataSet provides more functionality than the old ADO RecordSet.
A DataSet can hold multiple DataTables (as well as relationships)

something like:
Assuming an existing DataSet

Dim MyDataTable As DataTable
Dim MyDataRow as DataRow

MyDataTable = MyDataSet.Tables("MyTable")
MyDataRow = MyDataTable.NewRow
MyDataRow("MyField1") = 1
MyDataRow("MyField2") = "Test"
MyDataTable.Rows.Add(MyDataRow)

Doug

 

[Cor Ligthert]

Paul,

In addition to Doug

Have as well a look at the dataview addnew
http://msdn.microsoft.com/library/d...l/frlrfsystemdatadataviewclassaddnewtopic.asp

Currencymanager addnew
http://msdn.microsoft.com/library/d...ndowsformscurrencymanagerclassaddnewtopic.asp

I hope this helps?

Cor

 

[Paul Ilacqua]

After I add rows how do I resynch it back to the database?

 

[Oenone]

After I add rows how do I resynch it back to the database?

Call the Update method on the DataAdapter object which you used to fill your
DataTable. Pass the DataTable to it as the parameter.