Section 8: C# and VB Project: Using an OleDbDataReader to Retrieve Our Data
In Section 8 of this tutorial by Nannette Thacker, we take a look at adding a OleDbDataReader and the ExecuteReader method to retrieve data from an Excel Spreadsheet.
- Introduction: C# and VB Project: A Tutorial Using Data Sets, Table Adapters, WebForms, Controls, File Upload, Excel Import
- Section 1: Creating Our Project, Database and Tables
- Section 2: WebForm: Table, Label, and Panel Controls
- Section 3: FileUpload Control and Functionality
- Section 4: Auto Formatting a Web Form GridView
- Section 5: Bind the Excel Data to a GridView using an OleDbDataAdapter
- Section 6: Data Access Layer DataSet TableAdapters
- Section 7: TableAdapter Select and Insert Queries with Parameters
- Section 8: Using an OleDbDataReader to Retrieve Our Data
Download the ZIP files:
C#: ShiningStarCExcel.zip
VB: ShiningStarVBExcel.zip
"Taste and see that the LORD is good; blessed is the man who takes refuge in him." Psalm 34:8
May your dreams be in ASP.NET!
Nannette Thacker