public void LoadData(DataSet ds, string table) { if(_dbAdaptor != null) _dbAdaptor.Dispose(); _cells = new List<List<string>>(); _dbAdaptor = new DataBaseAdapter(_path); _dbAdaptor.OleDbDataAdapter(table).Fill(ds); for (int c = 0; c < ds.Tables[0].Columns.Count-1; c++) { _cells.Add(new List<string>()); for (int r = 0; r < ds.Tables[0].Rows.Count-1; r++) { _cells[c].Add(ds.Tables[0].Rows[r][c].ToString()); } } OnSendEvent("Excell file data has been loaded. File name : "+ Path.GetFileName(_path) + Environment.NewLine); OnSendEvent(_cells[0].Count + 1 + " Rows," + (_cells.Count + 1) + " Columns." + Environment.NewLine); }
public void LoadData(DataSet ds, string table) { if (_dbAdaptor != null) { _dbAdaptor.Dispose(); } _cells = new List <List <string> >(); _dbAdaptor = new DataBaseAdapter(_path); _dbAdaptor.OleDbDataAdapter(table).Fill(ds); for (int c = 0; c < ds.Tables[0].Columns.Count - 1; c++) { _cells.Add(new List <string>()); for (int r = 0; r < ds.Tables[0].Rows.Count - 1; r++) { _cells[c].Add(ds.Tables[0].Rows[r][c].ToString()); } } OnSendEvent("Excell file data has been loaded. File name : " + Path.GetFileName(_path) + Environment.NewLine); OnSendEvent(_cells[0].Count + 1 + " Rows," + (_cells.Count + 1) + " Columns." + Environment.NewLine); }