Vb net sql query

The DataGridView control supports the standard Windows Forms data binding model, so it can bind to a variety of data sources. Usually, you bind to a BindingSource that manages the interaction with the data source.

The BindingSource can be any Windows Forms data source, which gives you great flexibility when choosing or modifying your data's location. For more information about data sources the DataGridView control supports, see the DataGridView control overview.

Visual Studio has extensive support for data binding to the DataGridView control.

Visual basic database programming examples

For more information, see How to: Bind data to the Windows Forms DataGridView control using the Designer.

To connect a DataGridView control to data:

1. Implement a method to handle the details of retrieving the data.

   The following code example implements a method that initializes a SqlDataAdapter, and uses it to populate a DataTable. It then binds the DataTable to the BindingSource.

2. In the form's Load event handler, bind the DataGridView control to the BindingSource, and call t