public static int GetColumnNumber(this DataTableCollection tables, int tableNumber, string columnName)
{
var column = tables
.GetColumns(tableNumber)
.FirstOrDefault(x => x.Caption.ToLower() == columnName.ToLower());
if (column == null)
{
return(-1);
}
return(column.Ordinal);
}
public static IEnumerable <string> GetColumnsNames(this DataTableCollection tables, int tableNumber) => tables .GetColumns(tableNumber) .Select(x => x.Caption) .ToList();