This class will request to a database class to return SqlDataReader to Bind DataGrid Control.
using System;using System.Data.SqlClient;using System.Web;Class BindGrid : System.Web.UI.Page{private Returneader returnReader;private DataGrid dataGrid;public BindGrid(){returnReader = new ReturnReader();BindDataGrid();} Private void BindDataGrid(){dataGrid.DataSource = returnReader.CreateReader();dataGrid.DataBind(); }}Class ReturnReader{private SqlDataReader sqlDataReader = null;public SqlDataReader CreateReader() {SqlConnection con = new SqlConnection("SERVER=.;UID=Ashish;PWD=Ashish;DATABASE =NorthWind");SqlCommand objCommand = new SqlCommand("SELECT FirstName, LAstName from Employees", con);sqlDataReader = objCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);return sqlDataReader;}}