C # Call the stored procedure with output parameters,

C # Call the stored procedure with output parameters,

Write a stored procedure in SQL server:

1. Create procedure ProGetPWD
2. @ Username varchar (20 ),
3. @ Password varchar (20) OUTPUT
4. AS
5. BEGIN
6. SELECT @ password = password
7. FROM Users
8. WHERE username = @ username
9. END

--------------------------

The following describes how to call a stored procedure in. NET:

1. String strConnection = "user id = sa; password = sa; initial catalog = MyTest; Server = YHB; Connect Timeout = 30 ";
2. Using (SqlConnection conn = new SqlConnection (strConnection ))
3. {
4. Conn. Open ();
5. Using (SqlCommand sqlComm = conn. CreateCommand ())
6. {
7. // Set the name of the stored procedure to be called
8. SqlComm. CommandText = "GetPWD ";
9. // Specify the name of the stored procedure passed to the database by the SqlCommand object instead of the SQL statement.
10. SqlComm. CommandType = CommandType. StoredProcedure;
12. SqlParameter username = sqlComm. Parameters. Add (new SqlParameter ("@ username", SqlDbType. VarChar, 20 ));
13. // Specify "@ username" as the input parameter
14. Username. Direction = ParameterDirection. Input;
15. // Assign a value to the "@ username" parameter
16. Username. Value = this.txt _ username. Text;
18. SqlParameter password = sqlComm. Parameters. Add (new SqlParameter ("@ password", SqlDbType. VarChar, 20 ));
19. // Specify "@ password" as the output parameter
20. Password. Direction = ParameterDirection. Output;
21. // Execute
22. SqlComm. ExecuteNonQuery ();
23. // Obtain the value of the output parameter and assign the value to the name. Note that the value is of the object type, and the type rotation is required.
24. String passwrod = Convert. ToString (sqlComm. Parameters ["@ password"]. Value );
25. MessageBox. Show (passwrod );
26. }
27. }