asp.net 存储过程执行实例

protected void Page_Load(object sender, EventArgs e)
    {
        /*
        sql脚本-创建学生表
        create table student(id int,name varchar(50))
        insert into student select 1,'小张'
        insert into student select 2,'小王'
       
        存储过程 功能：查询学生名称
        create proc proc_getName
        @id int,
        @name varchar(50) output
        as
        begin
        if exists(select 1 from student where id=@id)
        select @name=name from student where id=@id
        else
        set @name='--未找到学生--'
        end
        */
    }
    //执行存储过程
    public void RunProcedure(string storedProcName, IDataParameter[] parameters)
    {
        string connectionString = "server=.;database=my;uid=sa;pwd=bb";//数据库连接串
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            DataSet dataSet = new DataSet();
            connection.Open();
            SqlDataAdapter sqlDA = new SqlDataAdapter();