Gridview No Record Found Problem

Question

0.00/5 (No votes)

See more:

I have a Gridview with Name Gridview1
I have a SqlDatasource with Name SqlDatasource1
I have a TextBox which can search SqlDatasource1
i have code like below

C#

protected void ButtonSearch_Click(object sender, EventArgs e)
   {
      SqlDataSource1.SelectCommand = "SELECT *FROM GOMSNO747 WHERE APPLICATIONNO='" + TextBoxApplicantionNumber.Text + "'";
    }

It works well when Record Found
When No Record Found I need to Show a Label with the Name No Record Found
I used <emptydatatemplate>No Record Found
The Problem is it sinks GridView Caption and No Record Found have a line around
In order to solve this i used below code

C#

protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)
    {
        if (e.AffectedRows == 0)
        {
            //Label1.Text = "Hai Krishna";
            LabelNoRecord.Text = "No Record Found";

        }


    }

But the Problem is it display No Record even if the Record is Founded also
The Reason is SELECT command is not effect the Rows
How to solve this Problem

Posted 30-Oct-11 19:54pm

krishna_goluguri

Add a Solution

2 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)

chandrashekhar racharla · Answer 1 · 2011-10-30T19:57:00

Solution 1

Hi krishna,

you have to set the property

C#

GridView.EmptyDataText = "No Record".

if you have no record

Posted 30-Oct-11 19:57pm

chandrashekhar racharla

Comments

krishna_goluguri 31-Oct-11 2:00am

The Problem is it sinks GridView Caption
GridView.EmptyDataText is Nothing But a <emptydatatemplate>No Record Found in GridView

krishna_goluguri 31-Oct-11 2:03am

my question is changed
in the gridview we have Empty Data Template there we can set No Record Found But it shrinks my Gridview Caption GridView.Empty Data Text and EmptyDataTemplate are same

raj ch · Answer 2 · 2011-10-30T20:34:00

In ur code just make a small modification

C#

protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)
    {
        if (e.AffectedRows == 0)
        {
            //Label1.Text = "Hai Krishna";
            LabelNoRecord.Visible=True;
            LabelNoRecord.Text = "No Record Found";

        }
       else
        {
        LabelNoRecord.Visible=False;

        }


    }