一个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();
            

        }