use dataset to write to a database

SteveS · Dec 12, 2003

I have a dataset with a a few datatables. I would like to write a select
statement based off of those datatables and then insert that data into a SQL
Server table. How can I do this??? I know how to change or add a record
from a particular datatable and update the original table on the database,
but that's not what I want to do.

Thank you for your help,

SteveS
(e-mail address removed)

Miha Markic · Dec 12, 2003

For warm up you might read
Accessing Data with ADO.NET
..net help topic.

Val Mazur · Dec 13, 2003

Hi Steve,

You cannot make a select statement, which will select data from the
different datatable. You would need to create some sort of a helper class,
like described in next KB, but then you would need to create your own
command, which will insert data. There is not simple implementation for it

http://support.microsoft.com/default.aspx?scid=kb;en-us;325688

use dataset to write to a database

SteveS

Miha Markic

Val Mazur