Missing semicolon (;) at end of SQL statement

Question

Hello,

I have delete function and it doesn't function. I got this error:
"Missing semicolon (;) at end of SQL statement." even though I have a semicolon sign at the end of that statement.

Here is my code:
try
{
OleDbCommand commandbrisi = new OleDbCommand();
commandbrisi.CommandText = "Delete from Kazneti where Imeprezime = ? and Adresa = ? order by Rbr asc";
commandbrisi.Parameters.AddWithValue("@imeprez", txtImePrez.Text);
commandbrisi.Parameters.AddWithValue("@adresa", txtAdresa.Text);
commandbrisi.Connection = conn;
conn.Open();

OleDbDataAdapter oleDBDataAdapter1 = new OleDbDataAdapter(new OleDbCommand("Update * from Kazneti", conn));

commandbrisi.ExecuteNonQuery();//here is the error

_dataset.Clear();
oleDBDataAdapter1.Fill(_dataset, "Kazneti");
}

finally
{
conn.Close();
}

Vulpes · Answer

That's actually a SQL error rather than a C# error. I suspect the problem is in this line: commandbrisi.CommandText = "Delete from Kazneti where Imeprezime = ? and Adresa = ? order by Rbr asc"; where you don't want the order by clause at the end of the Delete statement: commandbrisi.CommandText = "Delete from Kazneti where Imeprezime = ? and Adresa = ?";

Nel · Answer

Thank you. You both have helped me but Vulpes was first that's why I will check his answer as correct, eventhough I would like to be able to check them both as correct answers.

Nel · Answer

Thanks

Satyapriya Nayak · Answer

Hi Nel, Try like this ..... OleDb Connection con=new OleDb Connection("connection string"); OleDbCommand com; OleDBDataAdapter sqlda; string str; private void btndelete_Click(object sender, System.EventArgs e) { str = "delete from student where sid=@sid"; com = new OleDbCommand(str, con); com.Parameters.Add("@sid", txtid.Text); con.Open(); com.ExecuteNonQuery(); MessageBox.Show("Records Successfuly Deleted"); con.Close(); } private void btnupdate_Click(object sender, System.EventArgs e) { con.Open(); str = "update student set sname=@sname,smarks=@smarks,saddress=@saddress,year=@year where sid=@sid"; com = new OleDbCommand(str, con); com.Parameters.Add("@sid", txtid.Text); com.Parameters.Add("@sname", txtname.Text); com.Parameters.Add("@smarks", txtmarks.Text); com.Parameters.Add("@saddress", txtaddress.Text); com.Parameters.Add("@year", txtyear.Text); com.ExecuteNonQuery(); con.Close(); MessageBox.Show("Records Successfuly Updated"); } Thanks If this post helps you mark it as answer

Prabhu Raja · Answer

Hi, try this one. commandbrisi.CommandText = "Delete from Kazneti where Imeprezime = @imeprez and Adresa = @adresa "; commandbrisi.Parameters["@imeprez"].Value = txtImePrez.Text; commandbrisi.Parameters["@adresa"].Value = txtAdresa.Text;

Dhaval Patel · Answer

Dear nel you have to change query update * from Kazneti to select * from Kazneti in this line OleDbDataAdapter oleDBDataAdapter1 = new OleDbDataAdapter(new OleDbCommand("Update * from Kazneti", conn));

Missing semicolon (;) at end of SQL statement

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (6)