Skip to Content
Menu
This question has been flagged
2000 Views

Hi

I want to insert the records in dataset ds in to another table(another database and server). What should i do write in the select statement.
sda = New NpgsqlDataAdapter(pgCommand)
sda.Fill(ds)
pgCommand1.CommandText = "INSERT INTO public.tab2 (SELECT * FROM ds)"

Thanks


Avatar
Discard
Related Posts Replies Views Activity
1
Feb 24
1609
3
Nov 23
1828
1
Aug 23
3925
4
Mar 15
11896
2
Mar 15
6673