private void hienthi() { daSqllite dl = new daSqllite(); DataSet ds = new DataSet(); ds = dl.loadData(); if (ds.Tables.Count > 0) { ListTaiKhoan.DataSource = ds.Tables[0]; } }
private void btnimport_Click(object sender, EventArgs e) { OpenFileDialog dlg = new OpenFileDialog(); dlg.RestoreDirectory = true; dlg.Filter = "Excel 2003|*.xls|Excel 2007|*.xlsx|All files (*.*)|*.*"; if (dlg.ShowDialog() == DialogResult.OK) { DuLieuExcel dExcel = new DuLieuExcel(); DataTable DuLieu = new DataTable(); DuLieu = Excel_To_DataTable(dlg.FileName, 0); if (DuLieu.Rows.Count > 0) { foreach (DataRow r in DuLieu.Rows) { #region // truyền biến string UID = r["UID"].ToString(); string USERNAME = r["USERNAME"].ToString(); string PASSWORD = r["PASSWORD"].ToString(); string SECRET = r["SECRET"].ToString(); string COOKIES = r["COOKIES"].ToString(); int DAY = 0; try { DAY = int.Parse(r["DAY"].ToString()); } catch { } int MONTH = 0; try { MONTH = int.Parse(r["MONTH"].ToString()); } catch { } int YEAR = 0; try { YEAR = int.Parse(r["YEAR"].ToString()); } catch { } string FULLNAME = r["FULLNAME"].ToString(); string GENDER = r["GENDER"].ToString(); string AVATAR = r["AVATAR"].ToString(); string COVER = r["COVER"].ToString(); string HOME = r["HOME"].ToString(); string CITY = r["CITY"].ToString(); string BIO = r["BIO"].ToString(); string WORK = r["WORK"].ToString(); string UNIVERSITY = r["UNIVERSITY"].ToString(); string SCHOOL = r["SCHOOL"].ToString(); string FRIENDS = r["FRIENDS"].ToString(); string ISP = r["ISP"].ToString(); string TIME_REGISTER = r["TIME_REGISTER"].ToString(); string GMAIL_USERNAME = r["GMAIL_USERNAME"].ToString(); string GMAIL_PASSWORD = r["GMAIL_PASSWORD"].ToString(); string GMAIL_RECOVERY = r["GMAIL_RECOVERY"].ToString(); string GMAIL_TIME_REGISTER = r["GMAIL_TIME_REGISTER"].ToString(); int IDPhone = -1; #endregion daSqllite kt = new daSqllite(); DataSet ttkt = new DataSet(); ttkt = kt.KiemTraMail(USERNAME); if (ttkt.Tables[0].Rows.Count > 0) { } else { #region // thêm vào csdl daSqllite them = new daSqllite(); them.Insert(UID, USERNAME, PASSWORD, SECRET, COOKIES, DAY, MONTH, YEAR, FULLNAME, GENDER, AVATAR, COVER, HOME, CITY, BIO, WORK, UNIVERSITY, SCHOOL, FRIENDS, ISP, TIME_REGISTER, GMAIL_USERNAME, GMAIL_PASSWORD, GMAIL_RECOVERY, GMAIL_TIME_REGISTER, IDPhone); #endregion } } #region // sau khi xong load lại dữ liệu hienthi(); #endregion } } }