>yes that i know but i've so many records i've insert with dataset
Daniel u can use the sql data adapter and sql command builder for that.
e.g.
Dim SqlAdapter As New SqlDataAdapter("select * from table", sqlconnection)
Dim SqlCmdBuilder As New SqlCommandBuilder(SqlAdapter)
sqladapter.update(dataset, "table")
Alexandre Palma
Senior Application Architect