Here is my code,please help.Or by the way Faisal Khan.How did you get the results on this tutorial-Viewing/Adding/Editing/Removing Records from MySQL using ASP.NET DataGrid control
Public Sub MyDataGrid_UpdateCommand(ByVal sender As System.Object, ByVal e As DataGridCommandEventArgs)
'*********************************************************************************************
Dim RegistrationNumber As String = e.Item.Cells(1).Text
Dim RegistrationName As String = CType(e.Item.Cells(2).Controls(0), TextBox).Text
Dim PostalAddress As String = CType(e.Item.Cells(3).Controls(0), TextBox).Text
' Dim strTxt As String = CType(e.Item.Cells(4).Controls(0), TextBox).Text
' RegistrationNumber = MyDataGrid.DataKeys(e.Item.ItemIndex)
Dim strConnString As String = "data source=KAKAPA;database=Northwind;User ID=sa; Password=admin; Persist Security Info=True; packet size=4096"
'DataKeyField="RegistrationNumber"
'Construct the SQL statement using Parameters
Dim strSQL As String = "UPDATE [Registers] SET [RegistrationNumber] = @RegistrationNumber, " & _
"[RegistrationName] = @RegistrationName, [PostalAddress] = @PostalAddress " & _
"WHERE [RegistrationNumber] = @RegistrationNumber"
Dim objConn As New SqlConnection(strConnString)
objConn.Open()
Dim myCommand As SqlCommand = New SqlCommand(strSQL, objConn)
myCommand.CommandType = CommandType.Text
' Add Parameters to the SQL query
Dim parameterRegistrationNumber As SqlParameter = New SqlParameter("@RegistrationNumber", SqlDbType.VarChar, 50)
parameterRegistrationNumber.Value = RegistrationNumber
myCommand.Parameters.Add(parameterRegistrationNumber)
Dim parameterRegistrationName As SqlParameter = New SqlParameter("@RegistrationName", SqlDbType.VarChar, 50)
parameterRegistrationName.Value = RegistrationName
myCommand.Parameters.Add(parameterRegistrationName)
Dim parameterPostalAddress As SqlParameter = New SqlParameter("@PostalAddress", SqlDbType.VarChar, 50)
parameterPostalAddress.Value = PostalAddress
myCommand.Parameters.Add(parameterPostalAddress)
myCommand.ExecuteNonQuery() 'Execute the UPDATE query
objConn.Close()
'Finally, set the EditItemIndex to -1 and rebind the DataGrid
MyDataGrid.EditItemIndex = -1
DataBind()
End Sub
