DataGridView 数据绑定的一般过程

 1、实现一个用于处理数据库数据检索的详细信息的方法。下面的代码示例实现一个 GetData 方法，该方法对一个 SqlDataAdapter 组件进行初始化，并使用该组件填充 DataTable。然后，将 DataTable 绑定到 BindingSource 组件。请确保将 connectionString 变量的值设置为与数据库相应的值。

private void GetData(string selectCommand, BindingSource binding, DataGridView dGV)
{
    try
    {
        String connectionString = "server="+ connectionReadServerIp + ";uid=
                                                            " + connectionReaduser + ";pwd=
                                                           " + connectionReadPassword +
                                                           ";database=" + connectionReaddatabase;
                SqlDataAdapter dataAdapter = new SqlDataAdapter(selectCommand, connectionstring);

                DataTable table = new DataTable();
                table.Locale = System.Globalization.CultureInfo.InvariantCulture;
                dataAdapter.Fill(table);
                binding.DataSource = table;
                dGV.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
      }
     catch (SqlException error)
     {
                WriteLog(error.Message.ToString());
     }

}

 2、在窗体的 Load 事件处理程序中，将 DataGridView 控件绑定到 BindingSource 组件，并调用 GetData 方法从数据库中检索数据(事先必须先将DataGridView控件和BindingSource控件拖到Form中，编译器会自动创建两个变量bindingSource1和dataGridView1)
private void Form1_Load(object sender, System.EventArgs e)
{
    dataGridView1.DataSource = bindingSource1;
    GetData("select * from Customers",bindingSource1,dataGridView1);
}

Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1724987