private void FetchDataTableReader() 
{ 
string sql = "Select * from Customers"; 
SqlDataAdapter da = new SqlDataAdapter(sql,”YourConnectionString”); 
DataTable dt = new DataTable(); da.Fill(dt); 
DataTableReader dtr = dt.CreateDataReader(); 
if (dtr.HasRows) 
{ 
while (dtr.Read()) 
{ 
Response.Write(dtr[“Cus_Name”].ToString() + "
"); 
} 
} 
else 
Response.Write("No Data"); 
}