"No Data available in table" should not be displayed.

Question

Hi

I have below data which converts table into datatable. I want if there is no record "No Data available in table" should not be displayed.

StringBuilder htmlTable = new StringBuilder();
            htmlTable.Append("<table class='table table-bordered table-hover datatable-highlight' id='tbldata'>");
            htmlTable.Append("<thead><tr style='background-color:green;color:white; text-align: center;'><th>Sr.</th><th>Document</th><th>File Name</th><th class='text-center nosort'>Action</th></tr></thead>");
            htmlTable.Append("<tbody>");
            htmlTable.Append("</tbody>");
            htmlTable.Append("</table>");
            PlaceHolderTable0.Controls.Add(new Literal { Text = htmlTable.ToString() });

Thanks

Jignesh Kumar · Answer

$(document).ready(function() { var table = $('#example').DataTable(); if ($.fn.DataTable.isDataTable('#example')) { table.destroy(); } $('#example').DataTable({ "language": { "emptyTable": "" // Empty string to hide the message } }); });

Jignesh Kumar · Answer

You can use this, $(document).ready(function() { $('#example').DataTable({ "language": { "emptyTable": "" // Empty string to hide the message } }); });

Jignesh Kumar · Answer

Hello Ramco, I cannot see a message like "No Data available in table" in your code . Could you please share the full code if you are facing that issue? As per the above code there is no message like that

Ramco Ramco · Answer

Hi Jignesh I am getting error - Cannot reinitialize table Thanks

Ramco Ramco · Answer

Hi Jignesh Datatable by default does not display this message. Am i right Thanks

Vijay Pandey · Answer

Protected Sub BindDataToGridView() Dim dt As DataTable = GetData() ' Check if the DataTable has records If dt.Rows.Count > 0 Then ' Bind the GridView GridView1.DataSource = dt GridView1.DataBind() ' Optionally hide the EmptyDataText GridView1.EmptyDataText = String.Empty Else ' No data available, you can still display a custom message or do nothing GridView1.Visible = False End If End Sub

"No Data available in table" should not be displayed.

Answers (6)