How to clear data in gridview.

Question

1.00/5 (1 vote)

See more:

i have dropdownlist. In dropdown has different options. when i have selected dropdown to display data in gridview.

My problem is frequently i'm selecting dropdown gridview previously data its showing.

How to clear data in gridview..

Posted 7-Aug-12 2:04am

kumar2233

Add a Solution

Comments

Prabhakaran Soundarapandian 7-Aug-12 8:25am

If you want a clear solution means show your code...

bbirajdar 7-Aug-12 8:37am

Right.. :)

balongi 23-Feb-15 4:48am

bind with null as datasource

4 solutions

Solution 4

Clear your dataSet after binding of Gridview.

C#

GridView1.Datasource=ds;
GridView1.Databind();
ds.Clear();

Thanks
AShish

Posted 7-Aug-12 3:03am

AshishChaudha

Solution 3

Set the DataSource of GridView to null on SelectedIndexChanged event of your DropDownList and then call your GridView Binding function.

C#

Gridview1.DataSource = null;
Gridview1.DataBind();
fnBindGrid(ddlTest.SelectedValue);
private void fnBindGrid(string str){
    //bind your gridview here.
}

--Amit

Posted 7-Aug-12 2:45am

_Amy

Comments

Member 15088142 3-Mar-21 6:14am

private void cmbServer_SelectedIndexChanged(object sender, EventArgs e)
{
LicenseAllctnGridView.Rows.Clear();
LicenseAllctnGridView.Columns.Clear();
LicenseAllctnGridView.DataSource = objDBIO.ImportLicenseUsageDataFromDB(DBPath);
((DataTable)LicenseAllctnGridView.DataSource).DefaultView.RowFilter = $"Server Like '{cmbServer.SelectedItem.ToString()}%'";
this.LicenseAllctnGridView.Columns["Server"].Visible = false;
// LicenseAllctnGridView.Rows.Clear();
}

Solution 2

If you change the data of gridview whenever you change the dropdownlist item means...in your dropdown selection changed event add

C#

Gridview1.DataBind();

Posted 7-Aug-12 2:24am

Prabhakaran Soundarapandian

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)

bbirajdar · Accepted Answer · 2012-08-07T02:09:00

Solution 1

Use this code where you want to clear it

C#

Gridview1.DataSource = null;
       Gridview1.DataBind();

Posted 7-Aug-12 2:09am

bbirajdar

Comments

kumar2233 7-Aug-12 8:14am

i try but. in dropdown different 5 options are their. i select any option to display data in gridview. but i select another option previous data its showing. so Gridview data is not clear.

bbirajdar 7-Aug-12 8:37am

Show your code...If you expect to get a exact reply and if you really want to solve the problem..How can I guess what code you have written ?

kumar2233 8-Aug-12 0:50am

i'm using asp.net and vb.net
..............................

Protected Sub dropdownlist1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles

ui_ddl_Reports.SelectedIndexChanged
dropdownlist1.datasource= ds
dropdownlist1.databind()

gridview1.datasource=nothing
gridview1.databind()

End

bbirajdar 8-Aug-12 2:55am

Here the mistake is...

Put this code is Page_Load
dropdownlist1.datasource= ds
dropdownlist1.databind()

And the rest will work...

next time You should show your code first if you want a quick answer..