var reader = cmd.ExecuteReader();
var columns = new List<string>();
for(int i=0;i<reader.FieldCount;i++)
{
columns.Add(reader.GetName(i));
}
or
var columns = Enumerable.Range(0, reader.FieldCount).Select(reader.GetName).ToList();
More Related Contents:
- Invalid attempt to read when no data is present
- What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
- Call a stored procedure with parameter in c#
- Insert 2 million rows into SQL Server quickly
- Calling stored procedure with return value
- Get output parameter value in ADO.NET
- OleDbCommand parameters order and priority
- When should “SqlDbType” and “size” be used when adding SqlCommand Parameters?
- SQL command INSERT is working but the data not appear in table
- Return value from SQL Server Insert command using c#
- Under what circumstances is an SqlConnection automatically enlisted in an ambient TransactionScope Transaction?
- How to pass sqlparameter to IN()? [duplicate]
- Populate data table from data reader
- c# Using Parameters.AddWithValue in SqlDataAdapter
- SqlConnection SqlCommand SqlDataReader IDisposable
- SqlBulkCopy from a List
- Insert into C# with SQLCommand
- DbArithmeticExpression arguments must have a numeric common type
- Connection timeout for SQL server
- MultipleActiveResultSets=True or multiple connections?
- WHERE IN (array of IDs)
- Getting binary data using SqlDataReader
- How to fill a datatable with List [duplicate]
- How to fill Dataset with multiple tables?
- How DataReader works?
- Enabling Foreign key constraints in SQLite
- Fastest method for SQL Server inserts, updates, selects
- How to get efficient Sql Server deadlock handling in C# with ADO?
- ADO.Net Entity Framework An entity object cannot be referenced by multiple instances of IEntityChangeTracker
- Do we have transactions in MS-Access?