DataGridView 详解 使用技巧 添加、修改、删除数据操作

本 文 完 全 摘 自 hp://hi.baidu.com/

slamdunky/home

对 DataGridView 进行添加、修改、删除数

据操作----C#

设定全局变量：

 MySqlConnection conn;

 MySqlDataAdapter adapter;

 MySqlTransaction trans;

 conn.Open();

 this.adapter = new MySqlDataAdapter(strSql, conn);

 System.Data.DataTable dtSelect = new System.Data.DataTable();

 int rnt=this.adapter.Fill(dtSelect);

 conn.Close();

 return dtSelect;



 }

2. //设定 DataGridView 的样式

 private void setDgStyle()

 colDel.FalseValue = "0";

 colDel.TrueValue = "1";

 colDel.Width = 40;

 colDel.SortMode = DataGridViewColumnSortMode.NotSortable;

 colDel.HeaderText = "删除";

 colDel.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;

 colDel.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;

 this.dgselect.Columns.Insert(0, colDel);

 DataGridViewTextBoxColumn colID = new DataGridViewTextBoxColumn();

 colID.DataPropertyName = "ProductsSpecID";

 colNM.DataPropertyName = "ProductsSpec";

 colNM.Name = "ProductsSpec";

 colNM.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;

 colNM.HeaderText = "产品规格名称";

 colNM.Width = 160;

 this.dgselect.Columns.Insert(2, colNM);

 DataGridViewTextBoxColumn colUnit = new DataGridViewTextBoxColumn();

 colUnit.DataPropertyName = "ProductsSpecUnit";

 colUnit.Name = "ProductsSpecUnit";

 colUnit.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;

 colUnit.HeaderText = "产品规格单位";

 colUnit.Width = 180;

 this.dgselect.Columns.Insert(3, colUnit);

 this.dgselect.Columns.Insert(4, colPID);

 DataGridViewButtonColumn colButton = new DataGridViewButtonColumn();

 colButton.DataPropertyName = "colSearch";

 colButton.Name = "colSearch";

 colButton.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;

 colButton.HeaderText = "Button";

 colButton.Width = 80;

 this.dgselect.Columns.Insert(5, colButton);

 this.dgselect.RowHeadersWidth = 15;

 this.dgselect.ColumnHeadersDefaultCellStyle.Font=new System.Drawing.Font("宋体",14);



 }

 dtUpdate.Rows.Clear();

 System.Data.DataTable dtShow = new System.Data.DataTable();

 //dtShow = (DataTable)this.bindSource.DataSource;

 dtShow = (System.Data.DataTable)this.dgselect.DataSource;

 int p1 = dtShow.Rows.Count;

 // try

 // {

 for (int i = 0; i < dtShow.Rows.Count; i++)

 {

 DataRowState rowState=new DataRowState();

 rowState=dtShow.Rows[i].RowState;

 if (rowState==DataRowState.Added || rowState==DataRowState.Detached ||

rowState==DataRowState.Modified)

 {

 {

 }

 }

 int num = dtUpdate.Rows.Count;

 try

 {

 this.conn.Open();



 trans = this.conn.BeginTransaction();

 MySqlCommandBuilder CommandBuiler;

 CommandBuiler = new MySqlCommandBuilder(this.adapter);

 this.adapter.Update(dtUpdate);

 trans.Commit();

 return false;

 }

 dtUpdate.AcceptChanges();

 return true;

 }

基本数据绑定

熟悉6DataGridView的最佳方法就是实际尝试一下，无需配置任何属性。就像6DataGrid一样，您可以

使用6DataSource属性来绑定6DataTable对象（或从6DataTable派生的对象）。

Dim ds As DataSet = GetDataSet()

DataGridView1.DataSource = ds.Tables("Customers")

与6DataGrid不同的是，DataGridView一次只能显示一个表。如果绑定整个6DataSet，则不会显示任

图。

3、允许就地编辑。用户可以在单元格中双击或按6F2来修改当前值。唯一的例外是将6DataColumn.Read

Only设置为6True的字段（如当前示例中的 OrderID字段）。6

4、支持自动排序。用户可以在列标题中单击一次或两次，基于该字段中的值按升序或降序对值进行排序。

默认情况下，排序时会考虑数据类型并按字母或数字顺序进行排序。字母顺序区分大小写。6

5、允许不同类型的选择。用户可以通过单击并拖动来突出显示一个单元格、多个单元格或多个行。单击6

DataGridView左上角的方块可以选择整个表。6

6、支持自动调整大小功能。用户可以在标题之间的列分隔符上双击，使左边的列自动按照单元格的内容

展开或收缩。

美化6DataGridView