DataGridView中的常用技巧

痛定思痛。 2022-07-31 19:00 141阅读 0赞

转自http://www.cnblogs.com/ziyiFly/archive/2008/09/04/1283910.html

[C\#DataGridView中的常用技巧][C_DataGridView]

只列出技巧部分,后面会有补充

0(最基本的技巧). 获取某列中的某行(某单元格)中的内容  
  this.currentposition = this.dataGridView1.BindingContext  \[this.dataGridView1.DataSource,   this.dataGridView1.DataMember\].Position;  
                bookContent = this.database.dataSet.Tables\[0\].Rows  \[this.currentposition\]\[21\].ToString().Trim();  
                MessageBox.Show(bookContent);

1、自定义列

//定义列宽  
            this.dataGridView1.Columns\[0\].Width = 80;  
            this.dataGridView1.Columns\[1\].Width = 80;  
            this.dataGridView1.Columns\[2\].Width = 180;  
            this.dataGridView1.Columns\[3\].Width = 120;  
            this.dataGridView1.Columns\[4\].Width = 120;

Customize Cells and Columns in the Windows Forms DataGridView Control by Extending Their  
    Behavior and Appearance  
    Host Controls in Windows Forms DataGridView Cells  
    继承 DataGridViewTextBoxCell 类生成新的Cell类，然后再继承 DataGridViewColumn 生成新的Column类，并指定  
    CellTemplate为新的Cell类。新生成的Column便可以增加到DataGridView中去。  
2、自动适应列宽  
    Programmatically Resize Cells to Fit Content in the Windows Forms DataGridView Control  
    Samples：  
    DataGridView.AutoSizeColumns(  
           DataGridViewAutoSizeColumnCriteria.HeaderAndDisplayedRows);  
    DataGridView.AutoSizeColumn(  
                DataGridViewAutoSizeColumnCriteria.HeaderOnly,  
                2, false);  
    DataGridView.AutoSizeRow(  
                DataGridViewAutoSizeRowCriteria.Columns,  
                2, false);  
    DataGridView.AutoSizeRows(  
              DataGridViewAutoSizeRowCriteria.HeaderAndColumns,  
                0, dataGridView1.Rows.Count, false);  
3、可以绑定并显示对象  
    Bind Objects to Windows Forms DataGridView Controls  
4、可以改变表格线条风格  
    Change the Border and Gridline Styles in the Windows Forms DataGridView Control  
    Samples:  
    this.dataGridView1.GridColor = Color.BlueViolet;  
    this.dataGridView1.BorderStyle = BorderStyle.Fixed3D;  
    this.dataGridView1.CellBorderStyle = DataGridViewCellBorderStyle.None;  
    this.dataGridView1.RowHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single;  
    this.dataGridView1.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single;  
5、动态改变列是否显示，和动态改变列的显示顺序  
    Change the Order of the Columns in the Windows Forms DataGridView Control  
    Samples：  
    customersDataGridView.Columns\["CustomerID"\].Visible = false;  
    customersDataGridView.Columns\["ContactName"\].DisplayIndex = 0;  
    customersDataGridView.Columns\["ContactTitle"\].DisplayIndex = 1;  
    customersDataGridView.Columns\["City"\].DisplayIndex = 2;  
    customersDataGridView.Columns\["Country"\].DisplayIndex = 3;  
    customersDataGridView.Columns\["CompanyName"\].DisplayIndex = 4;  
6、可以在列中显示图像  
    Display Images in Cells of the Windows Forms DataGridView Control  
    Samples：  
            Icon treeIcon = new Icon(this.GetType(), "tree.ico");  
           DataGridViewImageColumn iconColumn = new DataGridViewImageColumn ();  
           iconColumn.Image = treeIcon.ToBitmap();  
           iconColumn.Name = "Tree";  
           iconColumn.HeaderText = "Nice tree";  
           dataGridView1.Columns.Insert(2, iconColumn);  
7、格式化显示内容:  
    Format Data in the Windows Forms DataGridView Control  
    Samples:  
    this.dataGridView1.Columns\["UnitPrice"\].DefaultCellStyle.Format = "c";  
    this.dataGridView1.Columns\["ShipDate"\].DefaultCellStyle.Format = "d";  
    this.dataGridView1.DefaultCellStyle.NullValue = "no entry";  
    this.dataGridView1.DefaultCellStyle.WrapMode = DataGridViewWrapMode.Wrap;  
    this.dataGridView1.Columns\["CustomerName"\].DefaultCellStyle.Alignment =  
                         DataGridViewContentAlignment.MiddleRight;  
     
8、在拖动列的滚动条时可以将指定的列冻结  
    Freeze Columns in the Windows Forms DataGridView Control  
    Samples：将指定列及以前的列固定不动  
    this.dataGridView1.Columns\["AddToCartButton"\].Frozen = true;  
9、获取选择的单元格,行,列  
    Get the Selected Cells, Rows, and Columns in the Windows Forms DataGridView Control  
    Samples:  
       见msdn。  
10、显示录入时出现的错误信息  
    Handle Errors that Occur During Data Entry in the Windows Forms DataGridView Control  
    Samples：  
    private void dataGridView1\_DataError(object sender,  
        DataGridViewDataErrorEventArgs e)  
        \{  
        // If the data source raises an exception when a cell value is  
        // commited, display an error message.  
        if (e.Exception != null &&  
            e.Context == DataGridViewDataErrorContext.Commit)  
        \{  
            MessageBox.Show("CustomerID value must be unique.");  
        \}  
        \}  
11、大数据量显示采用Virtual Mode  
    Implement Virtual Mode in the Windows Forms DataGridView Control  
12、设置指定的列只读  
    Make Columns in the Windows Forms DataGridView Control Read-Only  
    Samples：  
    dataGridView1.Columns\["CompanyName"\].ReadOnly = true;  
   
13、移去自动生成的列  
    Remove Autogenerated Columns from a Windows Forms DataGridView Control  
    Sample:  
    dataGridView1.AutoGenerateColumns = true;  
    dataGridView1.DataSource = customerDataSet;  
    dataGridView1.Columns.Remove ("Fax");  
    或：  
    dataGridView1.Columns\["CustomerID"\].Visible = false;  
14、自定义选择模式  
    Set the Selection Mode of the Windows Forms DataGridView Control  
    Sample：  
    this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;  
    this.dataGridView1.MultiSelect = false;  
15、自定义设定光标进入单元格是否编辑模式（编辑模式）  
    Specify the Edit Mode for the Windows Forms DataGridView Control  
    this.dataGridView1.EditMode = DataGridViewEditMode.EditOnEnter;  
16、新行指定默认值  
    Specify Default Values for New Rows in the Windows Forms DataGridView Control  
    Sample：  
    private void dataGridView1\_DefaultValuesNeeded(object sender,                       System.Windows.Forms.DataGridViewRowEventArgs e)  
    \{  
      e.Row.Cells\["Region"\].Value = "WA";  
       e.Row.Cells\["City"\].Value = "Redmond";  
       e.Row.Cells\["PostalCode"\].Value = "98052-6399";  
      e.Row.Cells\["Region"\].Value = "NA";  
      e.Row.Cells\["Country"\].Value = "USA";  
    e.Row.Cells\["CustomerID"\].Value = NewCustomerId();  
    \}  
17、数据验证  
    Validate Data in the Windows Forms DataGridView Control  
    Samples：  
     private void dataGridView1\_CellValidating(object sender,  
            DataGridViewCellValidatingEventArgs e)  
        \{  
        // Validate the CompanyName entry by disallowing empty strings.  
        if (dataGridView1.Columns\[e.ColumnIndex\].Name == "CompanyName")  
        \{  
            if (e.FormattedValue.ToString() == String.Empty)  
            \{  
                dataGridView1.Rows\[e.RowIndex\].ErrorText =  
                    "Company Name must not be empty";  
                e.Cancel = true;  
            \}  
        \}  
        \}  
18、数据提交到dataset中  
                DataSet ds = new DataSet("MyDataSet");  
                ds.Tables\[biaom.Trim()\].Rows.Clear();  
                try  
                \{  
                    for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)  
                    \{  
                        DataTable dt = ds.Tables\[biaom.Trim()\];  
                        DataRow myrow = ds.Tables\[biaom.Trim()\].NewRow();  
                        for (int j = 0; j < dataGridView1.Columns.Count; j++)  
                        \{  
                            myrow\[j\] = Convert.ToString(dataGridView1.Rows\[i\].Cells\[j\].Value);  
                        \}  
                        ds.Tables\[biaom.Trim()\].Rows.Add(myrow);  
                    \}  
                \}  
                catch (Exception)  
                \{  
                      
                    MessageBox.Show("输入类型错误！");  
                    return;  
                \}

18.错误验证

void dataGridView1\_CellEndEdit(object sender, DataGridViewCellEventArgs e)  
        \{  
            if (dataGridView1.CurrentCell.Value.ToString().Equals("error"))  
            \{  
                dataGridView1.CurrentCell.ErrorText = "错误";  
            \}  
            else  
            \{  
                dataGridView1.CurrentCell.ErrorText = "";  
            \}  
        \}

[C_DataGridView]: http://www.cnblogs.com/ziyiFly/archive/2008/09/04/1283910.html