关于C#中如何调用有输入参数和输出参数的存储过程

        SqlConnection conn;
        SqlDataAdapter adapter;
        DataSet ds;
        private void Form1_Load(object sender, EventArgs e)
        {
            conn = new SqlConnection("server=.;uid=sa;pwd=123;database=studentdb");
            adapter = new SqlDataAdapter("proc_GetAllStudent", conn);
            ds = new DataSet();
            adapter.Fill(ds, "Students");
            dataGridView1.DataSource = ds.Tables["Students"];
        }

        private void btnSearch_Click(object sender, EventArgs e)
        {
            conn = new SqlConnection("server=.;uid=sa;pwd=123;database=studentdb");
            adapter = new SqlDataAdapter("proc_GetStudentsByName", conn);

            adapter.SelectCommand.CommandType=CommandType.StoredProcedure;
            //定义@name参数(输入参数)
            SqlParameter param=new SqlParameter("@name",txtName.Text);
            adapter.SelectCommand.Parameters.Add(param);
            //定义@count参数(输出参数)
            SqlParameter param1 = new SqlParameter("@count", SqlDbType.Int);
            param1.Direction=ParameterDirection.Output; 
            adapter.SelectCommand.Parameters.Add(param1);

            ds = new DataSet();
            adapter.Fill(ds, "Students");
            dataGridView1.DataSource = ds.Tables["Students"];

            //获得输出参数的值

            lblCount.Text ="查询到"+adapter.SelectCommand.Parameters["@count"].Value.ToString">"+adapter.SelectCommand.Parameters["@count"].Value.ToString()+"人";
        }