I need to count the number of columns in a Table in an Access Database.
The following code does the job, but I wonder if there is a better way using INFORMATION_SCHEMA.COLUMNS ?
CmdStr = $"SELECT TOP 1 * FROM [RoundData]";
ReadCmd = new OleDbCommand( CmdStr, ResultsReportingOleDbConnection );
Reader = ReadCmd.ExecuteReader();
int NbrColumns = Reader.FieldCount;