在datagridriew表内修改数据

 

首先在datagridriew属性设置AllowUserToAddRows设为false;AllowUserToDeleteRows设为false;

在到button事件：

private void button17_Click(object sender, EventArgs e)//修改表内事件
        {
            dataGridView3.DefaultCellStyle.BackColor = Color.Beige;
            for (int f = 0; f < dataGridView3.Rows.Count; f++)
            {
                for (int r = 0; r < dataGridView3.ColumnCount; r++)
                {
                    if (r < 1)
                    {
                        dataGridView3.Rows[f].Cells[r].ReadOnly = true;
                    }
                }

            }

 

 private void button18_Click(object sender, EventArgs e)//这是保存表内事件
        {
            dataGridView3.DefaultCellStyle.ForeColor = Color.Wheat;
            conn.Open();
            for (int t = 0; t <dataGridView3.Rows.Count; t++)
            {
                string gh1 = dataGridView3.Rows[t].Cells[0].Value.ToString();
                string gh2 = dataGridView3.Rows[t].Cells[2].Value.ToString();
                string gh3 = dataGridView3.Rows[t].Cells[3].Value.ToString();
                string gh4 = dataGridView3.Rows[t].Cells[4].Value.ToString();
                string gh5 = dataGridView3.Rows[t].Cells[5].Value.ToString();
                string gh6 = dataGridView3.Rows[t].Cells[6].Value.ToString();
                string gh7 = dataGridView3.Rows[t].Cells[7].Value.ToString();
                string gh8 = dataGridView3.Rows[t].Cells[8].Value.ToString();
                string gh9 = dataGridView3.Rows[t].Cells[9].Value.ToString();
                string gh10 = dataGridView3.Rows[t].Cells[10].Value.ToString();
                string gh11 = dataGridView3.Rows[t].Cells[11].Value.ToString();
                string gh12 = dataGridView3.Rows[t].Cells[12].Value.ToString();
                string gh13 = dataGridView3.Rows[t].Cells[13].Value.ToString();
                string gh14 = dataGridView3.Rows[t].Cells[14].Value.ToString();
                string gh15 = dataGridView3.Rows[t].Cells[15].Value.ToString();
                string gh16 = dataGridView3.Rows[t].Cells[16].Value.ToString();
                string gh17 = dataGridView3.Rows[t].Cells[17].Value.ToString();
                string gh18 = dataGridView3.Rows[t].Cells[18].Value.ToString();
                string gh19 = dataGridView3.Rows[t].Cells[19].Value.ToString();
                string gh20 = dataGridView3.Rows[t].Cells[20].Value.ToString();
                string gh21 = dataGridView3.Rows[t].Cells[21].Value.ToString();
                //string qee = " aa='" + gh1 + "',
                SqlCommand qee = new SqlCommand("select * from mohe where aa='" + gh2 + "'and bb='" + gh3 + "' and cc='" + gh4 + "' and dd='" + gh5 + "' and ee='" + gh6 + "'and ff='" + gh7 + "' and gg='" + gh8 + "' and hh='" + gh9 + "' and ii='" + gh10 + "' and jj='" + gh11 + "' and kk='" + gh12 + ", and ll='" + gh13 + "' and mm='" + gh14 + "' and nn='" + gh15 + "' and oo='" + gh16 + "' and  pp='" + gh17 + "'and qq='" + gh18 + "' and rr='" + gh19 + "'and ss='" + gh20 + "' and zz='" + gh21 + "' ", conn);
                SqlCommand qff = new SqlCommand("update mohe set aa='" + gh2 + "',bb='" + gh3 + "',cc='" + gh4 + "',dd='" + gh5 + "',ee='" + gh6 + "',ff='" + gh7 + "',gg='" + gh8 + "',hh='" + gh9 + "',ii='" + gh10 + "',jj='" + gh11 + "', kk='" + gh12 + "',ll='" + gh13 + "',mm='" + gh14 + "',nn='" + gh15 + "',oo='" + gh16 + "', pp='" + gh17 + "',qq='" + gh18 + "', rr='" + gh19 + "',ss='" + gh20 + "',zz='" + gh21 + "' where id ='" + gh1 + "'", conn);
                qff.ExecuteNonQuery();
                //conn.Close();
            }
            if (dataGridView3.Rows.Count > 0)
            {
                MessageBox.Show("表内修改成功", "窗口提示！");
            }
               

        }