Datagrid

[toanthinh]

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

[postmaster programmingknowledge com]

Try this example http://www.programmingknowledge.com/simpleDataGrid.aspx[^]

[toanthinh]

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

[toanthinh]

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