Hi all,

I have an Oracle table with column of datatype NUMBER(10). When I add a tabledapter in dataset designer, it creates a table with a column of datatype: system.decimal

I change it to system.int32, but when I use an insert query, the parameter is of decimal format. I changed the type in designer.vb (although it is not recommended) and it worked fine. but after time, it revoked back to decimal.

Am I missing something, or it is just another oracle, .NET misunderstanding?
 

I would appreciate any feedback,

Thanks, 

I found the solution. When creating the Insert query, it doesn't define the parameter type. After the query is saved in the designer, parameters list is created on the fly (I guess it retries their type from the database). I changed the parameter datatype from the query properties>parameters (collection).