hello
i want insert data in acces file whit the query
string query = "INSERT INTO [USER] (Use_Sgi, Use_FirstName, Use_LastName, Use_Email, Use_MobilePhone, Use_BusinessPhone, Com_ID, Loc_ID ) values (@sgi,@nom,@prenom,@email,@telephonefix,@telphonemobile,@company,@localiter); select @@identity()";
OleDbCommand cmd = new OleDbCommand(query, con);
cmd.Parameters.AddWithValue("@sgi", txtsgi.Text);
cmd.Parameters.AddWithValue("@nom", txtnom.Text);
cmd.Parameters.AddWithValue("@prenom", txtprenom);
cmd.Parameters.AddWithValue("@email", txtemail);
cmd.Parameters.AddWithValue("@telphonefix", txttelphonefix);
cmd.Parameters.AddWithValue("@telphonemobile", txttelephonemobile);
cmd.Parameters.AddWithValue("@company", cbocompany.Text);
cmd.Parameters.AddWithValue("@localiter", cbolocaliter.Text);
con.Open();
var NewIdentity = cmd.ExecuteScalar();
con.Close();
i have error characters found after end of sql statement access
What I have tried:
How can I fix this issue ! Thx in advance