Hi,
Did anybody knows how to use delete sql statement? I'm using this:
Private Sub DataGrid1_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.DeleteCommand
Dim i As Integer = e.Item.ItemIndex
Dim mtitle As String = DataGrid1.DataKeys(e.Item.ItemIndex)
Dim strConn2 As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & Server.MapPath("movie.mdb")
Dim cmd As New OleDbCommand("DELETE from movieDet WHERE Title = '" + mtitle + "' ")
cmd.Connection.Open()
cmd.ExecuteNonQuery()
cmd.Connection.Close()
End Sub
i use this for the link button in datagrid. But ther is an error when run in this line: cmd.Connection.Open()
It says that Object reference not set to an instance of an object.
Help pls...
Did anybody knows how to use delete sql statement? I'm using this:
Private Sub DataGrid1_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.DeleteCommand
Dim i As Integer = e.Item.ItemIndex
Dim mtitle As String = DataGrid1.DataKeys(e.Item.ItemIndex)
Dim strConn2 As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & Server.MapPath("movie.mdb")
Dim cmd As New OleDbCommand("DELETE from movieDet WHERE Title = '" + mtitle + "' ")
cmd.Connection.Open()
cmd.ExecuteNonQuery()
cmd.Connection.Close()
End Sub
i use this for the link button in datagrid. But ther is an error when run in this line: cmd.Connection.Open()
It says that Object reference not set to an instance of an object.
Help pls...