Skip to Content
Menu
This question has been flagged
1827 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
1439
3
lapkr. 23
1657
1
rugp. 23
3685
4
kov. 15
11665
2
kov. 15
6548