一个listview 一个textbox

存储过程 如下

ALTER PROCEDURE listviewtest
@id char(4)
    /*
    (
    @parameter1 int = 5,
    @parameter2 datatype OUTPUT
    )
    */

AS select * from jjp_student where id=@id   
    /* SET NOCOUNT ON */
    RETURN



数据库如下    id   banji   name
              1     2001    ab
              2     2002    cd
              ................


我要查找文本框里 id是  @id  的班级 和名字  并在  listview显示出来 写了一段代码  有错误 你们看看


   private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection("Data Source=Localhost;Initial Catalog=Master;Integrated Security=SSPI;");
            conn.Open();
            SqlCommand com = new SqlCommand("listviewtest",conn);
             = CommandType.StoredProcedure;
            SqlParameter sp_1 = new SqlParameter("@id", SqlDbType.Int,4);
            //sp_1.Value =Convert.ToInt32(textBox1.Text.Trim());
            sp_1.Value = Convert.ToInt32(this.textBox1.Text.Trim());
            SqlDataReader r = com.ExecuteReader();
            com.ExecuteNonQuery();
            while (r.Read())
            {
                ListViewItem li = new ListViewItem(new string[] { r["id"].ToString(),
            r["banji"].ToString(), r["name"].ToString()});
                listView1.Items.Add(li);
            }
            r.Close();
            conn.Close();
            

        }

com.ExecuteReader();后面的com.ExecuteNonQuery();是干什么用的?
SqlParameter sp_1 = new SqlParameter("@id", SqlDbType.Int,4);中的类型对吗?

 sp_1.Value中的Value好象接收的是OBJECT,不用转吧.

public DataSet RunReturnDataSet(string procedure，SqlParameter[] paras)
        {
            SqlDataAdapter objAdapter = new SqlDataAdapter();
SqlCommand objCommand = new SqlCommand(procedure, objConn);
             = CommandType.StoredProcedure;
if (paras != null)
            {
                foreach (SqlParameter para in paras)
                {
                    objCommand.Parameters.Add(para);
                }
            }
            objAdapter.SelectCommand = objCommand;
            DataSet objDataSet = new DataSet();
            this.Close();
            objAdapter.Fill(objDataSet);
            return objDataSet;
        }