Skip to Content
Menu
Dette spørgsmål er blevet anmeldt
1817 Visninger

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


Avatar
Kassér
Related Posts Besvarelser Visninger Aktivitet
1
feb. 24
1419
3
nov. 23
1640
1
aug. 23
3668
4
mar. 15
11646
2
mar. 15
6539