Hi...

SqlDataReader holds the data from MS SQL - after it is bind to DataList, Repeater web-control i'm using the same sqlDataReader object to bound to gridview control, but no data is being displayed in gridview control..

if sqldatareader object is first bind to gridview, data is shown only in grid and not in DataList or Repeater control...

i.e. either data is being displayed in DataList/Repeater or gridview

Any problem in code?
Thanks in adv

ASPX code
PHP Code:
    <asp:repeater id=repNews runat="server">
        <
HeaderTemplate>
            
Title
        
</HeaderTemplate>
        <
ItemTemplate>
            <%
# DataBinder.Eval(Container.DataItem, "Title") %>
        
</ItemTemplate>
    </
asp:repeater>
    
    <
asp:datalist runat="server" id=dlNews>
        <
ItemTemplate>
            <%
# Eval("Title")%>
        
</ItemTemplate>    
    </
asp:datalist>
    
    <
asp:gridview id=gvNews runat="server"></asp:gridview

page behind code
PHP Code:
        SqlDataReader drNews;
        
SqlCommand sqlCmd = new SqlCommand();
        
sqlCmd.CommandType CommandType.StoredProcedure;
        
sqlCmd.CommandText "GetNewsList";
        
        
sqlCmd.Connection = new SqlConnection();
        
sqlCmd.Connection.ConnectionString ConfigurationManager.AppSettings["SQLCon"].ToString();
        
sqlCmd.Connection.Open();
        
drNews sqlCmd.ExecuteReader();
              

        
dlNews.DataSource drNews;
        
dlNews.DataBind();


        
repNews.DataSource drNews;
        
repNews.DataBind();

        
gvNews.DataSource drNews;
        
gvNews.DataBind();