private void btnViewData_Click(object sender, EventArgs e) { try { if (txtFilePath.Text != "") { DataTable dt = OpenFileExcel.getDataExcelFromFileToDataTable(txtFilePath.Text); dt.Rows.RemoveAt(0); UC_ViewData uc = new UC_ViewData(dt); frmShowWindow frm = new frmShowWindow(); frm.Controls.Clear(); uc.Dock = DockStyle.Fill; frm.Text = "Hiển thị dữ liệu"; frm.Controls.Add(uc); frm.ShowDialog(); } else { XtraMessageBox.Show("Bạn chưa chọn file để hiển thị"); } } catch (Exception ex) { XtraMessageBox.Show("" + ex.Message, "Lỗi"); } }
private void cbbSheet_SelectedIndexChanged(object sender, EventArgs e) { _dataTempView = new DataTable(); string selectSheet = cbbSheet.Text; _dataTempView = OpenFileExcel.getDataExcelFromFileToDataTable(txtPathFile1.Text, selectSheet); gridControl1.DataSource = _dataTempView; }