C#调用存储过程

    

string sConnectionString = @"Server=(local)\SQLEXPRESS;database=Forum;Trusted_Connection=True";

04     using (SqlConnection conn = new SqlConnection(sConnectionString))

05     {

06         conn.Open();

07         using (SqlCommand cmd = new SqlCommand("CreateBoard", conn))

08         {

09             cmd.CommandType = CommandType.StoredProcedure;

10             cmd.Parameters.Add("@ClassName", SqlDbType.VarChar, 50);

11             cmd.Parameters["@ClassName"].Value = tbClassName.Text;

12             cmd.Parameters["@ClassName"].Direction = ParameterDirection.Input;

13             cmd.Parameters.Add("@BoardName", SqlDbType.VarChar, 50);

14             cmd.Parameters["@BoardName"].Value = tbBoardName.Text;

15             cmd.Parameters["@BoardName"].Direction = ParameterDirection.Input;

16             cmd.Parameters.Add("@ClassID", SqlDbType.VarChar, 50);

17             cmd.Parameters["@ClassID"].Direction = ParameterDirection.Output;

18             cmd.Parameters.Add("@BoardCount", SqlDbType.Int);

19             cmd.Parameters["@BoardCount"].Direction = ParameterDirection.ReturnValue;

20             cmd.ExecuteNonQuery();

21             foreach (SqlParameter parameter in cmd.Parameters)

22             {

23                 Response.Write(string.Format("参数名: {0}, 参数方向: {1}, 参数值: {2}<br />", parameter.ParameterName, parameter.Direction.ToString(), parameter.Value));

24             }

25         }