Nodatafound in datalist

Question

Hi sir I am using ASP.NET datalist control and I want to display No Data Found message when query return 0 rows from database. Please give me the code for that... thanks Regards Jahi

Abhimanyu K Vatsa · 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 = FooterTemplate > asp : DataList > asp : SqlDataSource ID =SqlDataSource1 runat =server ConnectionString = $ ConnectionStrings:DatabaseConnectionString1 %>  ProviderName = $ ConnectionStrings:DatabaseConnectionString1.ProviderName %>  SelectCommand =SELECT [NAME] FROM [BOOKS]> asp : SqlDataSource >

jaheena jamal · Answer

thank you somuch sir for giving answer to my question. Thanks alot. My prblm solved Thanks regards Jahi

Abhimanyu K Vatsa · Answer

Ref. Reading http://www.vbdotnetheaven.com/UploadFile/abhikumarvatsa/2621/

"Nodatafound" in datalist