Guest User

Untitled

a guest
Mar 17th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.36 KB | None | 0 0
  1. System.Data.OleDb.OleDbException' occurred in System.Data.dll
  2. Query input must contain at least one table or query.
  3.  
  4. OleDbConnection con = new OleDbConnection(stringcon);
  5. OleDbCommand cmd = new OleDbCommand();
  6.  
  7. cmd.Connection = con;
  8. cmd.CommandText = "INSERT INTO [clients]([Firstname],[Lastname],[Email],[Phonenumber],[Address],[CNP],[SeriesCI],[NumberCI],[Sex],[CUI],[J],[Personaldescription],[Temperament],[Provenance],[Registerdata],[Idteam]) " +
  9. "VALUES(@f,@l,@e,@ph,@add,@cnp,@ser,@n,@sex,@cui,@j,@pd,@te,@prov,@reg,(select team.id from team where team.Email=@email)) ";
  10.  
  11. // cmd.CommandText = "INSERT INTO [clients]([Firstname],[Lastname],[Email],[Phonenumber],[Address],[CNP],[SeriesCI],[NumberCI],[Sex],[CUI],[J],[Personaldescription],[Temperament],[Provenance],[Registerdata]) " +
  12. //"VALUES(@f,@l,@e,@ph,@add,@cnp,@ser,@n,@sex,@cui,@j,@pd,@te,@prov,@reg) ";
  13.  
  14.  
  15. cmd.Parameters.AddWithValue("@f", materialSingleLineTextField16.Text);
  16. cmd.Parameters.AddWithValue("@l", materialSingleLineTextField15.Text);
  17. cmd.Parameters.AddWithValue("@e", materialSingleLineTextField14.Text);
  18. cmd.Parameters.AddWithValue("@ph", materialSingleLineTextField13.Text);
  19. cmd.Parameters.AddWithValue("@add", materialSingleLineTextField6.Text);
  20. cmd.Parameters.AddWithValue("@cnp", materialSingleLineTextField1.Text);
  21. cmd.Parameters.AddWithValue("@ser", materialSingleLineTextField3.Text);
  22. cmd.Parameters.AddWithValue("@n", materialSingleLineTextField2.Text);
  23. cmd.Parameters.AddWithValue("@sex", gender);
  24. cmd.Parameters.AddWithValue("@cui", materialSingleLineTextField4.Text);
  25. cmd.Parameters.AddWithValue("@j", materialSingleLineTextField5.Text);
  26. cmd.Parameters.AddWithValue("@pd", richTextBox2.Text);
  27. cmd.Parameters.AddWithValue("@te", bunifuDropdown1.selectedValue);
  28. cmd.Parameters.AddWithValue("@prov", bunifuDropdown2.selectedValue);
  29. cmd.Parameters.AddWithValue("@reg", DateTime.Now.ToString("dd-MM-yyyy HH: mm:ss"));
  30. cmd.Parameters.AddWithValue("@email", Form1.Email);
  31.  
  32.  
  33. con.Open();
  34.  
  35. cmd.ExecuteNonQuery();
  36. con.Close();
Add Comment
Please, Sign In to add comment