oleType = OleDbType.BigInt
> iColumnSize = 4 '****>>>> I want to value from the dataset<<<<<****
Glen,
When you're dealing with data types like int, smallint, float, & datetime, the OleDbType already knows its size and you do not have to specify it. For char, varchar, etc. you can use GetSchemaTable to retrieve the meta data.