private void btnExportExcel_Click(object sender, EventArgs e)
{
SaveFileDialog savefile = new SaveFileDialog();
savefile.OverwritePrompt = true;
savefile.DefaultExt = "*.xlsx";
savefile.Filter = "Execl Workbook(*.xlsx)|*.xlsx";
if (savefile.ShowDialog() == DialogResult.OK)
{
string path = Path.GetFullPath(savefile.FileName);
Excelutlity exl = new Excelutlity();
exl.WriteDataTableToExcel(TonBUL.SellectAllTonsBUL(), "Customers", path, "Details");
MessageBox.Show("Excel đã được tạo !");
}
}
private void btnExportExcel_Click(object sender, EventArgs e)
{
try
{
SaveFileDialog savefile = new SaveFileDialog();
savefile.OverwritePrompt = true;
savefile.DefaultExt = "*.xlsx";
savefile.Filter = "Execl Workbook(*.xlsx)|*.xlsx";
if (savefile.ShowDialog() == DialogResult.OK)
{
string path = Path.GetFullPath(savefile.FileName);
Excelutlity exl = new Excelutlity();
exl.WriteDataTableToExcel(CongNoBUL.SellectAllCongNosBUL(), "Customers", path, "Details");
MessageBox.Show("Excel đã được tạo !");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}