Skip to Content
Menu
This question has been flagged
2095 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
1716
3
lapkr. 23
1919
1
rugp. 23
4071
4
kov. 15
12054
2
kov. 15
6753