Hi Everyone, I have brought in a table from SQL Server into ASP.NET through Datagrid and have turned all fields into textboxes so the user can edit any textbox and click save once. However when the save button is clicked then all textboxes are changed to the value which is in the last row. Here is the code for my save button: Private Sub doSave(ByVal sender As Object, ByVal e As System.EventArgs) Dim myCommand As SqlCommand Dim dstCopy As New DataSet Dim strQuery As String objConnection = New SqlConnection("server=SQLSERVER;database=upsizedCandidate;Integrated Security=True;") objConnection.Open() Dim dgItem As DataGridItem For Each dgItem In myInfo.Items Dim txtNewColumn1 As TextBox = CType(dgItem.Cells(0).FindControl("txtNewCol1"), TextBox) Dim txtNewColumn2 As TextBox = CType(dgItem.Cells(1).FindControl("txtNewCol2"), TextBox) strQuery = String.Format("update ToddsTable3 set NewCol1= '" + txtNewColumn1.Text + "',NewCol2='" + txtNewColumn2.Text + "'") myCommand = New SqlCommand(strQuery, objConnection) myCommand.ExecuteNonQuery() Next DataBind() myInfo.DataBind() objConnection.Close() myInfo.EditItemIndex = -1 BindGrid() End Sub I have no idea what could be wrong and this has been driving me crazy. could anyone please help me? Thanks in advance