DataGridView 数据绑定的一般过程

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