Define an insert stored procedure as you normally would if you were
doing a single insert.
Create a sql connection
Then in your code define a SqlDataAdapter (or data adapter for the type
of database you use).
You create a sqlcommand with the insert stored procedure specified.
Then set the sqldataadapters insertcommand property to the sql command
you just created.
Then if you call the Sql data adapters Update method and pass in the
datatable.
check out the following link
http://msdn2.microsoft.com/en-us/library/59x02y99.aspx
Please note, the insertcommand will be fired when you call the Update
method. The dataadapter knows what to do for each row by checking the
rows state.
So if the rows rowstate is new then it would be inserted using the
insert command, if it is modified it would be updated using the update
command, if it is deleted it would use the delete command.
Hope this helps
Pete
