Missing semicolon (;) at end of SQL statement

Sign in to answer this question.

• 

  Vulpes15y agoPosted Oct 19, 2011, 4:46 AM

  Accepted 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 = ?";
• N

  Nel15y agoPosted Oct 19, 2011, 6:16 AM

  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.
• N

  Nel15y agoPosted Oct 19, 2011, 6:15 AM

  Thanks
• 

  Satyapriya Nayak15y agoPosted Oct 19, 2011, 6:06 AM

  Hi Nel,
  
  Try like this .....
  
  OleDbConnection con=new OleDbConnection("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 Raja15y agoPosted Oct 19, 2011, 5:59 AM

  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 Patel15y agoPosted Oct 19, 2011, 4:50 AM

  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));