When gridview not fill how can I show error message?

Question

0.00/5 (No votes)

See more:

this is my code I want to fill gridview from mysql database but if there is no data gridview not fill this is OK..

but I want to error message or warning message this if gridview not fill this personel not registrated yed.

this is my code

XML

string sql = "";
           sql = "SELECT distinct(person)as X,person.personname,person.personsurname FROM `person`,`user`  WHERE personid='" + id+ "' and person.id=user.id";
           MySqlConnection conn = new MySqlConnection(Connect.connStr);
           conn.Open();
           MySqlCommand cmde = new MySqlCommand(sql, conn);
           MySqlDataAdapter xAdapter = new MySqlDataAdapter(cmde);
           DataSet daset = new DataSet();
           xAdapter.Fill(daset);
           GridView1.DataSource = daset;
           if (GridView1.DataSource.ToString() == "" || GridView1.DataSource.ToString() == null || GridView1.DataSource.ToString() == "0")
           {
              
              this person not registered yed I want to give this message

           }
           GridView1.DataBind();
           conn.Close();

Posted 15-Mar-13 1:45am

Member-2338430

Add a Solution

Comments

[no name] 15-Mar-13 7:49am

Okay so what is the problem? Popup a javascript alert.

Member-2338430 15-Mar-13 7:58am

if (GridView1.DataSource.ToString() == "" || GridView1.DataSource.ToString() == null || GridView1.DataSource.ToString() == "0")
{

this person not registered yed I want to give this message

}
this part not runnnn

Member-2338430 15-Mar-13 8:07am

there is no person but this if statement jump GridView1.DataBind();

[no name] 15-Mar-13 9:51am

If that is your actual problem then why is your question about how to show an error message?

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)

CHill60 · Answer 1 · 2013-03-15T01:53:00

Quite a nice way of displaying errors on the same asp page is to use a ValidationSummary control then add a CustomValidator. Have a look at this link for an example http://justgeeks.blogspot.co.uk/2010/11/adding-item-to-validationsummary.html[^]

An alternative would be to generate a custom error page, but I'm not fond of redirection in these cases

_Amy · Answer 2 · 2013-03-15T02:06:00

Try this:

C#

if (GridView1.DataSource.ToString() == "" || GridView1.DataSource.ToString() == null || GridView1.DataSource.ToString() == "0")
{
    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "FileRegister", "alert('Notification : User not registered.');", true);
}

--Amit

When gridview not fill how can I show error message?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0