I'm doing parameter substitution into an sql statement which is being used to change the SelectCommand in a SqlDataSource being used to load a GridView. The connection is an OleDb connection.
The exception reads... {"Conversion failed for command parameter[0] '' because the data value overflowed the type used by the provider.
"}
...and the Inner exception reads... CWBZZ5012 Data overflow - the parameter data is too large to fit into the host field
...the SQL statement is...
SqlDataSource1.SelectCommand ="select order, recalled, edte, acct, sub, name, add1, add2, add3, code from lib.tablename t1 where code in ? and edte
>= ? and edte <= ? order by t1.order desc"
...and the parameter substitutions are...
SqlDataSource1.SelectParameters.Add(Go to the complete details ...