"Nodatafound" in datalist

couple of ways

1st way:-

DataList1.DataSource = CreateDataSource()

DataList1.DataBind()

Dim x = DataList1.Items.Count

If x = 0 Then

//user your logic here

End If

2nd way:-

<asp:DataList
        id="dlstBooks"
        DataSourceID="SqlDataSource1"
        UseAccessibleHeader="true"
        CssClass="books"
        HeaderStyle-CssClass="header"
        ItemStyle-CssClass="item"
        AlternatingItemStyle-CssClass="alternating"
        Runat="server">
        <HeaderTemplate>
        Book List
        HeaderTemplate>
        <ItemTemplate>
        <%#Eval("NAME")%>
        ItemTemplate>

<FooterTemplate>
Total Record = <%# DataList1.Items.Count %>
FooterTemplate>

asp:DataList>

        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString1 %>"
            ProviderName="<%$ ConnectionStrings:DatabaseConnectionString1.ProviderName %>"
            SelectCommand="SELECT [NAME] FROM [BOOKS]">
        asp:SqlDataSource>

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhimanyu K Vatsa15y ago
Accepted answer
couple of ways

1st way:-

DataList1.DataSource = CreateDataSource()
DataList1.DataBind()
Dim x = DataList1.Items.Count
If x = 0 Then
//user your logic here
End If

2nd way:-

<asp:DataList
        id="dlstBooks"
        DataSourceID="SqlDataSource1"
        UseAccessibleHeader="true"
        CssClass="books"
        HeaderStyle-CssClass="header"
        ItemStyle-CssClass="item"
        AlternatingItemStyle-CssClass="alternating"
        Runat="server">
        <HeaderTemplate>
        Book List
        HeaderTemplate>
        <ItemTemplate>
        <%#Eval("NAME")%>
        ItemTemplate>
<FooterTemplate>
Total Record = <%# DataList1.Items.Count %>
        FooterTemplate>
    asp:DataList>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString1 %>"
            ProviderName="<%$ ConnectionStrings:DatabaseConnectionString1.ProviderName %>"
            SelectCommand="SELECT [NAME] FROM [BOOKS]">
        asp:SqlDataSource>
0
jaheena jamal15y ago
thank you somuch sir for giving answer to my question.

Thanks alot. My prblm solved

Thanks regards
Jahi
0
Abhimanyu K Vatsa15y ago
Ref. Reading

http://www.vbdotnetheaven.com/UploadFile/abhikumarvatsa/2621/
0