Hello,

I need help regarding following code!!! the Second function public ICollection GetCollection returning nothing....plz. help me out

private void Page_Load(object sender, System.EventArgs e)
{
SNo.DataField="RefId";
SNo.HeaderText="S.No";

SchoolCode.DataField="SchoolCode";
SchoolCode.HeaderText="School Code";

SchoolName.DataField="SchoolName";
SchoolName.HeaderText="School Name";
SchoolName.ItemStyle.Wrap=false;

BuildingTypeDG.DataSource=GetCollection();

BuildingTypeDG.DataBind();
}

public ICollection GetCollection()
{
    objModule.ConnectData();
    objModule.ObjCmd1.CommandText = objModule.sql;
    objModule.sqlReader1 = objModule.ObjCmd1.ExecuteReader();

    DataTable Dt=new DataTable();
    DataRow DRow;

    Dt.Columns.Add("RefId");
    Dt.Columns.Add("SchoolCode");
    Dt.Columns.Add("SchoolName");

    BuildingTypeDG.AutoGenerateColumns=false;
    objModule.G_Int_J = 1;

     while (objModule.sqlReader1.Read())
    {
        DRow = Dt.NewRow();
        DRow[0]=objModule.G_Int_J;
        DRow[1]=objModule.sqlReader1.GetValue(2);
        DRow[2]=objModule.sqlReader1.GetValue(1);

        Dt.Rows.Add(DRow);
        objModule.G_Int_J = objModule.G_Int_J + 1;

    }
    objModule.sqlReader1.Close();

    return new DataView(Dt);

}