C # use a pre-processing SQL statement to access MySQL (Parameter)

Code:

MySqlConnection con = null;
MySqlCommand cmd = null;
String nameStr = "Sample value passed "";
Con = new MySqlConnection ("server = localhost; database = db_name; uid = user; pwd = password; pooling = false ;");
Con. Open ();
Cmd = new MySqlCommand ("insert into MyTable values (null ,? ParName); ", con );
Cmd. Parameters. AddWithValue ("? ParName ", (string) nameStr. Replace (", "^ "));
Cmd. ExecuteNonQuery ();
Con. Close ();

The parameter starts with a question mark, such? ParName

Then create Command

Set

. Parameters. AddWithValue can be used to set the value of each parameter.

This is not difficult for you, but I will find my own. NET documents for the first time.