Error in filiing DataSet

Aamir Khan

Hi Frnds,

I am trying to fill a DataSet using an ADODB.recordset:

OleDbDataAdapter oleda = null;

DataSet dsEncrypt = new DataSet();

oleda = new OleDbDataAdapter("Select * from " + ListTable[i] +"",oleConn);

oleda.Fill(dsEncrypt);

getting error while filling --->oleda.Fill(dsEncrypt);

This works fine in most part but on other occasions I get the error
below:

"The provider could not determine the Object value. For example, the
row was just created, the default for the Object column was not
available, and the consumer had not yet set a new Object value."

What does this error mean and are there any ways around it?

Help is appreciated,
Aamir

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dorababu Meka14y ago
What I am asking is you said in some case it is working fine and in some cases you are getting error what's that case
0
Aamir Khan14y ago
get the error here---->oleda.Fill(dsEncrypt);
then it goes into exception and the following error shows

"The provider could not determine the Object value. For example, the
row was just created, the default for the Object column was not
available, and the consumer had not yet set a new Object value."
0
Dorababu Meka14y ago
When you are getting this error exactly..
0