how to use sqldatareader in DAL?

Refer:
1. SqlDataReader Class[^]
2. Reading Data with the SqlDataReader[^]

++++++++++++++
[added]
data-access-layer-using-sqldatareader[^]

A SqlDataReader may not be the best choice for use in a DAL. The reason being that it is not like other objects that you can pass around. You can pass a datareader but you have to keep calling .Read() on it to get the next rows, it is not the whole set of data in one shot. DataSets or DataTables are better for DAL, in my opinion.

However, a DAL is whatever you want it to be. You are writing the code and are therefore in charge of what it looks like so make it work for you.

MSDN[^] always does help :)
http://devtoolshed.com/content/data-access-layer-using-sqldatareader-and-c[^]
http://www.mssqltips.com/sqlservertip/2034/writing-a-data-access-layer-dal-for-sql-server/[^]
http://social.msdn.microsoft.com/Forums/en-US/f9e03634-bdfe-4620-bfdc-71c24544b1de/how-to-pass-sqldatareader-from-data-access-layer-to-business-object-layer?forum=adodotnetdataproviders[^]

-KR

this is the code that i used, works good but can anyone take look & tell me is there any thing that i could change

code DAL.cs :

public DataTable villelist()
    {
        DataTable tbl = null;
        SqlConnection conn = Conection.GetDbConnection();
        SqlCommand cmd = new SqlCommand("BindVilleList", conn);
        cmd.CommandType = CommandType.StoredProcedure;
        conn.Open();
        tbl = new DataTable();
        SqlDataReader dr = cmd.ExecuteReader();
        tbl.Load(dr);
        dr.Close();
        dr.Dispose();
        return tbl;
    }

code BLL.cs :

public DataTable villelist()
    {
        return userDAL.villelist();
    }

code default.aspx :

<pre lang="cs">protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //try
            //{
                //DataSet ds, ds1 = null;
                DataTable dtl = null;
                dtl = userBLL.villelist();
                ddlVillle.DataSource = dtl;
                ddlVillle.DataTextField = "Nom_ville";
                ddlVillle.DataValueField = "Id_vll";
                ddlVillle.DataBind();
              } 
        }
}