asked on
Clear GridView Dataset
Hello:
I have a textbox that searches a gridview. When I clear the results from a search and do another search, the results from the previous search shows. LastNameSearch is the textbox that searches the GridView.
I have a textbox that searches a gridview. When I clear the results from a search and do another search, the results from the previous search shows. LastNameSearch is the textbox that searches the GridView.
protected void GridSearch_Click(object sender, EventArgs e)
{
BindGridView1();
}
protected void GridSearchClear_Click(object sender, EventArgs e)
{
GridView1.DataSource = null;
LastNameSearch.Text = "";
}
<asp:Button ID="GridSearch" Text="Search" runat="server" onclick="GridSearch_Click" />
<asp:Button ID="GridSearchClear" Text="Clear" runat="server" onclick="SearchClear_Click" />
ASP.NETC#
Last Comment
RecipeDan
call databind after setting null,
GridView1.DataSource = null;
GridView1.DataBind();
ASKER
@Meetan03...i tried that and it still doesn't work
@Chinmay...is onclick page_load or a postback? I have both on the page.
Dan
@Chinmay...is onclick page_load or a postback? I have both on the page.
Dan
It is on page load, postback is just a check you perform to identify if the page is loading again in response of a user action or not. So I'd suggest you check on Page Load first.
Copy paste content of the Page_Load here so I can have a good look at it.
Copy paste content of the Page_Load here so I can have a good look at it.
try this
GridView1.DataSource=null;
GridView1.DataBind();
GridView1.DataSource=null;
GridView1.DataBind();
I mean in this function
before bind new data
protected void GridSearch_Click(object sender, EventArgs e)
{
GridView1.DataSource=null;
GridView1.DataBind();
BindGridView1();
}
before bind new data
protected void GridSearch_Click(object sender, EventArgs e)
{
GridView1.DataSource=null;
GridView1.DataBind();
BindGridView1();
}
if your loading gridview on pageload then do check with line .
If (!Ispostback){bindgrid();}
If (!Ispostback){bindgrid();}
ASKER
Hello:
I tried the suggestions and still get the same result:
Here is the whole script in succession:
I tried the suggestions and still get the same result:
Here is the whole script in succession:
<asp:ImageButton ID="ImgPanel" ImageUrl="~/Images/quesmarkicon.png" runat="server" onclick="ImgPanel_Click" />
protected void ImgPanel_Click(object sender, ImageClickEventArgs e)
{
GridPanel.Visible = true;
ClosePanel.Visible = true;
LastNameSearchLabel.Visible = true;
LastNameSearch.Visible = true;
GridSearch.Visible = true;
GridSearchClear.Visible = true;
}
<asp:Panel ID="GridPanel" runat="server">
<asp:ImageButton ID="ClosePanel" Visible="false" onclick="ClosePanel_Click" ImageAlign="Right" ImageUrl="~/Images/Close.gif" runat="server" />
<br />
<table>
<tr>
<td>
<asp:Label ID="LastNameSearchLabel" Visible="false" runat="server" Text="Enter Last Name: " />
</td>
<td>
<asp:TextBox ID="LastNameSearch" Visible="false" runat="server" />
</td>
</tr>
<tr>
<td align="center" colspan="2">
<asp:Button ID="GridSearch" Visible="false" Text="Search" runat="server" onclick="GridSearch_Click" />
<asp:Button ID="GridSearchClear" Visible="false" Text="Clear" runat="server" onclick="GridSearchClear_Click" />
</td>
</tr>
</table>
<br />
<asp:GridView ID="GridView1" GridLines="None" runat="server" OnSorting="GridView1_Sorting"
OnPageIndexChanging="GridView1_PageIndexChanging" AllowPaging="true"
PageSize="10" AutoGenerateColumns="false" AllowSorting="True">
<Columns>
<asp:TemplateField HeaderText="Select">
<ItemTemplate>
<asp:CheckBox id="CStatus" AutoPostBack="true" OnCheckedChanged="CStatus_OnCheckedChanged" runat="server" />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="PName" SortExpression="PName" HeaderText="Name" />
<asp:BoundField DataField="UserEMailAddress" SortExpression="UserEMailAddress" HeaderText="E-Mail" />
</Columns>
</asp:GridView>
</asp:Panel>
protected void GridSearch_Click(object sender, EventArgs e)
{
GridView1.DataSource=null;
GridView1.DataBind();
BindGridView1();
}
protected void GridSearchClear_Click(object sender, EventArgs e)
{
GridView1.DataSource = null;
LastNameSearch.Text = "";
}
protected void GridSearchClear_Click(object sender, EventArgs e)
{
GridView1.DataSource = null;
GridView1.DataBind();//Still Missing on your code
LastNameSearch.Text = "";
}
ASKER
Still the same result...
try this sample and check what your missing on your code .
Meeran03
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ImageButton ID="ImgPanel" ImageUrl="~/Images/quesmarkicon.png" runat="server" AlternateText="Search" onclick="ImgPanel_Click" />
<asp:Panel ID="GridPanel" runat="server">
<%-- <asp:ImageButton ID="ClosePanel" Visible="false" onclick="ClosePanel_Click" ImageAlign="Right" ImageUrl="~/Images/Close.gif" runat="server" />
--%>
<br />
<table>
<tr>
<td>
<asp:Label ID="LastNameSearchLabel" Visible="false" runat="server" Text="Enter Last Name: " />
</td>
<td>
<asp:TextBox ID="LastNameSearch" Visible="false" runat="server" />
</td>
</tr>
<tr>
<td align="center" colspan="2">
<asp:Button ID="GridSearch" Visible="false" Text="Search" runat="server" onclick="GridSearch_Click" />
<asp:Button ID="GridSearchClear" Visible="false" Text="Clear" runat="server" onclick="GridSearchClear_Click" />
</td>
</tr>
</table>
<br />
<asp:GridView ID="GridView1" GridLines="None" runat="server"
PageSize="10" AutoGenerateColumns="true" >
</asp:GridView>
</asp:Panel>
</div>
</form>
</body>
</html>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void GridSearch_Click(object sender, EventArgs e)
{
GridView1.DataSource = null;
GridView1.DataBind();
BindGridView1();
}
protected void GridSearchClear_Click(object sender, EventArgs e)
{
GridView1.DataSource = null;
GridView1.DataBind();
LastNameSearch.Text = "";
}
protected void ImgPanel_Click(object sender, ImageClickEventArgs e)
{
GridPanel.Visible = true;
// ClosePanel.Visible = true;
LastNameSearchLabel.Visible = true;
LastNameSearch.Visible = true;
GridSearch.Visible = true;
GridSearchClear.Visible = true;
}
public void BindGridView1()
{
GridView1.DataSource = GetTable();//Temporary Dataset
GridView1.DataBind();
}
static DataTable GetTable()
{
//
// Here we create a DataTable with four columns.
//
DataTable table = new DataTable();
table.Columns.Add("Dosage", typeof(int));
table.Columns.Add("Drug", typeof(string));
table.Columns.Add("Patient", typeof(string));
table.Columns.Add("Date", typeof(DateTime));
//
// Here we add five DataRows.
//
table.Rows.Add(25, "Indocin", "David", DateTime.Now);
table.Rows.Add(50, "Enebrel", "Sam", DateTime.Now);
table.Rows.Add(10, "Hydralazine", "Christoff", DateTime.Now);
table.Rows.Add(21, "Combivent", "Janet", DateTime.Now);
table.Rows.Add(100, "Dilantin", "Melanie", DateTime.Now);
return table;
}
}
Meeran03
ASKER
It works but it lists all records in the temporary table. If I type David the record for David should show. Then I press Clear and type Sam. Sam's record should show.
That is not happening in my original question. For example, I would type David and David's record lists. then I press clear and type Sam. David's record would still show.
That is not happening in my original question. For example, I would type David and David's record lists. then I press clear and type Sam. David's record would still show.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Sorry I was out of town for New Years. It works great! Thank you for your help.
I'd suggest to look into BindGridView1(); method. You might have cached the search result somewhere and on PageLoad you might be binding it to the GridView again.
Regards,
Chinmay.