Comments by nileshpujari

nileshpujari 31-Dec-12 5:13am View

yup u r rite...dat was also solved using datatable.... and the previos prob was solved in foll way...
the button that was supposd ti generate excel file that button should be taken in <Triggers> tab and in that <asp:Postbacktrigger>...
thanx...

nileshpujari 31-Dec-12 4:26am View

hey my that problem is solved..but another one has arisen...excel file is getting generated...but i have used paging while showing the data that i wanted to export in excel...so the problem is the entire data is not comin in excel..instead only the first data is cumin...wat mite b the prob..

nileshpujari 31-Dec-12 4:25am View

hey dude...that problem is solved..but another one has arisen...excel file is getting generated...but i have used paging while showing the data that i wanted to export in excel...so the problem is the entire data is not comin in excel..instead only the first data is cumin...wat mite b the prob..

nileshpujari 31-Dec-12 4:09am View

WajihAhmed... r u der...??

nileshpujari 31-Dec-12 4:01am View

aspnet_regiis..
my question is that why my excel file not getting generated...

nileshpujari 31-Dec-12 4:00am View

The following is my code....

protected void btngenexcel_Click(object sender, EventArgs e)
{
ExportXls(grdMails,"MailsData");
grdMails.DataSource = null;
grdMails.DataBind();
modalShowMails.Hide();
}

public static void ExportXls(GridView gridName, string filename)
{
string attachment = "attachment; filename=" + filename + ".xls";
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.AddHeader("content-disposition", attachment);
HttpContext.Current.Response.ContentType = "application/ms-excel";
StringWriter sWriter = new StringWriter();

HtmlTextWriter htwWriter = new HtmlTextWriter(sWriter);

gridName.RenderControl(htwWriter);
HttpContext.Current.Response.Write(sWriter.ToString());
HttpContext.Current.Response.End();

}

}

nileshpujari 31-Dec-12 4:00am View

aspnet_regiis..
my question is that why my excel file not getting generated...

nileshpujari 31-Dec-12 3:59am View

The following is my code....

protected void btngenexcel_Click(object sender, EventArgs e)
{
ExportXls(grdMails,"MailsData");
grdMails.DataSource = null;
grdMails.DataBind();
modalShowMails.Hide();
}

public static void ExportXls(GridView gridName, string filename)
{
string attachment = "attachment; filename=" + filename + ".xls";
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.AddHeader("content-disposition", attachment);
HttpContext.Current.Response.ContentType = "application/ms-excel";
StringWriter sWriter = new StringWriter();

HtmlTextWriter htwWriter = new HtmlTextWriter(sWriter);

gridName.RenderControl(htwWriter);
HttpContext.Current.Response.Write(sWriter.ToString());
HttpContext.Current.Response.End();

}

}

Comments by nileshpujari (Top 8 by date)