DataAdapter posts "0.0" to DB when Param contains System.DbNull

[Tom Luetz II]

I'm having some trouble with the DataAdapter in my code. When the parameter
in an OleDbCommand, which is created
as having a type of OleDbType.Decim al, is set to System.DbNull, the actual
value posted to the database upon execution of the Insert command is a
floating point value of zero (0.0, actually).

The DataAdapter is associated with a DataGrid. When a row is inserted into
the grid, the column may contain either nothing "(null)"
or a floating point value.

Here's some excerpts from the code that may help someone help me with this:

DAdapter = New OleDbDataAdapte r

'Build insert command
CommandText = "Insert into db.threshold threshd_critica l) values (?)"
DAdapter.Insert Command = New OleDbCommand(Co mmandText, mConnection)

'Define parameters for insert command
workParam = DAdapter.Insert Command.Paramet ers.Add("thresh d_critical",
OleDbType.Decim al)
workParam.Sourc eColumn = "threshd_critic al"
workParam.Sourc eVersion = DataRowVersion. Current

Any assistance would be greatly appreciated!

Tom

[Derrick [MCSD]]

Hi Tom,

Several issues can exhibit this symptom. Would you please let me know what
database you're using (I'm assuming it's Microsoft Access, since you're
using OleDb), and we can narrow down the issue. This may not be an issue
with the DataAdapter (I assume you've tested this with a straight SQL
statement in your database's UI?).

HTH,
Derrick
"Tom Luetz II" <tl****@comcast .net> wrote in message
news:qP******** ************@co mcast.com...

I'm having some trouble with the DataAdapter in my code. When the parameter in an OleDbCommand, which is created
as having a type of OleDbType.Decim al, is set to System.DbNull, the actual
value posted to the database upon execution of the Insert command is a
floating point value of zero (0.0, actually).

The DataAdapter is associated with a DataGrid. When a row is inserted into
the grid, the column may contain either nothing "(null)"
or a floating point value.

Here's some excerpts from the code that may help someone help me with this:
DAdapter = New OleDbDataAdapte r

'Build insert command
CommandText = "Insert into db.threshold threshd_critica l) values (?)"
DAdapter.Insert Command = New OleDbCommand(Co mmandText, mConnection)

'Define parameters for insert command
workParam = DAdapter.Insert Command.Paramet ers.Add("thresh d_critical",
OleDbType.Decim al)
workParam.Sourc eColumn = "threshd_critic al"
workParam.Sourc eVersion = DataRowVersion. Current

Any assistance would be greatly appreciated!

Tom

[Tom Luetz II]

The database being used is IBM UDB DB2 v7.2.

If you execute the SQL manually, the proper value is inserted into the
database.

I should have mentioned that my code worked just fine when the
InsertCommand's
parameter was defined as OleDbType.Integ er; only when it was changed to
Decimal
did I start to have the aforementioned problem.

Thanks,
Tom

"Derrick [MCSD]" <Derrick[underscore]Repep[at]toxicall[dot]com> wrote in
message news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

Hi Tom,

Several issues can exhibit this symptom. Would you please let me know what database you're using (I'm assuming it's Microsoft Access, since you're
using OleDb), and we can narrow down the issue. This may not be an issue
with the DataAdapter (I assume you've tested this with a straight SQL
statement in your database's UI?).

HTH,
Derrick
"Tom Luetz II" <tl****@comcast .net> wrote in message
news:qP******** ************@co mcast.com...

I'm having some trouble with the DataAdapter in my code. When the

parameter

in an OleDbCommand, which is created
as having a type of OleDbType.Decim al, is set to System.DbNull, the actual value posted to the database upon execution of the Insert command is a
floating point value of zero (0.0, actually).

The DataAdapter is associated with a DataGrid. When a row is inserted into the grid, the column may contain either nothing "(null)"
or a floating point value.

Here's some excerpts from the code that may help someone help me with

this:

DAdapter = New OleDbDataAdapte r

'Build insert command
CommandText = "Insert into db.threshold threshd_critica l) values (?)"
DAdapter.Insert Command = New OleDbCommand(Co mmandText, mConnection)

'Define parameters for insert command
workParam = DAdapter.Insert Command.Paramet ers.Add("thresh d_critical",
OleDbType.Decim al)
workParam.Sourc eColumn = "threshd_critic al"
workParam.Sourc eVersion = DataRowVersion. Current

Any assistance would be greatly appreciated!

Tom

[Tom Luetz II]

The database being used is IBM UDB DB2 v7.2.

If you execute the SQL manually, the proper value is inserted into the
database.

I should have mentioned that my code worked just fine when the
InsertCommand's
parameter was defined as OleDbType.Integ er; only when it was changed to
Decimal
did I start to have the aforementioned problem.

Thanks,
Tom

"Derrick [MCSD]" <Derrick[underscore]Repep[at]toxicall[dot]com> wrote in
message news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

Hi Tom,

Several issues can exhibit this symptom. Would you please let me know

what

database you're using (I'm assuming it's Microsoft Access, since you're
using OleDb), and we can narrow down the issue. This may not be an issue

with the DataAdapter (I assume you've tested this with a straight SQL
statement in your database's UI?).

HTH,
Derrick
"Tom Luetz II" <tl****@comcast .net> wrote in message
news:qP******** ************@co mcast.com...

I'm having some trouble with the DataAdapter in my code. When the

parameter

in an OleDbCommand, which is created
as having a type of OleDbType.Decim al, is set to System.DbNull, the

actual value posted to the database upon execution of the Insert command is a
floating point value of zero (0.0, actually).

The DataAdapter is associated with a DataGrid. When a row is inserted into the grid, the column may contain either nothing "(null)"
or a floating point value.

Here's some excerpts from the code that may help someone help me with

this:

DAdapter = New OleDbDataAdapte r

'Build insert command
CommandText = "Insert into db.threshold threshd_critica l) values (?)"
DAdapter.Insert Command = New OleDbCommand(Co mmandText, mConnection)

'Define parameters for insert command
workParam = DAdapter.Insert Command.Paramet ers.Add("thresh d_critical",
OleDbType.Decim al)
workParam.Sourc eColumn = "threshd_critic al"
workParam.Sourc eVersion = DataRowVersion. Current

Any assistance would be greatly appreciated!

Tom