datagridview 数据处理方法 修改 删除 添加 下拉类表

Datagridview的三种处理数据方法一、第一种方法常规方法，在窗口界面上放入一个datagridview，在放各个textbox，然后通过选取对应的记录，修改textbox的值，所有的操作都在一个界面上进行，没什么多说的，大部分方法都这么做二、弹出窗口方式此方式，通过双击记录，或者是利用按钮操作，倾向于用按钮方式，一次修改或添加、删除一条记录。

利用窗口传值方式，实现数据输入、输出，datagridview的显示跟新。

特点：1。

父子窗口之间的双向传值，很有参考意义2.父子窗体监combox绑定数据表条件下，双向传值，很多资料接收的都不是很清晰，主要是利用了combox.findstring()这个方法，传递回index，利用index得到value，好绕啊，废了很大劲。

3.datagridview修改、添加数据下，不用重新访问数据库，而是直接显示修改的结果，这样感觉反应速度快，很有意义。

具体如下修改界面添加界面主窗口代码using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;using monClass;namespace WDZ{public partial class frmMain2 : Form{public frmMain2(){InitializeComponent();}private void frmMain2_Load(object sender, EventArgs e){this.dataGridView1.AutoSizeColumnsMode =System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill; //表格自适应宽度//DataCon datacon = new DataCon();//加载数据DataOperate dataoperate = new DataOperate();string strSql = "select * from sql3 ";DataSet ds = dataoperate.getDs(strSql, "sql3");dataGridView1.DataSource = ds.Tables[0];//设置datagridview属性dataGridView1.Columns[0].ReadOnly = true; //列不可编写dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; //选择全行//dataGridView1.ReadOnly = true; //只读dataGridView1.DefaultCellStyle.SelectionBackColor = Color.YellowGreen; //选择的行为颜色//最后一行的星号行不显示，不允许用户添加数据dataGridView1.AllowUserToAddRows = false;//*************************//加载下拉列表框BindSex(); // 绑定性别下拉列表框cmb_Temp.Visible = false; // 设置下拉列表框不可见// 添加下拉列表框事件cmb_Temp.SelectedIndexChanged += newEventHandler(cmb_Temp_SelectedIndexChanged);// 将下拉列表框加入到DataGridView控件中this.dataGridView1.Controls.Add(cmb_Temp);}/////**************************************************//datagridview中下拉类表框的绑定private ComboBox cmb_Temp = new ComboBox();///绑定性别下拉列表框///private void BindSex(){DataTable dtSex = new DataTable();DataOperate dataoperate = new DataOperate();string strSql = "select * from user_class ";DataSet ds = dataoperate.getDs(strSql, "user_class");dtSex = ds.Tables[0];cmb_Temp.ValueMember ="user_class_id"; //设置隐含的形式显示数值，起对应一定的名称//cmb_Temp.ValueMember = "user_class";cmb_Temp.DisplayMember = "user_class";cmb_Temp.DataSource = dtSex;cmb_Temp.DropDownStyle =ComboBoxStyle.DropDownList; //只能选择，不能写入//cmb_Temp.DropDownStyle =ComboBoxStyle.DropDown; //可以写入// cmb_Temp.DropDownStyle = ComboBoxStyle.Simple;}///// 当用户选择下拉列表框时改变DataGridView单元格的内容private void cmb_Temp_SelectedIndexChanged(object sender, EventArgs e){if (dataGridView1.CurrentCell != null){DataRowView myrowview = (DataRowView)cmb_Temp.SelectedItem;//dataGridView1.CurrentCell.Value = cmb_Temp.SelectedValue.ToString(); dataGridView1.CurrentCell.Value = myrowview[2].ToString();//选取的文本 dataGridView1.CurrentCell.Tag = cmb_Temp.SelectedValue; //选取的编码// MessageBox.Show("text:" + cmb_Temp.SelectedText + "-item:" +cmb_Temp.SelectedItem.ToString() + "-value:" + cmb_Temp.SelectedValue.ToString()+"-index:"+cmb_Temp.SelectedIndex.ToString());// DataRowView myrowview = (DataRowView)cmb_Temp.SelectedItem;// MessageBox.Show(myrowview[0].ToString()+"--"+myrowview[1].ToString()+"--"+myrowview[2].ToString()); //获得对应的value和text}}private void dataGridView1_CurrentCellChanged_1(object sender, EventArgs e) {// 当用户移动到性别这一列时单元格显示下拉列表框try{if (dataGridView1.CurrentCell.ColumnIndex == 3){Rectangle rect =dataGridView1.GetCellDisplayRectangle(dataGridView1.CurrentCell.ColumnIndex, dataGridView1.CurrentCell.RowIndex, false);string sexValue = dataGridView1.CurrentCell.Value.ToString();//MessageBox.Show(sexValue);cmb_Temp.Text = sexValue;cmb_Temp.Left = rect.Left;cmb_Temp.Top = rect.Top;cmb_Temp.Width = rect.Width;cmb_Temp.Height = rect.Height;cmb_Temp.Visible = true;}else{cmb_Temp.Visible = false;}}catch{}}private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e){if (e.ColumnIndex == 0){DataGridView dgv = sender as DataGridView;if (dgv.Rows[e.RowIndex].Cells[1].Value != null){string id = dgv.Rows[e.RowIndex].Cells[0].Value.ToString();string user_id = dgv.Rows[e.RowIndex].Cells[1].Value.ToString();string user_password=dgv.Rows[e.RowIndex].Cells[2].Value.ToString();string user_class = dgv.Rows[e.RowIndex].Cells[3].Value.ToString();string user_name = dgv.Rows[e.RowIndex].Cells[4].Value.ToString();string user_sex = dgv.Rows[e.RowIndex].Cells[5].Value.ToString();string outUserid,outUserpassword,outUserclass,outUsername,outUsersex;DialogResult myresult;this.ShowDialogForm(id, user_id, user_password, user_class,user_name, user_sex,out outUserid, out outUserpassword, out outUserclass, out outUsername, out outUsersex, out myresult);if (myresult==DialogResult.OK){dgv.Rows[e.RowIndex].Cells[1].Value = outUserid;dgv.Rows[e.RowIndex].Cells[2].Value = outUserpassword;dgv.Rows[e.RowIndex].Cells[3].Value = outUserclass;dgv.Rows[e.RowIndex].Cells[4].Value = outUsername;dgv.Rows[e.RowIndex].Cells[5].Value = outUsersex;}}}}private void ShowDialogForm(string id, string user_id, string user_password, string user_class, string user_name, string user_sex,out string outUserid, out string outUserpassword, out string outUserclass, out string outUsername, out string outUsersex, out DialogResult myresult){dialog2 frm = new dialog2();//读取输入参数，显示在子窗口中frm.Controls["ID_TB"].Text = id;frm.Controls["USER_ID_TB"].Text = user_id;frm.Controls["USER_PWD_TB"].Text = user_password;frm.Controls["USER_CLASS_TB"].Text = user_class;// ER_CLASS_CB.SelectedValue = 2;frm.Controls["USER_NAME_TB"].Text = user_name;frm.Controls["USER_SEX_TB"].Text = user_sex;frm.ShowDialog(); //显示子窗口//给输出参数赋值默认值outUserid = user_id;outUserpassword = user_password;outUserclass = user_class;outUsername = user_name;outUsersex = user_sex;//判断是否进行修改数据myresult = frm.DialogResult;if(myresult==DialogResult.OK){//outUserid= frm.Controls["ID_TB"].Text;outUserid= frm.Controls["USER_ID_TB"].Text ;outUserpassword= frm.Controls["USER_PWD_TB"].Text ; outUserclass= frm.Controls["USER_CLASS_CB"].Text ; outUsername= frm.Controls["USER_NAME_TB"].Text ;outUsersex= frm.Controls["USER_SEX_TB"].Text;MessageBox.Show("修改了数据");}else{MessageBox.Show("没有修改数据！！");}frm.Dispose();}int selectrowindex = -1;private void button2_Click(object sender, EventArgs e) {if(selectrowindex<0){MessageBox.Show("请先选择一条记录数据！！");return;}//采用弹出窗口方式，进行数据修改DataGridView dgv = dataGridView1;if (dgv.Rows[selectrowindex].Cells[1].Value != null){//输入参数string id = dgv.Rows[selectrowindex].Cells[0].Value.ToString();string user_id =dgv.Rows[selectrowindex].Cells[1].Value.ToString();string user_password =dgv.Rows[selectrowindex].Cells[2].Value.ToString();string user_class =dgv.Rows[selectrowindex].Cells[3].Value.ToString();string user_name =dgv.Rows[selectrowindex].Cells[4].Value.ToString();string user_sex =dgv.Rows[selectrowindex].Cells[5].Value.ToString();string outUserid, outUserpassword, outUserclass, outUsername, outUsersex; //输出参数DialogResult myresult; //返回弹出窗口关闭状态this.ShowDialogForm(id, user_id, user_password, user_class,user_name, user_sex,out outUserid, out outUserpassword, out outUserclass, out outUsername, out outUsersex, out myresult);//如果修改了数据，把当前datagridview内容的对应值进行修改if (myresult == DialogResult.OK){dgv.Rows[selectrowindex].Cells[1].Value = outUserid;dgv.Rows[selectrowindex].Cells[2].Value = outUserpassword; dgv.Rows[selectrowindex].Cells[3].Value = outUserclass;dgv.Rows[selectrowindex].Cells[4].Value = outUsername;dgv.Rows[selectrowindex].Cells[5].Value = outUsersex;}}}private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e){selectrowindex = e.RowIndex; //获取当前选择的行坐标}//添加记录private void button1_Click(object sender, EventArgs e){//采用弹出窗口方式，进行数据修改DataGridView dgv = dataGridView1;//输入参数string id = "-1";string user_id =null;string user_password = null;string user_class = null;string user_name = null;string user_sex = null;string outUserid, outUserpassword, outUserclass, outUsername, outUsersex; //输出参数DialogResult myresult; //返回弹出窗口关闭状态this.ShowDialogForm(id, user_id, user_password, user_class, user_name, user_sex,out outUserid, out outUserpassword, out outUserclass, out outUsername, out outUsersex, out myresult);//如果添加了数据，把当前datagridview内容的对应值进行修改if (myresult == DialogResult.OK){//添加行数据((DataTable)dataGridView1.DataSource).Rows.Add(1, outUserid, outUserpassword,outUserclass,outUsername,outUsersex);//dataGridView1是不能直接添加行的,只能在他的数据源里添,他会自动绑定}}//删除一条记录private void button3_Click(object sender, EventArgs e){int myid =int.Parse(dataGridView1.Rows[selectrowindex].Cells[0].Value.ToString());string mysql = "delete from user_tb1 where ID=" + myid.ToString();DataOperate dataoperate = new DataOperate();dataoperate.getCom(mysql);MessageBox.Show("删除数据成功");//加载数据mysql = "select * from sql3 ";DataSet ds = dataoperate.getDs(mysql, "sql3");dataGridView1.DataSource = ds.Tables[0];/*//获取总页码 SELECT Count(id) AS number1 FROM user_tb1;mysql = "SELECT Count(id) AS number1 FROM user_tb1 ";DataSet ds = dataoperate.getDs(mysql, "user_tb1");int indexsum = int.Parse(ds.Tables[0].Rows[0][0].ToString());if (indexsum % pagesize == 0)label5.Text = (indexsum / pagesize).ToString();elselabel5.Text = (indexsum / pagesize + 1).ToString();pagesum = int.Parse(label5.Text);//显示当前页面try{button5_Click(sender, e); //刷新当前页面}catch (Exception){throw;}*/}//}}弹出窗口代码using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;using monClass;namespace WDZ{public partial class dialog2 : Form{public dialog2(){InitializeComponent();}private void dialog2_Load(object sender, EventArgs e){string mysql = "select * from user_class order by id";bindcombox(USER_CLASS_CB, mysql, "user_class");USER_CLASS_CB.SelectedIndex=USER_CLASS_CB.FindString(USER_CLASS_TB.Text,-1); //**非常重要，利用string查找到对应的index，然后就可以显示了，或者取value}// 填充Combox控件private void bindcombox(ComboBox mycombox,string mysql,string tbname){DataTable mydt = new DataTable();DataOperate dataoperate = new DataOperate();DataSet ds = dataoperate.getDs(mysql, tbname);mydt = ds.Tables[0];mycombox.ValueMember =mydt.Columns[1].ColumnName; //设置隐含的形式显示数值，起对应一定的名称//cmb_Temp.ValueMember = "user_class";mycombox.DisplayMember = mydt.Columns[2].ColumnName;mycombox.DataSource = mydt;mycombox.DropDownStyle = ComboBoxStyle.DropDownList; //只能选择，不能写入//cmb_Temp.DropDownStyle =ComboBoxStyle.DropDown; //可以写入// cmb_Temp.DropDownStyle = ComboBoxStyle.Simple;}private void button1_Click(object sender, EventArgs e){//提交数据库操作，。