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();
}
