Arnold Petrona

Arnold Petrona

  • NA
  • 159
  • 0

csharp delete Query

Sep 16 2008 2:57 PM

I have a issue with the delete query from a combobox1 connected to a database and is as follow

 

OleDbConnection con1 = new OleDbConnection(@" Provider = Microsoft.Jet.OleDB.4.0;Data Source =C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\2Timers\2Timers\db2.mdb");

            try
            {
                string qdel = "DELETE * FROM 2Timers WHERE Name=" + comboBox1.SelectedItem.ToString();
                OleDbCommand command = new OleDbCommand(qdel, con1);

                con1.Open();
                command.ExecuteNonQuery();
                con1.Close();
                this.DialogResult = DialogResult.OK;
                this.Dispose();
            }
            catch (OleDbException ex)
            {
                MessageBox.Show("Ole error:" + ex.Message, "Ole Error");
            } 

 

the message received is no value given for one or more required paramters

 


Answers (7)