Display popup message if records not exists in asp.net C# (SEARCH)

Hi,

I would suggest to show a label just above the data grid displaying the number of records searched. Popups can be used while validating the input for search or submit forms.
But if at all you want to display a popup if there are no records, you can use AjaxControlToolkit.

Download the tool kit from http://ajaxcontroltoolkit.codeplex.com/[^]

Add a reference of the tool kit dll to your ASP.Net project and to your page as (just below the @Page attribute)

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPages/MyTIO.Master" AutoEventWireup="true" CodeBehind="example.aspx.cs" Inherits="example.example.example" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

Add an asp:Panel (not displayed initially) for the message as below:

<asp:panel runat="server" id="pnlMessage" style="display:none" xmlns:asp="#unknown">
</asp:panel>

Format the panel in the CSS as you want.

Then, just below the search button, add a dummy button as follows:

<asp:button runat="server" id="btnSearchRecords" text="Search Records" onclick="btnSearchRecords_Click" xmlns:asp="#unknown" />
<asp:button runat="server" id="btnDummySearchRecords" style="display:none;" xmlns:asp="#unknown" />

Then add the ajax control tool kit modal popup extender as follows:

<asp:Button id="btnSearchRecords" Text="Search Records" onClick="btnSearchRecords_Click" />
<asp:Button id="btnDummySearchRecords" style="display:none;" />
<cc1:modalpopupextender id="mpeMessage" targetcontrolid="btnDummySearchRecords" backgroundcssclass="MessageBackground" xmlns:cc1="#unknown">
                    PopupControlID="pnlMessage"
                    OkControlID="btnClose" 
                    DropShadow="true
</cc1:modalpopupextender>

In the button click event in c#, the code looks like as follows:

protected void btnSearchRecords_Click(object sender, EventArgs e)
{
    //Code to query the database and get the results in the datatable
    DataTable searchedRecords = new DataTable();
    searchedRecords = QueryDatabaseAndGetResults();
    
    //Binding the datatable to your datagrid and showing the popup if required
    this.gvResults.DataSource = searchedRecords;
    this.gvResults.DataBind();

    if(searchRecords.Rows.Count == 0)
    {
       this.mpeMessage.show();
    }
}

I hope this will help you with your question. Feel free to shoot out anything required.

Happy coding..!!

Cheers,
Nayan

Hey Ranjith,

Label solution will be very simple.
Format your page as below: (CSS does count on your look and feel)

<asp:label runat="server" id="lblTotalRecords" text="Total Records: 0" xmlns:asp="#unknown"></asp:label>
<asp:gridview runat="server" id="gvRecords" ...="" xmlns:asp="#unknown"></asp:gridview>

In your code behind:

protected void SearchRecords()
{
    //code for connecting to the database and getting the results into DataTable
    //Assuming your are getting the results in the datatable named: dtResults

    this.gvRecords.DataSource = dtResults;
    this.gvRecords.DataBind();

    this.lblTotalRecords.Text = "Total Records: " + dtResults.Rows.Count.ToString();
}

This should be working as to show the total records within a label
I hope this should resolve your question.
Don't forget to mark the answer if it helped you.

Happy coding..!!

Regards,
Nayan

Ranjith,

It could be even simpler.
Considering you have a label named: lblTotalRecords or something like that,
look at the code below:

protected void BtnSearch_Click(object sender, ImageClickEventArgs e)
    {
con.Open();
SqlCommand cmd = new SqlCommand("Select FirstName,LastName,EmpNo,ManagerName,Dept,Location,MobileNo,Email from Employees where FirstName='" + TxtSearch.Text + "' or EmpNo='" + TxtSearch.Text + "' ", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        GVRecords.DataSource = ds;
        GVRecords.DataBind();
        con.Close();

        if(ds.Tables[0].Rows.Count == 0) //assuming ds is a DataSet
            this.lblTotalRecords.Text = "No Records Found..!!"

}

Hope this helps.

Regards,
Nayan

protected void BtnSearch_Click(object sender, ImageClickEventArgs e)
    {
con.Open();
SqlCommand cmd = new SqlCommand("Select FirstName,LastName,EmpNo,ManagerName,Dept,Location,MobileNo,Email from Employees where FirstName='" + TxtSearch.Text + "' or EmpNo='" + TxtSearch.Text + "' ", con);
 SqlDataAdapter da = new SqlDataAdapter(cmd);
 DataSet ds = new DataSet();
 da.Fill(ds);
if(ds.Tables[0].Rows.Count == 0) 
{
ClientScript.RegisterStartupScript(Page.GetType(), "BtnSearch", "alert('Sorry  Record not found)')", true);
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
            GVRecords.DataSource = ds.Tables[0];
            GVRecords.DataBind();
            int columncount = GVRecords.Rows[0].Cells.Count;
            GVRecords.Rows[0].Cells.Clear();
            GVRecords.Rows[0].Cells.Add(new TableCell());
            GVRecords.Rows[0].Cells[0].ColumnSpan = columncount;
            GVRecords.Rows[0].Cells[0].Text = " Record not found !";
            GVRecords.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;

}
else
{
        GVRecords.DataSource = ds;
        GVRecords.DataBind();       
}
 con.Close();
}

I think ur problem solved by this...

public void Message(String msg)
   {
       string script = "window.onload = function(){ alert('";
       script += msg;
       script += "');";
       script += "window.location = '";
       script += "'; }";
       ClientScript.RegisterStartupScript(this.GetType(), "Redirect", script, true);
   }

Make a little change in the existing code:

protected void BtnSearch_Click(object sender, ImageClickEventArgs e)
{
con.Open();
SqlCommand cmd = new SqlCommand("Select FirstName,LastName,EmpNo,ManagerName,Dept,Location,MobileNo,Email from Employees where FirstName='" + TxtSearch.Text + "' or EmpNo='" + TxtSearch.Text + "' ", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Table[0].Rows.Count > 0)
{
GVRecords.DataSource = ds;
GVRecords.DataBind();
}
else
{
Response.Write("alert('No Record Found!!!!')");
}
con.Close();
}