遍历DataList上的复选框提交更新数据

 1            sqlConnection1.Open();
 2            SqlCommand cmd=new SqlCommand("update jobs set job_desc=@job_desc where job_id=@job_id", sqlConnection1);
 3            cmd.Parameters.Add(new SqlParameter("@job_id",SqlDbType.SmallInt,2));
 4            cmd.Parameters.Add(new SqlParameter("@job_desc",SqlDbType.VarChar,50));
 5            foreach (DataListItem item in DataList2.Items)
 6            {
 7                CheckBox cb=(CheckBox)item.Controls[1];
 8                if (cb.Checked)
 9                {
10                    Label lbl=(Label)item.Controls[3];
11                    TextBox txt=(TextBox)item.Controls[5];
12                    cmd.Parameters["@job_id"].Value=lbl.Text;
13                    cmd.Parameters["@job_desc"].Value=txt.Text;
14                    cmd.ExecuteNonQuery();
15                }
16            }
17            sqlConnection1.Close();