CODEWITHSUNDEEP
c#sql.net
Transcendent
Transcendent

Reputation: 5755

Built in method to return SQL column count

I'm curious is there any built in method that can count the number of columns in an sql query based on the DataReader result. (I'm not talking about "SELECT COUNT(*) FROM X")

For example this can be carried out in Java by using the ResultSetMetaData class that has a .getColumnCount() method. This is useful when formatting and putting the results of a query in a list without actually knowing how many columns there are.

I'd like know if such method exists in C# as well.

Upvotes: 1

Views: 84

Answers (1)

clansaur
clansaur

Reputation: 751

You can find it on the SchemaTable for the data reader:

dataReader.GetSchemaTable().Columns.Count

Upvotes: 2

Related Questions