asked on ASP.NET clear label after clicking on submit button
I have a form that exports data to excel when clicking on the submit button. I obtain data from a SPROC in a database and dump the data to a DataTable. If the dt.rows.count > 0 then I continue to export otherwise I set a label on the page ("lblMsg") to indicate no records were found.
I intentionally make it fail by looking for data I know does not exist. The message displays correctly. However, when I make it look for data that does not exist lblMsg does not remove the Message even though I have stuck lblMsg.Text = "" all over the place.
Any ideas how to resolve?
I intentionally make it fail by looking for data I know does not exist. The message displays correctly. However, when I make it look for data that does not exist lblMsg does not remove the Message even though I have stuck lblMsg.Text = "" all over the place.
Any ideas how to resolve?
ASP.NETC#Visual Basic.NET
Last Comment
chiu ft
Can you show the code?
ASKER
This Method is called after clicking on the Submit Button
protected void ExportToExcel(DataTable dt)
{
this.lblMsg.Text = ""; NOT WORKING
string sFileName = "MyFile_" + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + ".xls";
GridView gv = new GridView();
gv.AllowPaging = false;
gv.DataSource = dt;
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", sFileName));
Response.ContentType = "application/vnd.ms-excel";
//Response.ContentType = "application/vnd.openxmlformats";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
//Change the Header Row Foreground to white color
gv.HeaderRow.Style.Add("color", "#FFFFFF");
//Applying stlye to gridview header cells
for (int i = 0; i < gv.HeaderRow.Cells.Count; i++)
{
//Change to Blue
gv.HeaderRow.Cells[i].Style.Add("background-color", "#507CD1");
}
int j = 1;
//This loop is used to apply stlye to cells based on particular row
foreach (GridViewRow gvrow in gv.Rows)
{
gvrow.BackColor = Color.White;
if (j <= gv.Rows.Count)
{
if (j % 2 != 0)
{
for (int k = 0; k < gvrow.Cells.Count; k++)
{
gvrow.Cells[k].Style.Add("background-color", "#EFF3FB");
}
}
}
j++;
}
gv.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
Response.Flush();
}
Are you expecting the label to clear before the export? Is the Rendering of grid not being done?
Label would only clear once the processing has been completed on the server and response returns to client.
Label would only clear once the processing has been completed on the server and response returns to client.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER
I'm not trying to render the grid. I am using the grid to export the data in the datatable. Excel is opening and my data is properly formatted in Excel. The Label is NOT clearing at all - no matter where I put the code to clear.
I moved this.lblMsg.text = "" to after Response.Flush(); It is not working.
I moved this.lblMsg.text = "" to after Response.Flush(); It is not working.
It would because after the following
Response.Write(sw.ToString
Response.End();
Response.Flush();
nothing else goes to the client.
Response.Write(sw.ToString
Response.End();
Response.Flush();
nothing else goes to the client.
ASKER
What is the solution then?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Clear the label on client hand side before submission to the server. Use OnClientClient to execute the javascript.
ASKER
javascript solution seems not to be working
Show the code you have tried.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER
<asp:Content ID="Content2" ContentPlaceHolderID="cphBody" Runat="Server">
<script type="text/javascript">
function ClearTextbox() {
document.getElementById('<%=lblMsg.ClientID%>').value = '';
return false;
}
</script>
<asp:Label ID="lblMsg" runat="server" Text=""></asp:Label>
<asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClick="btnSubmit_Click"
OnClientClick="return ClearTextbox();" />
</asp:Content>
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a questionASKER
Thank You!
this work!!!
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.