General steps for using parameters for database insertion

1. Insert data using commands

Sqlcommand sqlcmd = new sqlcomand ("insert into table (" iditem "," nameitem "," sexitem ") values (@ ID, @ name, @ sex)", con)

2. Create Parameters

Sqlcom. paramaters. Add (New sqlparamater ("@ ID", sqldbtype. varchar, 10); the ID attribute in the database to be inserted. It must be associated with the databaseThe attributes of iditem are consistent;

3. Set the parameter value

Sqlcom. paramaters ("ID"). value = "yangbo"

4. Execute

Sqlcom. executenonquery ();