protected void btnExport_Click(object sender, EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename = Weight.xls");
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite =
new HtmlTextWriter(stringWrite);
GrdWeightCompletedScheduleStatus.AllowPaging = false;
GrdWeightCompletedScheduleStatus.RenderControl(htmlWrite);
BindWeightCompletedScheduleStatusGrd();
Response.Write(stringWrite.ToString());
Response.End();
}
protected void BindWeightCompletedScheduleStatusGrd()
{
try
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@OPR", "44"),
new SqlParameter("@ScheduleTypeId", "4"),
new SqlParameter("@ShiftCode", lblshift.Text.Trim())
};
DataTable Dt = new DataTable();
Dt = DBClass.GetDatatable_WithParam(param, "DM_SP_GET_DATA");
GrdWeightCompletedScheduleStatus.DataSource = Dt;
GrdWeightCompletedScheduleStatus.DataBind();
}
catch (Exception ex)
{
_logger.Error(string.Concat("BindWeightCompletedScheduleStatusGrd::", ex.Message), ex);
}
}
