Calling stored procedures in C #

[CSharp] View plain copy print?stringstrSQL ="Data source=192.168.24.53;initial Catalog=jf_charging_system; Persist Security info=true; User Id=sa; Password=1";//Database Link Stringstringsql ="Myinsert";//the name of the stored procedure to invokeSqlConnection Constr =NewSqlConnection (strSQL);//SQL database Connection object, with database link string as parameterSqlCommand Comstr =NewSqlCommand (SQL, CONSTR);//The SQL statement executes the object, the first argument is the statement to execute, and the second is the database connection objectComstr.commandtype = CommandType.StoredProcedure;//because you want to use a stored procedure, set the execution type to the stored procedure//set parameters for the stored procedure in turnCOMSTR.PARAMETERS.ADD ("@username", SqlDbType.VarChar,Ten). Value =" One"; COMSTR.PARAMETERS.ADD ("@password", SqlDbType.VarChar,Ten). Value =" One"; COMSTR.PARAMETERS.ADD ("@name", SqlDbType.VarChar,Ten). Value =" One"; COMSTR.PARAMETERS.ADD ("@usertype", SqlDbType.VarChar,Ten). Value =" One"; COMSTR.PARAMETERS.ADD ("@createpeople", SqlDbType.VarChar,Ten). Value =" One"; Constr.open ();//Open a database connectionMessageBox.Show (Comstr.executenonquery (). ToString ());//Executing stored proceduresConstr.close ();//Close Connection

Calling stored procedures in C #