private void btnimport_Click(object sender, EventArgs e) { string oldPath = Directory.GetCurrentDirectory(); OpenFileDialog of = new OpenFileDialog(); of.ShowDialog(); string strPathName = of.FileName; Directory.SetCurrentDirectory(oldPath); DataTable dt = ExcelRead.getSheet(strPathName, "sheet1"); for (int i = 0; i < dt.Rows.Count; i++) { TheLoaiDTO tl = new TheLoaiDTO(); tl.TenTheLoai = dt.Rows[i].ItemArray[1].ToString(); TheLoaiDAO.Insert(tl); } MessageBox.Show("Import dữ liệu thành công ...", "Thông báo"); HienThiDanhSach(); }
private void btnimport_Click(object sender, EventArgs e) { string oldPath = Directory.GetCurrentDirectory(); OpenFileDialog of = new OpenFileDialog(); of.ShowDialog(); string strPathName = of.FileName; Directory.SetCurrentDirectory(oldPath); DataTable dt = ExcelRead.getSheet(strPathName, "sheet1"); for (int i = 0; i < dt.Rows.Count; i++) { KhachHangDTO kh = new KhachHangDTO(); kh.HoTenKhachHang = dt.Rows[i].ItemArray[1].ToString(); kh.DienThoai = int.Parse(dt.Rows[i].ItemArray[2].ToString()); kh.DiaChi = dt.Rows[i].ItemArray[3].ToString(); kh.Email = dt.Rows[i].ItemArray[4].ToString(); KhachHangDAO.Insert(kh); } MessageBox.Show("Import dữ liệu thành công ...", "Thông báo"); HienThiDanhSach(); }
private void btnimport_Click(object sender, EventArgs e) { string oldPath = Directory.GetCurrentDirectory(); OpenFileDialog of = new OpenFileDialog(); of.ShowDialog(); string strPathName = of.FileName; Directory.SetCurrentDirectory(oldPath); DataTable dt = ExcelRead.getSheet(strPathName, "sheet1"); for (int i = 0; i < dt.Rows.Count; i++) { SachDTO s = new SachDTO(); s.TenSach = dt.Rows[i].ItemArray[1].ToString(); s.GiaBan = int.Parse(dt.Rows[i].ItemArray[2].ToString()); s.SoLuongTon = int.Parse(dt.Rows[i].ItemArray[3].ToString()); s.TacGia = dt.Rows[i].ItemArray[4].ToString(); s.MaTheLoai = int.Parse(dt.Rows[i].ItemArray[5].ToString()); SachDAO.Insert(s); } MessageBox.Show("Import dữ liệu thành công ...", "Thông báo"); HienThiDanhSach(); }