带参数存储过程的使用(1)

SqlConnection myConnection = new SqlConnection(SqlConn.Connection);
SqlCommand SqlCommand2 = new SqlCommand("GradeId", myConnection);
SqlCommand2.CommandType = CommandType.StoredProcedure;

SqlCommand2.Parameters.Add("@GradeId", System.Data.SqlDbType.VarChar);
SqlCommand2.Parameters["@GradeId"].Value = Grade;

myConnection.Open();
IDataReader r1 = SqlCommand2.ExecuteReader();
r1.Read();
string GradeName = r1["GradeName"].ToString();
r1.Close();
myConnection.Close();