form1.cs

来自「csharp课本的源代码」· CS 代码 · 共 54 行

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace StoreProcedureExample2
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection conn =
                new SqlConnection(Properties.Settings.Default.MyDatabaseConnectionString);
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            //设置SQL语句为存储过程名，命令类型为存储过程
            cmd.CommandText = "TongJiChengJi";
            cmd.CommandType = CommandType.StoredProcedure;
            //添加存储过程中参数需要的初始值，注意参数名要和存储过程定义的参数名相同
            cmd.Parameters.AddWithValue("@surname", "王");
            cmd.Parameters.AddWithValue("@sumValue", 0);
            cmd.Parameters.AddWithValue("@record", 0);
            //指定哪些参数需要返回结果
            cmd.Parameters["@sumValue"].Direction = ParameterDirection.Output;
            cmd.Parameters["@record"].Direction = ParameterDirection.Output;
            try
            {
                conn.Open();
                //执行存储过程
                cmd.ExecuteNonQuery();
                //显示返回的结果
                MessageBox.Show(string.Format("有{0}条姓王的记录，合计成绩为{1}",
                    cmd.Parameters["@record"].Value, cmd.Parameters["@sumValue"].Value));
            }
            catch (Exception err)
            {
                MessageBox.Show(err.Message);
            }
            finally
            {
                conn.Close();
            }
        }

    }
}