Illustrate how to use the fill method to populate a DataTable in the DataSet. Assume that the data query string is the SQL statement SELECT Faculty_ID,Name from Faculty and that an MSAccess Data provider is utilized. Code in Advance Vis
1. Illustrate how to use the fill method to populate a DataTable in the DataSet. Assume that the data query string is the SQL statement SELECT Faculty_ID,Name from Faculty and that an MSAccess Data provider is utilized. Code in Advance Visual Basic
Summary
DataSet
A DataSet is an in-memory representation of data. This is a separate cached set of records retrieved from the database. After connecting to the database, the data adapter creates a dataset and populates it with data. Once the data has been retrieved and saved to the record, the connection to the database is closed. This is called a "disconnected architecture". A dataset acts as a virtual database containing tables, rows, and columns.
Connecting to Databases
The .Net Framework provides two connection classes
SqlConnection is designed such that it can be connected Microsoft SQL Server.
OleDbConnection
Designed to connect to various databases like oracle and Microsoft Access, etc.
Creating Tables, Columns, and Rows
Explained that you can use DataSet components such as DataTable, DataColumn, and DataRow to create tables, columns, and rows, respectively.
Step by step
Solved in 2 steps with 7 images