hi,
i have a tables in dataset ( not exists in database ).
how can i load these tables from dataset into database (in sql server ) ?
i tried:
 adapter.update(dataset)
but it's doesn't work

thank

Excuse me but u were not clear, How do u wanna update a table witch is not in DB?! did u retrieve it from other tables?!

Always:),
Hovik Melkomian.

hey
yes, i retrieved it from one database(suppose "DB1") and i made changes in data and i want to put my changes in other database as new table. i have already create the new database(this is not my problem), i'm just want to load the tables in my dataset into my new database (because i want to do queries on this new database).
i hope the explansion more clear
thanks a lot
koby

you should use SqlCommandBuilder just biuld one then Update your adapter.

--------------------------------------------
Mehdi
I'm waiting for your better idea.

but wait no..
It doesn't work!!!!
you know better than me SqlCommandbuilder just update one Table in the dataset(with INSERT,DELET,UPDATE commands)not making new table in DB
I think you Should again execute your query in your new DB but withot executing query I don'know
can anyone help us?

--------------------------------------------
Mehdi
I'm waiting for your better idea.