error in deleting a gridview

Question

User1253203540 posted

hello, i have a problem when i try ot delete a row in a gridview, everythiing is display ok except when the delete function is run. There are three columns in my Access, ID = Auto First & Last Name = Text

the error says data type mismatch in criteria expression -> cmd.ExceuteNonQuery();

This is the code for delete:

protected void ResultGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

string Connection = "Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source=D:/Customers.mdb";

OleDbConnection con = new OleDbConnection(Connection);

OleDbCommand cmd = new OleDbCommand();

cmd.Connection = con;

cmd.CommandText ="delete from tblCustomers where ID='" + ResultGridView.DataKeys[e.RowIndex].Values[0].ToString() + "'";

con.Open();

cmd.ExecuteNonQuery();

con.Close();

FillVendorGrid();

}

Answer 1

User-1835425756 posted

the datatype of "ID" is integer and u passed the string. that is the problem.

do this

Convert.ToInt32(ResultGridView.DataKeys[e.RowIndex].Values[0].ToString());

hope this will help.

Answer 2

User-1716253493 posted

try this (remove ' around idvalue)

cmd.CommandText =

"delete from tblCustomers where ID=" + ResultGridView.DataKeys[e.RowIndex].Values[0].ToString();

Answer 3

User3866881 posted

ResultGridView.DataKeys[e.RowIndex].Values[0].ToString()

Hi，

If your ID is type of int，you cannot add a single quote.