private void btnImportByExcel_Click(object sender, EventArgs e) { try { OpenFileDialog dlgDialog = new OpenFileDialog(); dlgDialog.Filter = "All File |*.*;|File Excel |*.xlsx;|File Excel |*.xls;"; dlgDialog.FilterIndex = 1; dlgDialog.AddExtension = true; dlgDialog.RestoreDirectory = true; dlgDialog.InitialDirectory = Application.StartupPath + "\\Template"; if (dlgDialog.ShowDialog() == DialogResult.OK) { try { string sourcefile = dlgDialog.FileName; string excelquery = string.Format("Select * from [{0}$]", SHEETNAME); ExcelDataAccess.SourceFile = sourcefile; ExcelDataAccess.OpenConnectionExcel(); DataSet ds = ExcelDataAccess.GetDataSet(excelquery); TinNhanSMS temp; if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { if (row[0].ToString().Length > 3) { temp = new TinNhanSMS(); temp.SoDienThoai = row[0].ToString(); temp.TenNhanVien = row[1].ToString(); temp.ThongTinThem = row[2].ToString(); _listData.Add(temp); } } } ExcelDataAccess.CloseConnectionExcel(); gridMessage.DataSource = _listData; gridViewMessage.RefreshData(); } catch (Exception ex) { new MessageBoxBA().Show(ex.ToString()); } } } catch (Exception ex) { LogError.WriteLogError("btnImportByExcel_Click: ", ex); } }