C#调用存储过程

来源：互联网发布：新人网络写手在哪投稿编辑：程序博客网时间：2024/05/22 12:04

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 }