I'm using an access db and trying to follow along with code for SQL Server.

This is the error message i'm getting:

No value given for one or more required parameters.

Line 65: objConn.Open()
----->Line 66: objCommand.ExecuteNonQuery() <-------
Line 67: objConn.Close()

on line 66.

Sub DBDelDataGrid_Delete(ByVal source As Object, ByVal E As DataGridCommandEventArgs)
        Dim objCommand As OleDbCommand
        Dim strSQLQuery As String

        strSQLQuery = "DELETE FROM zNews WHERE id=" & dgNews.DataKeys(E.Item.ItemIndex) & ";"

        'Response.Write(strSQLQuery)
        'Response.End()

         objCommand = New OleDbCommand(strSQLQuery, objConn)

        objConn.Open()
        objCommand.ExecuteNonQuery()
        objConn.Close()

        ShowDataGrid()

My first thought is that this is not correct:

    E.Item.ItemIndex

By this you are implying that the ID field of your database table is always going to align correctly with the ItemIndex generated by the datagrid for each item (row).

You need to specify where the data for the "ID" column comes from within the datagrid item. Usually you need something like this:

    e.Item.Cells(<index of the ID column>).Text

The index of the ID column will be based on either your original SQL query that got the data for the bind to the data grid (when using AutoGenerateColumns) or the order you placed your columns in the <columns> section of the datagrid HTML.

Peter

Thanks Peter. Both ended up working after I found my error. I forgot that I changed the id column's name...