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();
}