适配器怎样用存储过程？

 1             SqlConnection conn = new SqlConnection("Data Source=SHILONGWEI;Initial Catalog=Test;Integrated Security=True");
 2             SqlCommand cmd = new SqlCommand("proc_getpubstable", conn);  //存储过程的名字
 3             cmd.CommandType = CommandType.StoredProcedure;   //指定存储过程
 4             //cmd.Parameters.Add("@table_name", SqlDbType.NVarChar).Value = "userName";
 5             SqlParameter para1 = new SqlParameter("@table_name", SqlDbType.NVarChar, 50); //需要向存储过程传递的参数
 6             cmd.Parameters.Add(para1);
 7             para1.Value="userName";
 8             DataSet ds = new DataSet();  
 9             conn.Open();  
10             SqlDataAdapter dap = new SqlDataAdapter();
11             dap.SelectCommand = cmd;
12             dap.Fill(ds);
13             conn.Close();
14             GridView1.DataSource = ds;
15             GridView1.DataBind();