Skip to Content
Menu
Dette spørgsmål er blevet anmeldt
1831 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
1450
3
nov. 23
1669
1
aug. 23
3700
4
mar. 15
11676
2
mar. 15
6557