Skip to Content
Menu
Dette spørgsmål er blevet anmeldt
2100 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
1724
3
nov. 23
1921
1
aug. 23
4075
4
mar. 15
12054
2
mar. 15
6756