Passing parameters when executing SQL statements in C #

Connect to the database using sqlclient:

Int id = 1;
String name = "lui ";

// Write the added parameter name directly in the SQL statement, regardless of the parameter type.
Sqlcommand cmd = new sqlcommand ("", connection1 );
Cmd. commandtext = "insert into tuserlogin values (@ ID, @ name )";
Cmd. Parameters. Clear ();
Cmd. Parameters. Add ("@ ID", sqldbtype). value = ID;
Cmd. Parameters. Add ("@ name", sqldbtype. varchar). value = Name;
Cmd. executenonquery ();

Use oledb to connect to the database: int id = 1;
String name = "lui ";

// Write the added parameter name directly in the SQL statement, regardless of the parameter type.
Oledbcommandcmd = new oledbcommand ("", connection1 );
Cmd. commandtext = "insert tuserlogin (ID, name) values (?,?) ";
Cmd. Parameters. Clear ();
Cmd. Parameters. Add ("ID", oledbtype). value = ID;
Cmd. Parameters. Add ("name", oledbtype. varchar). value = Name;
Cmd. executenonquery ();