How to refresh(clear the GV data) gridview on button click event? C# ASP.NET

Question

0.00/5 (No votes)

See more:

I am binding the data to gridview on button click with input,if records exist GV will display data, if there is no records with input data then it will display some msg,
When IF condition is true data loads and diplays when IF condition is not true then msg will display but old GV data will still display on page, How to clear that data ? i want display only msg when IF condition is not true.

C#

protected void btnGV1_Click(object sender, EventArgs e)
{
    string personid = TBpersonid.Text;
    String connstring = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
    SqlConnection con = new SqlConnection(connstring);
    SqlCommand cmd = new SqlCommand("select * from[Transactions_log] where person_id=@personid ", con);
    cmd.Parameters.AddWithValue("@personid",personid);
    con.Open();
    SqlDataReader Er = cmd.ExecuteReader();
    if (Er.HasRows==true)
    {
        GV1.DataSource = Er;
        GV1.DataBind();
    }
    else
    {
        Response.Write("No records found for the user: "+personid+"");
    }
}

What I have tried:

if (!IsPostBack) works ? if yes how to implement it?

Posted 3-Sep-18 21:56pm

Virendra S from Bangalore, Karnataka

Updated 4-Sep-18 4:00am

Add a Solution

1 solution

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)

Vincent Maverick Durano · Accepted Answer · 2018-09-04T04:00:00

GridView will only display if there's data associated on it. Have you binded your GridView on Page_Load event? If you did, then make sure that you wrap your code within !IsPosBack block:

C#

protected void Page_Load(object sender, EventArgs e)
{
     if(!IsPostBack){
           //bind your gridview here
     }
}

If you want to force your GridView to clear the data and hide it, then you can set the datasource to nothing like this:

C#

GV1.DataSource = null;
Gv1.DataBind();