inserting a text with a side on the database

Question

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?

Ranjit Powar · Answer

hey sorry. The correct code is below cmd.Parameters.AddWithValue(@nom txte_nom.Text); This will work.

abdelwaheb ammar · Answer

but why you add  with @nom? and if the user insert other name without  or add Double coast ()? how can i solve that?

Ranjit Powar · Answer

use parameters. Like insert into CLIENT (nom) values(@nom ) ; cmd.Parameters.AddWithValue(@nom txte_nom.Text);