private void btnExcel_Click(object sender, EventArgs e) { if (MyDs.Tables.Count > 0) { if (MyDs.Tables[0].Rows.Count > 0) { PleaseWait frmPW = new PleaseWait(); frmPW.Show(); Application.DoEvents(); FastExportingMethod.ExportToExcel(MyDs);//, sfd.FileName); frmPW.Close(); } } }
private void miExportTable_Click(object sender, System.EventArgs e) { if (MyDs.Tables.Count > 0) { if (MyDs.Tables[0].Rows.Count > 0) { PleaseWait frmPW = new PleaseWait(); frmPW.Show(); Application.DoEvents(); FastExportingMethod.ExportToExcel(MyDs); frmPW.Close(); } } }
private void ExportSelected() { DataSet SelectedDataSet = new DataSet(); DataTable dt = new DataTable(); String SQL = @"SELECT ProductGroup, Description, SerialNumber as [Serial Number], DMMPropertyNum as [DMM Property Number], Status, AssignedToDep as [Assigned To Department], AssignedTo as [Assigned To], Quantity, IPAddress as [IP Address], '' as [Date of change], UserName as [Changed by], Serviser as [Supplier/Servicer], AssignementNumber as [Assignement Form], RelatedBDA as [Related BDA], Notes FROM Items i LEFT OUTER JOIN Assignement as a on a.AssignementId = i.AssignementID WHERE 1=2"; dt = Vasko.ReturnDataTable(SQL); SelectedDataSet.Tables.Add(dt); foreach (DataGridViewRow dr in outlookGrid1.Rows) { if (dr.Selected) { DataRow drNew = SelectedDataSet.Tables[0].NewRow(); drNew[0] = dr.Cells[1].Value; drNew[1] = dr.Cells[2].Value; drNew[2] = dr.Cells[3].Value; drNew[3] = dr.Cells[4].Value; drNew[4] = dr.Cells[5].Value; drNew[5] = dr.Cells[6].Value; drNew[6] = dr.Cells[7].Value; drNew[7] = dr.Cells[8].Value; drNew[8] = dr.Cells[9].Value; drNew[9] = dr.Cells[10].Value.ToString(); drNew[10] = dr.Cells[11].Value; drNew[11] = dr.Cells[12].Value; drNew[12] = dr.Cells[13].Value; drNew[13] = dr.Cells[15].Value; drNew[14] = dr.Cells[16].Value; //drNew[15] = dr.Cells[15].Value; SelectedDataSet.Tables[0].Rows.Add(drNew); } } if (SelectedDataSet.Tables[0].Rows.Count > 0) { PleaseWait frmPW = new PleaseWait(); frmPW.Show(); Application.DoEvents(); FastExportingMethod.ExportToExcel(SelectedDataSet);//, sfd.FileName); frmPW.Close(); } }
public static void ExportToExcel() { DataTable table = new DataTable(); TransactionWork transactionWork = null; SqlParameter[] parameters = new SqlParameter[3]; SqlParameter parameter = new SqlParameter(); parameter.DbType = DbType.String; parameter.Size = 100; parameter.ParameterName = "@whereClasure"; parameter.Value = whereClasure; parameters[0] = parameter; parameter = new SqlParameter(); parameter.DbType = DbType.String; parameter.ParameterName = "@Param"; parameter.Size = 100; if (value == null) { parameter.Value = string.Empty; } else { parameter.Value = value; } parameter.IsNullable = true; parameters[1] = parameter; parameter = new SqlParameter(); parameter.DbType = DbType.String; parameter.Size = 30; parameter.ParameterName = "@ParamType"; parameter.Value = dbType; parameter.IsNullable = true; parameters[2] = parameter; try { using (transactionWork = (TransactionWork)TransactionFactory.Create()) { transactionWork.Execute(table, "uspDynamicQuery", parameters); transactionWork.Commit(); } } catch (Exception) { transactionWork?.Rollback(); throw; } FastExportingMethod.ExportToExcel(table, Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "List")); FastExportingMethod.GemExportToExcel(table, Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "List2.xls")); table.Dispose(); table = null; GC.Collect(); GC.WaitForPendingFinalizers(); }