public void GetAllColumnsName() { List <string> numbercolumns = new List <string>(); List <string> stringcolumns = new List <string>(); List <string> allcolumns = new List <string>(); DataTable table = ModifiedData.ToTable(); for (int col = 0; col < table.Columns.Count; col++) { string cell = table.Rows[0].ItemArray.ElementAt(col).ToString(); float x = 0; allcolumns.Add(table.Columns[col].ToString()); if (float.TryParse(cell, NumberStyles.Number, CultureInfo.InvariantCulture, out x)) { numbercolumns.Add(table.Columns[col].ToString()); } else { stringcolumns.Add(table.Columns[col].ToString()); } } AllColumnList = allcolumns; NumberColumnList = numbercolumns; StringColumnList = stringcolumns; }
public List <string> GetAllClass(int nrcolumn) { DataTable table = ModifiedData.ToTable(); IList <string> classnames = new List <string>(); foreach (DataRow row in table.Rows) { classnames.Add(row.ItemArray.ElementAt(nrcolumn).ToString()); } return(classnames.Distinct().ToList()); }