I forget that . My application alerts the strange error is that: operation must use an updateable query. But my query is very exactly

I see you use Datareader.But I don't use it.I am using Datatable.Please give code in Datatable.Anyway I would be grateful.Thanks very very very much much much

How to update or delete direct from Grid to Database?I tried my best but fail.Please help me.I have enclosed my code. Please modify Private Sub Grid_Customer_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles Luoi_khach_hang.UpdateCommand Dim Name1 As TextBox = e.Item.Cells(0).Controls(0) Dim Name2 As TextBox = e.Item.Cells(1).Controls(0) Dim Sex As CheckBox = e.Item.FindControl("Phai") Dim Custom_Code As Integer = Luoi_khach_hang.DataKeys(e.Item.ItemIndex) Dim SQL As String = "UPDATE khach_hang SET ho_khach_hang='" & Name1.Text & "',ten_khach_hang='" & name2.Text & "',gioi_tinh=" & Sex.Checked & " where mkh=" & Customer_Code Dim Connect As OleDb.OleDbConnection = Bang_khach_hang.Connect Connect.Open() Dim cmd As New OleDb.OleDbCommand(sql, Connect) Try cmd.ExecuteNonQuery() Catch ex As Exception End Try Connect.Close() Grid_Customer.EditItemIndex = -1 Doc_danh_sach_khach_hang() Lien_ket_du_lieu() End Sub