Use the simplest and most effective code in C # To execute the stored procedure and return data

The stored procedure p_sys_Login is defined as follows:
Create procedure p_sys_Login
@ ArgUserID varchar (20), -- User Name
@ ArgPassword varchar (20), -- Password
@ ArgResult varchar (50) OUTPUT -- logon result
AS
/*
......
*/

The following shows how to use the most concise and effective code in C # To execute the stored procedure and return data:
/// <Summary>
/// User Logon Verification
/// </Summary>
/// <Param name = "userID"> User name </param>
/// <Param name = "password"> password </param>
Public void Login (string userID, string password)
{
// The database connection string is stored in Web. config.
String cnnString = ConfigurationSettings. etettings ["ConnectionString"];
SqlConnection cnn = new SqlConnection (cnnString );

//
String SQL = string. Format ("EXEC p_sys_Login '{0}', '{1}', @ Result OUTPUT ",
UserID, password );
SqlCommand cmd = new SqlCommand (SQL, cnn );

// Create and add parameters corresponding to "@ Result OUTPUT"
SqlParameter paramResult = new SqlParameter ("@ Result", SqlDbType. VarChar, 50 );
ParamResult. Direction = ParameterDirection. Output;
Cmd. Parameters. Add (paramResult );

Cnn. Open ();
Cmd. ExecuteNonQuery ();
Cnn. Close ();

// Obtain the results returned by the Stored Procedure
String result = paramResult. Value. ToString ();

//......
}