NULL values in dataset

[GotDotNet?]

I have a dataset and I have to loop through it and some of the values for an
insertition into the db. Some of the fields are integers and booleans but
contain a NULL in the field.

how can I check for a NULL and if its NULL insert DBNull into the db?
Currently I'm getting error message
System.DBNull.S ystem.IConverti ble.ToBoolean()
now i need to get this field and insert a NULL into the db is the values
from the dataset are NULL

[Nicholas Paldino [.NET/C# MVP]]

If the field is a database null, then pass DBNull.Value for the value.
You should also be able to compare against this value.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"GotDotNet? " <cs*********@op tonline.netwrot e in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..

>I have a dataset and I have to loop through it and some of the values for
an insertition into the db. Some of the fields are integers and booleans
but contain a NULL in the field.

how can I check for a NULL and if its NULL insert DBNull into the db?
Currently I'm getting error message
System.DBNull.S ystem.IConverti ble.ToBoolean()
now i need to get this field and insert a NULL into the db is the values
from the dataset are NULL

[GotDotNet?]

whats the syntax in C# do that? its the C# piece giving me the issue.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c omwrote in
message news:O8******** ******@TK2MSFTN GP02.phx.gbl...

If the field is a database null, then pass DBNull.Value for the value.
You should also be able to compare against this value.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"GotDotNet? " <cs*********@op tonline.netwrot e in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..

>>I have a dataset and I have to loop through it and some of the values for
an insertition into the db. Some of the fields are integers and booleans
but contain a NULL in the field.

how can I check for a NULL and if its NULL insert DBNull into the db?
Currently I'm getting error message
System.DBNull. System.IConvert ible.ToBoolean( )
now i need to get this field and insert a NULL into the db is the values
from the dataset are NULL

[Nicholas Paldino [.NET/C# MVP]]

Can you show the code you are using?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"GotDotNet? " <cs*********@op tonline.netwrot e in message
news:u7******** ******@TK2MSFTN GP03.phx.gbl...

whats the syntax in C# do that? its the C# piece giving me the issue.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c omwrote
in message news:O8******** ******@TK2MSFTN GP02.phx.gbl...

> If the field is a database null, then pass DBNull.Value for the value.
You should also be able to compare against this value.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"GotDotNet? " <cs*********@op tonline.netwrot e in message
news:%2******* *********@TK2MS FTNGP04.phx.gbl ...

>>>I have a dataset and I have to loop through it and some of the values for
an insertition into the db. Some of the fields are integers and booleans
but contain a NULL in the field.

how can I check for a NULL and if its NULL insert DBNull into the db?
Currently I'm getting error message
System.DBNull .System.IConver tible.ToBoolean ()
now i need to get this field and insert a NULL into the db is the values
from the dataset are NULL

[GotDotNet?]

i tried this

if(dr["id"].toString != null)
{
id = Convert.ToInt32 (dr["id"];
}
else
{
id = System.DBNull;
}

now ID needs to be an int as its an int in the db table I need to insert it
into.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c omwrote in
message news:u6******** ******@TK2MSFTN GP05.phx.gbl...

Can you show the code you are using?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"GotDotNet? " <cs*********@op tonline.netwrot e in message
news:u7******** ******@TK2MSFTN GP03.phx.gbl...

>whats the syntax in C# do that? its the C# piece giving me the issue.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c omwrote
in message news:O8******** ******@TK2MSFTN GP02.phx.gbl...

>> If the field is a database null, then pass DBNull.Value for the
value. You should also be able to compare against this value.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"GotDotNet? " <cs*********@op tonline.netwrot e in message
news:%2****** **********@TK2M SFTNGP04.phx.gb l...
I have a dataset and I have to loop through it and some of the values
for an insertition into the db. Some of the fields are integers and
booleans but contain a NULL in the field.

how can I check for a NULL and if its NULL insert DBNull into the db?
Currently I'm getting error message
System.DBNul l.System.IConve rtible.ToBoolea n()
now i need to get this field and insert a NULL into the db is the
values from the dataset are NULL

[Nicholas Paldino [.NET/C# MVP]]

Well, you can't change a DBNull.Value to an int. The DataSet will take
it, because it performs conversions internally when the value is set.

Your best bet would be to do use a Nullable<int(or use the C#
shorthand, int?) like so:

// Declare the nullable int.
int? id = null;

// If there is an id, then convert it.
if (dr["id"] != DBNull.Value)
{
// Convert the number.
id = (int) dr["id"];
}

Something tells me that the underlying column is an integer, if so, you
can just unbox the value returned to you, instead of calling Convert.

Also, you don't need to call ToString, because if the value is null, the
value returned to you will be DBNull.Value.

Now, if you go this route, all of your code will have to check against
null, and anyplace you pass this value, you will have to make sure the
parameter is of type int?. The reason for this is that an implicit
conversion will take place if you pass it in place of an int (not a nullable
int) and it will pass 0, which I don't think you want.

The better solution here would be to just access the value from the row
when you need it and always check for DBNull.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"GotDotNet? " <cs*********@op tonline.netwrot e in message
news:Oe******** ******@TK2MSFTN GP06.phx.gbl...

>i tried this

if(dr["id"].toString != null)
{
id = Convert.ToInt32 (dr["id"];
}
else
{
id = System.DBNull;
}

now ID needs to be an int as its an int in the db table I need to insert
it into.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c omwrote
in message news:u6******** ******@TK2MSFTN GP05.phx.gbl...

> Can you show the code you are using?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"GotDotNet? " <cs*********@op tonline.netwrot e in message
news:u7******* *******@TK2MSFT NGP03.phx.gbl.. .

>>whats the syntax in C# do that? its the C# piece giving me the issue.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c omwrote
in message news:O8******** ******@TK2MSFTN GP02.phx.gbl...
If the field is a database null, then pass DBNull.Value for the
value. You should also be able to compare against this value.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"GotDotNet ?" <cs*********@op tonline.netwrot e in message
news:%2***** ***********@TK2 MSFTNGP04.phx.g bl...
>I have a dataset and I have to loop through it and some of the values
>for an insertition into the db. Some of the fields are integers and
>booleans but contain a NULL in the field.
>
how can I check for a NULL and if its NULL insert DBNull into the db?
Currently I'm getting error message
System.DBNu ll.System.IConv ertible.ToBoole an()
>
>
now i need to get this field and insert a NULL into the db is the
values from the dataset are NULL
>

[GotDotNet?]

if there is a value I'm fine its when the field is blank thats killing me.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c omwrote in
message news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..

Well, you can't change a DBNull.Value to an int. The DataSet will take
it, because it performs conversions internally when the value is set.

Your best bet would be to do use a Nullable<int(or use the C#
shorthand, int?) like so:

// Declare the nullable int.
int? id = null;

// If there is an id, then convert it.
if (dr["id"] != DBNull.Value)
{
// Convert the number.
id = (int) dr["id"];
}

Something tells me that the underlying column is an integer, if so, you
can just unbox the value returned to you, instead of calling Convert.

Also, you don't need to call ToString, because if the value is null,
the value returned to you will be DBNull.Value.

Now, if you go this route, all of your code will have to check against
null, and anyplace you pass this value, you will have to make sure the
parameter is of type int?. The reason for this is that an implicit
conversion will take place if you pass it in place of an int (not a
nullable int) and it will pass 0, which I don't think you want.

The better solution here would be to just access the value from the row
when you need it and always check for DBNull.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"GotDotNet? " <cs*********@op tonline.netwrot e in message
news:Oe******** ******@TK2MSFTN GP06.phx.gbl...

>>i tried this

if(dr["id"].toString != null)
{
id = Convert.ToInt32 (dr["id"];
}
else
{
id = System.DBNull;
}

now ID needs to be an int as its an int in the db table I need to insert
it into.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c omwrote
in message news:u6******** ******@TK2MSFTN GP05.phx.gbl...

>> Can you show the code you are using?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"GotDotNet? " <cs*********@op tonline.netwrot e in message
news:u7****** ********@TK2MSF TNGP03.phx.gbl. ..
whats the syntax in C# do that? its the C# piece giving me the issue.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om>
wrote in message news:O8******** ******@TK2MSFTN GP02.phx.gbl...
If the field is a database null, then pass DBNull.Value for the
value. You should also be able to compare against this value.
>
Hope this helps.
>
>
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m
>
"GotDotNet? " <cs*********@op tonline.netwrot e in message
news:%2**** ************@TK 2MSFTNGP04.phx. gbl...
>>I have a dataset and I have to loop through it and some of the values
>>for an insertition into the db. Some of the fields are integers and
>>boolean s but contain a NULL in the field.
>>
>how can I check for a NULL and if its NULL insert DBNull into the db?
>Currentl y I'm getting error message
>System.DBN ull.System.ICon vertible.ToBool ean()
>>
>>
>now i need to get this field and insert a NULL into the db is the
>values from the dataset are NULL
>>
>
>

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

"GotDotNet? " <cs*********@op tonline.netwrot e in message
news:Oc******** ******@TK2MSFTN GP02.phx.gbl...

if there is a value I'm fine its when the field is blank thats killing me.

Then just check for null values before operating in the field

[frostbb]

Null or Blank can be a real nuisance. Net 2.0 / VS2005 implements the handy

if (String.IsNullO rEmpty(sSomeStr ingValue)) that allows you to test
sSomeStringValu e for Null or Blank. In Net 1.0 and Net 1.1 we basically
'rolled our own' version by creating a generic CheckForBlankOr Null(object)
class that returned null if 'object' was blank or null.

Best of luck

Barry
in Oregon

"GotDotNet? " <cs*********@op tonline.netwrot e in message
news:Oc******** ******@TK2MSFTN GP02.phx.gbl...

if there is a value I'm fine its when the field is blank thats killing me.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c omwrote
in message news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..

> Well, you can't change a DBNull.Value to an int. The DataSet will
take it, because it performs conversions internally when the value is
set.

Your best bet would be to do use a Nullable<int(or use the C#
shorthand, int?) like so:

// Declare the nullable int.
int? id = null;

// If there is an id, then convert it.
if (dr["id"] != DBNull.Value)
{
// Convert the number.
id = (int) dr["id"];
}

Something tells me that the underlying column is an integer, if so,
you can just unbox the value returned to you, instead of calling Convert.

Also, you don't need to call ToString, because if the value is null,
the value returned to you will be DBNull.Value.

Now, if you go this route, all of your code will have to check against
null, and anyplace you pass this value, you will have to make sure the
parameter is of type int?. The reason for this is that an implicit
conversion will take place if you pass it in place of an int (not a
nullable int) and it will pass 0, which I don't think you want.

The better solution here would be to just access the value from the
row when you need it and always check for DBNull.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"GotDotNet? " <cs*********@op tonline.netwrot e in message
news:Oe******* *******@TK2MSFT NGP06.phx.gbl.. .

>>>i tried this

if(dr["id"].toString != null)
{
id = Convert.ToInt32 (dr["id"];
}
else
{
id = System.DBNull;
}

now ID needs to be an int as its an int in the db table I need to insert
it into.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c omwrote
in message news:u6******** ******@TK2MSFTN GP05.phx.gbl...
Can you show the code you are using?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"GotDotNet ?" <cs*********@op tonline.netwrot e in message
news:u7***** *********@TK2MS FTNGP03.phx.gbl ...
whats the syntax in C# do that? its the C# piece giving me the issue.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om>
wrote in message news:O8******** ******@TK2MSFTN GP02.phx.gbl...
> If the field is a database null, then pass DBNull.Value for the
>value. You should also be able to compare against this value.
>>
> Hope this helps.
>>
>>
>--
> - Nicholas Paldino [.NET/C# MVP]
> - mv*@spam.guard. caspershouse.co m
>>
>"GotDotNet ?" <cs*********@op tonline.netwrot e in message
>news:%2*** *************@T K2MSFTNGP04.phx .gbl...
>>>I have a dataset and I have to loop through it and some of the values
>>>for an insertition into the db. Some of the fields are integers and
>>>boolea ns but contain a NULL in the field.
>>>
>>how can I check for a NULL and if its NULL insert DBNull into the
>>db? Currently I'm getting error message
>>System.DB Null.System.ICo nvertible.ToBoo lean()
>>>
>>>
>>now i need to get this field and insert a NULL into the db is the
>>values from the dataset are NULL
>>>
>>
>>
>
>

[GotDotNet?]

this is a nightmare right now

"frostbb" <ba***********@ remove-this-spam-filter.state.or .uswrote in
message news:eH******** ******@TK2MSFTN GP02.phx.gbl...

Null or Blank can be a real nuisance. Net 2.0 / VS2005 implements the
handy

if (String.IsNullO rEmpty(sSomeStr ingValue)) that allows you to test
sSomeStringValu e for Null or Blank. In Net 1.0 and Net 1.1 we basically
'rolled our own' version by creating a generic CheckForBlankOr Null(object)
class that returned null if 'object' was blank or null.

Best of luck

Barry
in Oregon

"GotDotNet? " <cs*********@op tonline.netwrot e in message
news:Oc******** ******@TK2MSFTN GP02.phx.gbl...

>if there is a value I'm fine its when the field is blank thats killing
me.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c omwrote
in message news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..

>> Well, you can't change a DBNull.Value to an int. The DataSet will
take it, because it performs conversions internally when the value is
set.

Your best bet would be to do use a Nullable<int(or use the C#
shorthand, int?) like so:

// Declare the nullable int.
int? id = null;

// If there is an id, then convert it.
if (dr["id"] != DBNull.Value)
{
// Convert the number.
id = (int) dr["id"];
}

Something tells me that the underlying column is an integer, if so,
you can just unbox the value returned to you, instead of calling
Convert.

Also, you don't need to call ToString, because if the value is null,
the value returned to you will be DBNull.Value.

Now, if you go this route, all of your code will have to check
against null, and anyplace you pass this value, you will have to make
sure the parameter is of type int?. The reason for this is that an
implicit conversion will take place if you pass it in place of an int
(not a nullable int) and it will pass 0, which I don't think you want.

The better solution here would be to just access the value from the
row when you need it and always check for DBNull.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"GotDotNet? " <cs*********@op tonline.netwrot e in message
news:Oe****** ********@TK2MSF TNGP06.phx.gbl. ..
i tried this

if(dr["id"].toString != null)
{
id = Convert.ToInt32 (dr["id"];
}
else
{
id = System.DBNull;
}

now ID needs to be an int as its an int in the db table I need to
insert it into.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om>
wrote in message news:u6******** ******@TK2MSFTN GP05.phx.gbl...
Can you show the code you are using?
>
>
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m
>
"GotDotNet? " <cs*********@op tonline.netwrot e in message
news:u7**** **********@TK2M SFTNGP03.phx.gb l...
>whats the syntax in C# do that? its the C# piece giving me the issue.
>"Nichola s Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om>
>wrote in message news:O8******** ******@TK2MSFTN GP02.phx.gbl...
>> If the field is a database null, then pass DBNull.Value for the
>>value. You should also be able to compare against this value.
>>>
>> Hope this helps.
>>>
>>>
>>--
>> - Nicholas Paldino [.NET/C# MVP]
>> - mv*@spam.guard. caspershouse.co m
>>>
>>"GotDotNe t?" <cs*********@op tonline.netwrot e in message
>>news:%2** **************@ TK2MSFTNGP04.ph x.gbl...
>>>>I have a dataset and I have to loop through it and some of the
>>>>value s for an insertition into the db. Some of the fields are
>>>>integer s and booleans but contain a NULL in the field.
>>>>
>>>how can I check for a NULL and if its NULL insert DBNull into the
>>>db? Currently I'm getting error message
>>>System.D BNull.System.IC onvertible.ToBo olean()
>>>>
>>>>
>>>now i need to get this field and insert a NULL into the db is the
>>>values from the dataset are NULL
>>>>
>>>
>>>
>>
>>
>
>