Bind C# GridView to DataTable or DataSet

• GridView WinForms UI Control
• GridView Component Data Binding
• Binding C# GridView to Data Source
• Binding to Array and ArrayList
• Binding C# GridView to Generic List
• GridView Data Binding to Binding List
• Binding C# GridView to DataReader
• Binding GridView to Sub Objects
• GridView Data Binding to XML
• Unbound Mode of GridView Data Binding
• Update Database in GridView Data Binding

Bind GridView to Data Table or DataSet in C# project

1. Drag a KetticGridView component from the toolbox and drop on a form in your C#.NET project.
2. Change the value of the Dock property as Fill to dock the Window to GridView
3. Open the Properties window of the GridView component on the Form, go to the DataSource property, and open the list by clicking the arrow.
4. Choose the Add Project Data Source... link to show the Data Source Configuration Wizard. And then select a Data Source Type page in the Wizard, click the Database icon, and hit the Next button.
5. Choose the New Connection... button in the Choose Your data Connection page to show the Add Connection dialog. And then hit the Change... button to show the Change Data Source dialog.
6. In the Change Data Source dialog, choose the Microsoft Access Database File data source. After finishing it, hit the OK button to close the dialog.
7. When the Add Connection dialog display, we can choose the Database File Name Browse button and find the database table, NWind.mdb, included in the GridView control, which is under the path: \KetticGridViewWinForms\DataSamples. Close the dialog by hitting the OK button.
8. Choose the Categories checkbox in the Choose Your Database Objects page and close the Data Source Configuration Wizard by hitting the Finish button.
9. Choose the Categories data table from the grid DataSource property in the Properties window. Then the DataSet, BindingSource and TableAdapter objects will be generated for the categories table.
10. Now we can copy the C# code below, which will iterate all the columns in the grid and calls BestFit() to expand columns for displaying data, and paste them to the Form_Load event handler. After that, debug the C#.NET Windows Forms project to see the result.

private void GuideBindingToDataTableOrDataSet_Load(object sender, EventArgs e)
{
this.categoriesTableAdapter.Fill(this.nwindDataSet.Categories);
foreach (GridViewDataColumn column in ketticGridView1.Columns)
{
column.BestFit();
}
}