C# delete database ms.access

Question

I have problem delete data microsoft access database with C# I use this method to add data to microsoft access database

public static int autoIncrement(string kalimatSql)
{
    int lastIndex = -1;
    dbCon.Open();
    dbCmd.CommandText = kalimatSql;
    dbCmd.ExecuteNonQuery();
    dbCmd.CommandText = "Select @@Identity";
    lastIndex = Convert.ToInt32(dbCmd.ExecuteScalar());
    dbCon.Close();
    return lastIndex;
}

I call that method with

myQuiz.id = Global.autoIncrement("INSERT INTO Quizzes (Name) VALUES ('" + myQuiz.name + "')");
Global.quizzes.Add(myQuiz);

I wonder how to delete data from database? if I add with that way?
So far I already try this way

public static int deleteData(string kalimatSQL)
{
    int lastIndex = -1;
    dbCon.Open();
    dbCmd.CommandText = kalimatSQL;
    dbCmd.ExecuteNonQuery();
    dbCon.Close();
    return lastIndex;
}

And I call delete method with this way

if ( listBoxQuizzes.SelectedIndex != -1)  {
    Global.deleteData("DELETE FROM Quizzes WHERE name=" +listBoxQuizzes.SelectedItem.ToString()); 
}

But give error result

"C# Syntax error (missing operator) in query expression 'name = quiz002' " can someone help me fix it?

Vishal Suthar · Accepted Answer · 2014-01-16 04:34:02Z

1

You are missing single quotes around name value ('')

It should be like this:

Global.deleteData("DELETE FROM Quizzes WHERE name = '" + listBoxQuizzes.SelectedItem.ToString() + "'");

answered Jan 16, 2014 at 4:34

Vishal Suthar

17.2k4 gold badges64 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Surya Matadewa Over a year ago

u're right thanks for helped...i will mark u answer as correct one

Collectives™ on Stack Overflow

C# delete database ms.access

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related