private void btnOpenExcel_Click(object sender, EventArgs e) { try { txtBlockNo.EditValue = objMasterService.GetNew_Sochungtu("ware_dm_hanghoa_ban_import", "block_no", ""); frmImportFromExcel = new GoobizFrame.Windows.Tools.FrmImportFromExcel(); frmImportFromExcel.Text = "Nhập hàng hóa từ file Excel"; frmImportFromExcel.ShowDialog(); if (frmImportFromExcel.DsImportData != null && frmImportFromExcel.DsImportData.Tables.Count > 0) { dsMaps = new DataSet(); dsMaps.Tables.Add(); dsMaps.Tables[0].Columns.Add("Excel_Col"); dsMaps.Tables[0].Columns.Add("FieldName"); foreach (DataColumn col in frmImportFromExcel.DsImportData.Tables[0].Columns) { DataRow ndr = dsMaps.Tables[0].NewRow(); ndr["Excel_Col"] = col.ColumnName; dsMaps.Tables[0].Rows.Add(ndr); } dsMaps.AcceptChanges(); dgColumnsMap.DataSource = dsMaps; dgColumnsMap.DataMember = dsMaps.Tables[0].TableName; //show selected data gridView3.Columns.Clear(); int visibleIndex = 0; foreach (DataColumn col in frmImportFromExcel.DsImportData.Tables[0].Columns) { try { DevExpress.XtraGrid.Columns.GridColumn GridColumn = new DevExpress.XtraGrid.Columns.GridColumn(); GridColumn.FieldName = col.ColumnName; GridColumn.Caption = col.ColumnName; GridColumn.VisibleIndex = visibleIndex++; GridColumn.Visible = true; gridView3.Columns.Add(GridColumn); } catch (Exception ex) { continue; } } dgDataImport.DataSource = frmImportFromExcel.DsImportData; dgDataImport.DataMember = frmImportFromExcel.DsImportData.Tables[0].TableName; gridView3.BestFitColumns(); showTabPages(tab_ChonCot); } } catch (Exception ex) { GoobizFrame.Windows.Forms.MessageDialog.Show(ex.Message, ex.ToString(), ""); } }
private void btnOpenExcel_Click(object sender, EventArgs e) { FrmImportFromExcel = new GoobizFrame.Windows.Tools.FrmImportFromExcel(); FrmImportFromExcel.ShowDialog(); if (FrmImportFromExcel.DsImportData != null && FrmImportFromExcel.DsImportData.Tables.Count > 0) { dsMaps = new DataSet(); dsMaps.Tables.Add(); dsMaps.Tables[0].Columns.Add("Excel_Col"); dsMaps.Tables[0].Columns.Add("FieldName"); foreach (DataColumn col in FrmImportFromExcel.DsImportData.Tables[0].Columns) { DataRow ndr = dsMaps.Tables[0].NewRow(); ndr["Excel_Col"] = col.ColumnName; dsMaps.Tables[0].Rows.Add(ndr); } dsMaps.AcceptChanges(); dgColumnsMap.DataSource = dsMaps; dgColumnsMap.DataMember = dsMaps.Tables[0].TableName; //show selected data gridView3.Columns.Clear(); int visibleIndex = 0; foreach (DataColumn col in FrmImportFromExcel.DsImportData.Tables[0].Columns) { try { DevExpress.XtraGrid.Columns.GridColumn GridColumn = new DevExpress.XtraGrid.Columns.GridColumn(); GridColumn.FieldName = col.ColumnName; GridColumn.Caption = col.ColumnName; GridColumn.VisibleIndex = visibleIndex++; GridColumn.Visible = true; gridView3.Columns.Add(GridColumn); } catch (Exception ex) { continue; } } dgDataImport.DataSource = FrmImportFromExcel.DsImportData; dgDataImport.DataMember = FrmImportFromExcel.DsImportData.Tables[0].TableName; gridView3.BestFitColumns(); } }