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

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();
}

Add a Solution

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..

How to clear data in gridview.

4 solutions

Solution 4

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

How to clear data in gridview.

4 solutions

Solution 4

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us