Generally we will use Execute Reader object to bind data to datareader.
To bind Data Reader data to Grid View we need to write the code like as shown below: Data Set Data Set is a disconnected orient architecture that means there is no need of active connections during work with datasets and it is a collection of Data Tables and relations between tables. You can select data form tables, create views based on table and ask child rows over relations.
This dataadapter object is used to read the data from database and bind that data to dataset.
Dataadapter is a disconnected oriented architecture.
Users are cautioned that this system does not necessarily constitute the complete record in any particular license and, as such, the FCC makes no representations regarding the accuracy or completeness of the information maintained in the FCC License View.
Users seeking a record of a particular license are urged to utilize the Commission's official databases, such as the Universal Licensing System (ULS), International Bureau Filing System (IBFS), Experimental Licensing System (ELS) Cable Operations and Licensing System (COALS) and Consolidated Data Base System (CDBS), instead.
I was able to get the Combo Box populated with the table names available in the Data Set by iterating through But I only got the column headers.
Then I read that I need a Table Adapter to populate the Data Set with that table.
A Data Set is an in-memory data store that can hold numerous tables. Ole Db Connection(connection String)); Data Grid View1. Public Class Form1 Dim con As Ole Db Connection = New Ole Db Connection("Provider=Microsoft. OLEDB.12.0; Data Source=|Data Directory|\test.accdb;") Private Sub Button1_Click Dim da As New Ole Db Data Adapter Dim table As String = Combo Box1. if all the table adapter does is to fill in the dataset with the table, and that too us specifying the query, there should be a way for doing via dataset as well.. Data Sets only hold data and do not interact with a data source.It is the Sql Data Adapter that manages connections with the data source and gives us disconnected behavior.