Skip to Content
Menu
This question has been flagged
1992 Rodiniai

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


Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
1
vas. 24
1597
3
lapkr. 23
1818
1
rugp. 23
3922
4
kov. 15
11890
2
kov. 15
6671