General How to get Connection.GetSchema("columns",restrictions) in order by ordinal position

[ashish bhakhar]

how to get columns of table in order of their ordinal position instead of alphabetical order of column name? cn.GetSchema("Columns", restrictions) output: column_name ordinal_position ...........ambit...............3 ...........noise...............1 ...........z...................2 required output: column_name ordinal_position ....................noise...............1 ....................z...................2 ....................ambit...............3 IS IT POSSIBLE?

[eyeseetee]

hmm try sort by ordinal_position in the query unless I have mistaken your post