Non descript error filling dataset?

16 Mar 2006 7:48 PM

Rico

Hello,

This week seems like one thing after another! I am running some simple code
to fill a dataset and keep getting the error "An unhandled exception of type
'System.Data.OleDb.OleDbException' occurred in system.data.dll" with no
additional information about the error. The code is as follows;

daSerialDetails = mdi.dt.GenericDA("SELECT * FROM
VendorOrderDetailSerialNumbers WHERE OrderItemID=" & OrderID & " AND
SerialNumber is null")
daSerialDetails.Fill(dsInventoryTypeOrders.Tables("SerialDetails"))

the GenericDA code is as it states "Generic" and is used throughout the
program, I've never had trouble with it. The dsInventoryTypeOrders dataset
schema is filled from the same VendorOrderDetailSerialNumbers table earlier
in the form code (scope is at the form level for both DS and DA), but this
is the first place it gets filled.

Any ideas?

Rick

16 Mar 2006 8:09 PM

Marina Levit [MVP]

The debugger sometimes gives that message while you are debugging.

Put a try/catch around that code, and have it display the message.

This may be a problem with the SQL query (like a typo) or a connection
problem. Can't say until we see the real error message.

"Rico" <r c o l l e n s @ h e m m i n g w a y . c o mREMOVE THIS PART IN
CAPS> wrote in message news:RhjSf.148864$sa3.106337@pd7tw1no...
Show quote

> Hello,
>
> This week seems like one thing after another! I am running some simple
> code to fill a dataset and keep getting the error "An unhandled exception
> of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll"
> with no additional information about the error. The code is as follows;
>
> daSerialDetails = mdi.dt.GenericDA("SELECT * FROM
> VendorOrderDetailSerialNumbers WHERE OrderItemID=" & OrderID & " AND
> SerialNumber is null")
> daSerialDetails.Fill(dsInventoryTypeOrders.Tables("SerialDetails"))
>
> the GenericDA code is as it states "Generic" and is used throughout the
> program, I've never had trouble with it. The dsInventoryTypeOrders
> dataset schema is filled from the same VendorOrderDetailSerialNumbers
> table earlier in the form code (scope is at the form level for both DS and
> DA), but this is the first place it gets filled.
>
> Any ideas?
>
> Rick
>
>