Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- System.Data.OleDb.OleDbException' occurred in System.Data.dll
- Query input must contain at least one table or query.
- OleDbConnection con = new OleDbConnection(stringcon);
- OleDbCommand cmd = new OleDbCommand();
- cmd.Connection = con;
- cmd.CommandText = "INSERT INTO [clients]([Firstname],[Lastname],[Email],[Phonenumber],[Address],[CNP],[SeriesCI],[NumberCI],[Sex],[CUI],[J],[Personaldescription],[Temperament],[Provenance],[Registerdata],[Idteam]) " +
- "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)) ";
- // cmd.CommandText = "INSERT INTO [clients]([Firstname],[Lastname],[Email],[Phonenumber],[Address],[CNP],[SeriesCI],[NumberCI],[Sex],[CUI],[J],[Personaldescription],[Temperament],[Provenance],[Registerdata]) " +
- //"VALUES(@f,@l,@e,@ph,@add,@cnp,@ser,@n,@sex,@cui,@j,@pd,@te,@prov,@reg) ";
- cmd.Parameters.AddWithValue("@f", materialSingleLineTextField16.Text);
- cmd.Parameters.AddWithValue("@l", materialSingleLineTextField15.Text);
- cmd.Parameters.AddWithValue("@e", materialSingleLineTextField14.Text);
- cmd.Parameters.AddWithValue("@ph", materialSingleLineTextField13.Text);
- cmd.Parameters.AddWithValue("@add", materialSingleLineTextField6.Text);
- cmd.Parameters.AddWithValue("@cnp", materialSingleLineTextField1.Text);
- cmd.Parameters.AddWithValue("@ser", materialSingleLineTextField3.Text);
- cmd.Parameters.AddWithValue("@n", materialSingleLineTextField2.Text);
- cmd.Parameters.AddWithValue("@sex", gender);
- cmd.Parameters.AddWithValue("@cui", materialSingleLineTextField4.Text);
- cmd.Parameters.AddWithValue("@j", materialSingleLineTextField5.Text);
- cmd.Parameters.AddWithValue("@pd", richTextBox2.Text);
- cmd.Parameters.AddWithValue("@te", bunifuDropdown1.selectedValue);
- cmd.Parameters.AddWithValue("@prov", bunifuDropdown2.selectedValue);
- cmd.Parameters.AddWithValue("@reg", DateTime.Now.ToString("dd-MM-yyyy HH: mm:ss"));
- cmd.Parameters.AddWithValue("@email", Form1.Email);
- con.Open();
- cmd.ExecuteNonQuery();
- con.Close();
Add Comment
Please, Sign In to add comment