Hi,

I am trying to use the ExecuteReader() method of the OleDbCommand class to read the schema of a given table. The following works, but results in columns that I don't need:

cmd.CommandText = String.Format("SELECT * FROM [TableName]");

When I change it to the following:

cmd.CommandText = String.Format("SELECT ColumnName, ColumnOrdinal, ColumnSize, DataType FROM [TableName]"

I get an error indicating "No value given for one or more required parameters."

What parameters are required for a SELECT command and how do you write them?

Thanks,
Royce