//DataGrid Functions private void DisplayGrid() { try { Whitfieldcore _dbClass = new Whitfieldcore(); DataSet _dsWorkOrders = new DataSet(); _dsWorkOrders = _dbClass.GetAllMaterials(Convert.ToInt32(ddlMatType.SelectedItem.Value)); PopulateDataGrid(_dsWorkOrders, grdpl1); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } }
protected void btnexport_Click(object sender, EventArgs e) { try { Whitfieldcore _dbClass = new Whitfieldcore(); DataSet dsRpAdvances = _dbClass.GetAllMaterials(Convert.ToInt32(ddlMatType.SelectedItem.Value)); ExportDataSetToExcel(dsRpAdvances, "SystemListing.xls"); } catch (Exception) { throw; } }