Updating Database from DataTable

[netasp]

hi all,
I created a Datatable, and i am adding datarows in it. I want to be able to copy all the information in the DataTable to a table in my Database.

can this be done? i am using vb.Net 2005.

thanks,

 

[JuggaloBrotha]

it's rather easy actually, all you need is a database connection and a data adapter

 

[netasp]

thanks JuggaloBrotha for your reply,

i am using the following:

Dim strSQLPymt As String = "SELECT * FROM Temp_Table"
dim dtTemp as New DataTable
daTemp = New SqlDataAdapter(strSQL, cnSQL)
daTemp.FillSchema(dtTemp, SchemaType.Source)

i update my DataTable through out the code and now i want to write everything in dtTemp to this table "Temp_Table"? how can I do that?

can you show me how? Thanks

 

[vis781]

Look into the following SQL commands. They are the ones responsible for making changes to your datasource.

UPDATE .. SET
INSERT INTO
DELETE FROM