public DataTable ReadFromExcels(string namefile) { try { QRcode qrcode = new QRcode(); string fileLocation = txtDuongDanFile.Text; string name = Path.GetFileName(txtDuongDanFile.Text); DataTable sheet = new DataTable(); OleDbConnectionStringBuilder csbuilder = new OleDbConnectionStringBuilder(); csbuilder.Provider = "Microsoft.ACE.OLEDB.12.0"; csbuilder.DataSource = fileLocation.Substring(0, fileLocation.LastIndexOf('\\')); csbuilder.Add("Extended Properties", "Text;Excel 12.0;HDR=No;IMEX=1;FMT=Delimited"); string selectSql = @"SELECT * FROM [" + name + "]"; using (OleDbConnection connection = new OleDbConnection(csbuilder.ConnectionString)) using (OleDbDataAdapter adapter = new OleDbDataAdapter(selectSql, connection)) { connection.Open(); adapter.Fill(sheet); connection.Close(); } DataSet ds = TableVeSo(); Decimal No = 1; foreach (DataRow row in sheet.Rows) { LotteryPattern lotteryPattern = new LotteryPattern(); lotteryPattern.NO = No.ToString(); if (row[0] != null) { lotteryPattern.LoaiVe = row[0].ToString(); } if (row[1] != null) { lotteryPattern.KyVe = row[1].ToString(); } if (row[2] != null) { lotteryPattern.NgaySo = Convert.ToDateTime(row[2].ToString()); } if (row[3] != null) { lotteryPattern.So = row[3].ToString(); } if (row[4] != null) { lotteryPattern.SoMaHoa = row[4].ToString(); } byte[] qrcodebyte = qrcode.ConertArrayByte(qrcode.GenerateQRCode(lotteryPattern.SoMaHoa, 70, 70)); byte[] qrcodebytebottom = qrcode.ConertArrayByte(qrcode.GenerateQRCode(lotteryPattern.SoMaHoa, 40, 40)); ds.Tables[0].Rows.Add(lotteryPattern.NO, lotteryPattern.NgaySo, lotteryPattern.So, lotteryPattern.SoMaHoa, lotteryPattern.KyVe, qrcodebyte, qrcodebytebottom, qrcodebyte, lotteryPattern.LoaiVe); No++; } return(ds.Tables[0]); } catch (Exception e) { Console.WriteLine(e.Message); return(null); } }
public List <LotteryPattern> ReadFile(string csv) { var reader = new StreamReader(File.OpenRead("@" + csv)); List <LotteryPattern> listA = new List <LotteryPattern>(); while (!reader.EndOfStream) { var line = reader.ReadLine(); var values = line.Split(','); ////////Doc tung dong`//////////// LotteryPattern obj = new LotteryPattern(); if (values.Count() > 0) { obj.KyTu = values[0].ToString(); obj.NgayXo = Convert.ToDateTime(values[1].ToString()); obj.So = Convert.ToInt16(values[2].ToString()); } listA.Add(obj); } return(listA); }