c# gridview 实现 下拉框批量修改

 //定义状态，分类，厂别id全局变量
        public int FGRoupID;
        public int FStatus;
        public int FProduce;

 //批量修改
        private void button2_Click(object sender, EventArgs e)
        {
            DataSource ds = new DataSource();
            SqlConnection conn = ds.GetConn();
            conn.Open();
            获取勾选的内容
            DataTable dt1 = new DataTable();    
            ClassGrid.ReturnData(gridControl1, gridView1);
            dt1 = ClassData.dt;
            int FID = 0;
            try
            {
                if (dt1.Rows.Count > 0)
                {
                    for (int i = 0; i < dt1.Rows.Count; i++)
                    {
                        //string number = dt1.Rows[i][4].ToString();//获取主表id
                        //string value1 = dt1.Rows[i][7].ToString();//分类编辑
                        //string value2 = dt1.Rows[i][8].ToString();//状态编辑
                        //string value3 = dt1.Rows[i][9].ToString();//厂别编辑
                        //string sql = @"update PMC_Material set SecGroupid = (select id from PMC_Group where name = '" + value1 + "'and status=1)," +
                        //    "stateid=(select id from PCM_MaterialStatus where name = '" + value2 + "'and status=1),Produceid=(select id from PMC_Produce  " +
                        //    "where name = '" + value3 + "'and status=1)" +
                        //    " where Number = '" + number + "'";

                        FID = Convert.ToInt32(dt1.Rows[i]["ID"]);//获取选择的每行id

                        String StrSql = "Update PMC_Material set SecGroupid=" + FGRoupID+"Where ID="+FID+";";
                        StrSql = StrSql + "Update PMC_Material set stateid=" + FStatus + "Where ID=" + FID + ";";
                        StrSql = StrSql + "Update PMC_Material set Produceid="+ FProduce + "Where ID = "+FID+"; ";
                        SqlCommand comm = new SqlCommand(StrSql, conn);
                        comm.ExecuteNonQuery();
                    }
                    DataBindGoup();
                    DataBindStatus();
                    DataBindProduce();
                    DataBind();
                    MessageBox.Show("修改成功！");
                    conn.Close();

                }
            }catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            FGRoupID = 0;
            FStatus = 0;
            FProduce = 0;

        }
//获取货品状态选中id
 private void comboBox1_SelectedValueChanged(object sender, EventArgs e)
        {

            DataRowView dr1 = comboBox1.SelectedItem as DataRowView;

            if (dr1 != null)
            {
                string a1 = dr1["ID"].ToString();

                FStatus = Convert.ToInt32(dr1["ID"]);
            }

        }
//获取分类选中id
        private void comboBox2_SelectedValueChanged(object sender, EventArgs e)
        {
            DataRowView dr1 = comboBox2.SelectedItem as DataRowView;

            if (dr1 != null)
            {
                string a1 = dr1["ID"].ToString();

                FGRoupID = Convert.ToInt32(dr1["ID"]);
            }
        }
//获取厂别选中id
        private void comboBox3_SelectedValueChanged(object sender, EventArgs e)
        {
            DataRowView dr1 = comboBox3.SelectedItem as DataRowView;

            if (dr1 != null)
            {
                string a1 = dr1["ID"].ToString();
                FProduce = Convert.ToInt32(dr1["ID"]);
            }
        }