DataGridView相关知识（整理得好多，好常用）

（一）DataGridView常用代码

(1)在DataGridView中自动生成列 dataGridView.AutoGenerateColumns = true;

(2)移除DataGridView中自动生成的列dataGridView.Columns.Remove("Fax");

(3)隐藏DataGridView中自动生成的列dataGridView.Columns["CustomerID"].Visible = false;

(4)更改DataGridView中列的顺序

dataGridView.Columns["ContactName"].DisplayIndex = 0;
dataGridView.Columns["ContactTitle"].DisplayIndex = 1;

(5)冻结DataGridView中的列及其左侧的列dataGridView.Columns["ContactName"].Frozen = true;

(6)使DataGridView中的列只读

dataGridView.Columns["Fax"].ReadOnly = true;

(7)防止在DataGridView中添加或删除行

dataGridView.AllowUserToAddRows = false;

dataGridView.AllowUserToDeleteRows = false;

(8)设置第0行，第1列为当前单元格

dataGridView.CurrentCell = dataGridView[1,0];

（9）GridView数据导出到Word/Excel中

GridView控件是表格控件，可以显示数据、修改数据，但是GridView控件控件没有办法保存数据。那么为GridView控件寻找一种保存数据的方式就很重要了。在NET2.0中加强了数据绑定控件与Office软件的结合。使得GridView控件可以借助于Office文件来保存自己的信息。

      在开始写导出GridView控件中的数据代码之前，首先要把以下代码using System.IO添加到引用头文件里面。System.IO是使用Word等文件的命名空间。同时还要把using System.Data.SqlClient也添加进去。在名称为Button1对应的“Click”事件中写如下代码。

protected void Button1_Click(object sender, EventArgs e)

{

//声明一个字符串

        string sConnectionString;

        //连接数据库字符串，连接到XBMIS数据库，用户名是sa

        sConnectionString = " Data Source=.;Initial Catalog=XBMIS;User ID=sa; ";

        //创建SqlConnection数据库连接对象

        SqlConnection Conn = new SqlConnection(sConnectionString);

        //打开Conn

        Conn.Open();

        //sql语句把T_YongH表中的数据信息都取出来

        string commandString = "Select BianH AS编号,ZhuCYHM AS 注册名,XingM AS 姓名,XingB AS 性别 From T_YongH";

        SqlDataAdapter dataAdapter = new SqlDataAdapter(commandString, Conn);

        ds_datatable ds = new ds_datatable();

        //填充数据集

        dataAdapter.Fill(ds, "YongH");

        DataTable dataTable1 = ds.Tables["YongH"];

      //清除客户端当前显示

        Response.Clear();

        Response.Buffer = true;

       //输出类型为Word

        Response.ContentType = "application/vnd.ms-word";
 

        Response.ContentEncoding = System.Text.Encoding.UTF8;

      //设置显示的字和内容要存的形式

        Response.Charset = "Word文档";

        this.EnableViewState = false;

        StringWriter oStringWriter = new StringWriter();

        HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);

        GridView gd = new GridView ();

//返回DataTable

        gd.DataSource = dataTable1;

        gd.DataBind();

        gd.RenderControl(oHtmlTextWriter);

        Response.Write(oStringWriter.ToString());

        Response.End();

    }

 

（二）datagridview的一些技巧

（1）、自定义列

  

（2）、自动适应列宽

   

（3）、可以绑定并显示对象

    Bind Objects to Windows Forms DataGridView Controls

（4）、可以改变表格线条风格

    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）、动态改变列是否显示，和动态改变列的显示顺序

（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）、获取选择的单元格,行,列

 

（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）、设置指定的列只读

 

（13）、移去自动生成的列

   

（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);