Skip to Content
Menu
Dette spørgsmål er blevet anmeldt
2049 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
1645
3
nov. 23
1860
1
aug. 23
3988
4
mar. 15
11942
2
mar. 15
6707