Articles → ADO.NET → Load Datatable Through Datareader In Ado.Net

Load Datatable Through Datareader In Ado.Net

Software Requirement

1. Visual studio 2003(or above) is installed on your machine.
2. SQL Server 2000(or above) is installed on your machine

Prerequisite Knowledge

1. Basics about SQL objects like tables.
2. How to create tables in SQL server and how to insert data into the table?
3. How to create a project using visual studio?
4. Page events like page load event.
5. Basic knowledge of ado.net objects like dataset and datatable.

Steps Of Execution

1. Create a new table
2. Add data in the table
3. Create a new project
4. Add code to load datatable though datareader

Create A New Table

Add Data In The Table

Create A New Project

Add Code To Load Datatable Though Datareader

using System;
using System.Data.SqlClient;
using System.Data;
public partial class _Default: System.Web.UI.Page {
	protected void Page_Load(object sender, EventArgs e) {
		using(SqlConnection oConnection = new SqlConnection(@"connection_string")) { // Open a connection
			oConnection.Open();
			using(SqlCommand cmd = new SqlCommand("Select * from Course", oConnection)) {
				SqlDataReader dr = cmd.ExecuteReader();
				DataTable dt = new DataTable();
				dt.Load(dr);
			}
		}
	}
}

Output