BKI_DichVuMatDat.BaoCao.f409_rpt_bang_luong_nv_v2.xuat_excel_nhan_vien_chua_co_trong_csdl C# (CSharp) Method

        private void xuat_excel_nhan_vien_chua_co_trong_csdl()
        {
            DataTable v_dt_src = new DataTable();
            v_dt_src.Columns.Add("MA_NV");
            v_dt_src.Columns["MA_NV"].DataType = typeof(string);
            foreach(var item in m_lst_nhan_vien_khong_ton_tai)
            {
                v_dt_src.Rows.Add(item);
            }
            gridControl1.DataSource = v_dt_src;

            SaveFileDialog saveFileDialog1 = new SaveFileDialog();
            saveFileDialog1.Filter = "xlsx files (*.xlsx)|*.xls|All files (*.*)|*.*";
            saveFileDialog1.RestoreDirectory = true;
            if(saveFileDialog1.ShowDialog() == DialogResult.OK)
            {
                gridView1.ExportToXls(saveFileDialog1.FileName);
                DevExpress.XtraEditors.XtraMessageBox.Show("Trích xuất thành công. File sẽ tự động mở sau đây!", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Information);
                open_file_excel_created(saveFileDialog1.FileName);
            }
        }