Loading

inserting a text with a side on the database

abdelwaheb ammar

Hello, I create an insert query the database but

"insert into CLIENT (nom)  values('"+texte_nom.text+"')";

but during insertion test I but the name "M'hamed" it shows me an error that meant that the dimension (M'H) poses a problem. are there a solution that allows you to put ready inserted the name without this error?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ranjit Powar10y ago
hey sorry. The correct code is below
cmd.Parameters.AddWithValue("@nom", txte_nom.Text);
This will work.
0
abdelwaheb ammar10y ago
but why you add " with @nom? and if the user insert other name without " or add Double coast (")? how can i solve that?
0

Ranjit Powar10y ago

use parameters. Like

"insert into CLIENT (nom)  values(@nom)";

  cmd.Parameters.AddWithValue("@nom, txte_nom.Text);

0