No Record Found Message

Question

1.00/5 (2 votes)

See more:

How to display "No Record Found" message when we search the data into the Database, if the record is found then related data shows in Grid View and if the Data is not found then display a "No Record Found" message ?

Posted 30-Aug-12 17:33pm

wahmed821

Updated 23-Sep-20 15:25pm

Add a Solution

Comments

Graeme_Grant 21-Aug-17 8:00am

What type of application is it? Console, Winform, Wpf, Xamarin, ASP.NET Webforms, ASP.NET MVC, ASP.NET CORE, etc...? Each does it differently!

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

pradiprenushe · Answer 1 · 2012-08-30T18:29:00

Use EmptyDataTextproperty of gridview or use EmptyDataTemplate.

XML

<asp:gridview id="GridView1" runat="server" 
EmptyDataText="No Records found">

</asp:gridview>

or

C#

// if you want to style empty row
 <emptydatarowstyle backcolor="LightBlue" forecolor="Red" />
        <emptydatatemplate>
// you can insert anything image message or text message
 //  <asp:image id="NoDataImage" imageurl="~/images/Image.jpg" runat="server" xmlns:asp="#unknown" />
            No Data Found.  

        </emptydatatemplate>

Sarrrva · Answer 2 · 2012-08-30T18:26:00

you have another option with datatable,

C#

DataTable dt = new DataTable();
            try
            {
                Con_Open();
                cmd = new SqlCommand("select * from Stu", con);
                dr = cmd.ExecuteReader();
                if (dr.HasRows)
                {
                    dt.Columns.Add(new DataColumn("Reg No"));
                    dt.Columns.Add(new DataColumn("Name"));
                    dt.Columns.Add(new DataColumn("Mark1"));
                    dt.Columns.Add(new DataColumn("Mark2"));
                    dt.Columns.Add(new DataColumn("Mark3"));
                    while (dr.Read())
                    {
                        DataRow temp;
                        temp = dt.NewRow();
                        temp[0] = (System.Convert.IsDBNull(dr[0]) ? "" : dr[0].ToString());
                        temp[1] = (System.Convert.IsDBNull(dr[1]) ? "" : dr[1].ToString());
                        temp[2] = (System.Convert.IsDBNull(dr[2]) ? "" : dr[2].ToString());
                        temp[3] = (System.Convert.IsDBNull(dr[3]) ? "" : dr[3].ToString());
                        temp[4] = (System.Convert.IsDBNull(dr[4]) ? "" : dr[4].ToString());
                        dt.Rows.Add(temp);
                    }
                    cmd.Dispose();
                    dr.Close();
                    con.Close();
                }
                else
                {

                    dt.Columns.Add(new DataColumn("Records"));
                    DataRow temp;
                    temp = dt.NewRow();
                    temp[0] = "No Records Found!!";
                    dt.Rows.Add(temp);
                }             
            }

regards
sarva

Sangramsingh Pawar · Answer 3 · 2012-08-30T18:10:00

Solution 2

see below link for empty data template in gridview
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.emptydatatemplate.aspx[^]

Posted 30-Aug-12 18:10pm

Sangramsingh Pawar

virang_21 · Answer 4 · 2012-08-30T17:50:00

Gridview has property called EmptyDataText .. set it to whatever message you want to display...

ASP.NET

 <asp:gridview id="grdViewKeyType" runat="server" allowpaging="True" autogeneratecolumns="False" xmlns:asp="#unknown">
                                BackColor="White" BorderColor="#999999" BorderStyle="Solid" 
                    CellPadding="5" CellSpacing="1"
                                CssClass="Grid" 

EmptyDataText="No Records found" 

....

</asp:gridview>

No Record Found Message

4 solutions

Solution 4

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0