private void button7_Click(object sender, EventArgs e) { OpenFileDialog fb = new OpenFileDialog(); fb.Filter = "Excel Office | *.xls; *.xlsx"; if (fb.ShowDialog() == DialogResult.OK) { FileStream strem = new FileStream(fb.FileName, FileMode.Open, FileAccess.Read); IExcelDataReader exReader = ExcelReaderFactory.CreateReader(strem); DataSet ds = exReader.AsDataSet(new ExcelDataSetConfiguration() { ConfigureDataTable = (_) => new ExcelDataTableConfiguration() { UseHeaderRow = true } }); List <Tasks> tk = new List <Tasks>(); Tasks t; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { t = new Tasks(); for (int j = 0; j < ds.Tables[0].Columns.Count; j++) { //if (j == 0) // t.Task_ID = Convert.ToInt32(ds.Tables[0].Rows[i][j].ToString()); if (j == 0) { t.Tittle = ds.Tables[0].Rows[i][j].ToString(); } //else if (j == 2) // t.Date = ds.Tables[0].Rows[i][j].ToString(); else if (j == 1) { t.Time = ds.Tables[0].Rows[i][j].ToString(); } //else if (j == 4) // t.RepeatDateTask_ID = ds.Tables[0].Rows[i][j].ToString(); else if (j == 2) { t.Description = ds.Tables[0].Rows[i][j].ToString(); } else if (j == 3) { t.Priority = Convert.ToInt32(ds.Tables[0].Rows[i][j].ToString()); } //else if (j == 7) // t.Category_ID = cat_ID; //else // t.Task_Complete = Convert.ToInt32(ds.Tables[0].Rows[i][j].ToString()); } t.RepeatDateTask_ID = System.Guid.NewGuid().ToString(); t.Category_ID = cat_ID; tk.Add(t); } exReader.Dispose(); strem.Dispose(); ds.Dispose(); TaskSer tkSer = new TaskSer(); for (int i = 0; i < tk.Count; i++) { tkSer.InsertFormImportFile(tk[i]); } MessageBox.Show("File Is Imported"); LoadTaskList(); } }