Inserting Records in database using Dataset
Hi, my ADO.NET skills are very weak so I dont even know if it is possible or no. Basically I know how to get the records from the database using a dataadapter, edit it, and then update it. What I am trying to do here is that I have a two datatables that are within a dataset. Let's just say that this dataset was received as a parameter, is it possible to update two tables in the database with the all the records in the tables from that dataset which is being passed as a parameter.
Something similar to this if my wording doesn't make any sense:
Edits: sorry just to add to it, this is for SQL Server as backend.
Private Sub_Insert(DS as DataSet)
dim dt0 as DataTable = ds.Tables(0)
dim dt1 as DataTable = ds.Tables(1)
'Insert records in dbo.table0
'Insert records in dbo.table1
new to programming but getting ther