Skip to Content
Menu
This question has been flagged
2256 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
1863
3
lapkr. 23
2080
1
rugp. 23
4236
4
kov. 15
12192
2
kov. 15
6874