Updating table using SelectCommand.CommandText?

[Rashar]

Hello, I have tried the code below to update my table, but I'm not sure if it is in the right context... The problem that I am facing is that my data is being passed to the table, but it creates a new row as oppose to updating the row that I specified... and I think that is coming from the line that reads myLocalDataSet.Tables("tblCall_Reports").Rows.Add() How can I modify this code so that it will update my table based on the SQL criteria? 'Save changes to the database myLocalSqlDataAdapter.SelectCommand.CommandText = "SELECT * FROM tblCall_Reports WHERE UID = " & txtUID.Text myLocalDataSet.Tables("tblCall_Reports").Rows.Add() myLocalSqlDataAdapter.Update(myLocalDataSet, "tblCall_Reports") Thanks in advance, Rashar

[kumarprabhakar74]

You can use following command to update table with select statement Dim sqlString As String = "select * from employee where id=1" Dim comm As New SqlCommand(sqlString, conn) Dim adp As New SqlDataAdapter Dim sb As New SqlCommandBuilder(adp) adp.SelectCommand = comm Dim ds As New DataSet adp.Fill(ds) row(3) = "Dealer" adp.Update(ds) Kumar Prabhakar