Skip to Content
Menu
This question has been flagged
2339 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
1915
3
lapkr. 23
2138
1
rugp. 23
4339
4
kov. 15
12303
2
kov. 15
6939