convert null value to 0

[Vicky]

What is the best way of converting Null value in datatable numeric column to
0.

THanks

[Stephan Ainley]

I don't know if this is the best way but here's one option
int s = Convert.ToInt32(null);

[William Ryan eMVP]

You can just set the datacolumn value to 0, for instance

DataTableName.Rows[0][ColumnIndex] = 0;
http://msdn.microsoft.com/library/de...classtopic.asp

If you mean that when you create a new row that it defaults to 0 instead of
dbnull, then you can set the DefaultValue property of the datacolumn
http://www.knowdotnet.com/articles/types.html
DataColumnName.DefaultValue = 0;

If you are talking about a dataGrid and want DbNull values to be reflected
as 0's instead of the literal null, then add a DataGridTableStyle, afterward
add a DataGridColumnStyle and set the rows DefaultValue property to 0.
http://www.knowdotnet.com/articles/kdngrid.html

Since you mention null instead of DbNull (which is what the value will come
back as) I thought this might be what you were referencing.

--
W.G. Ryan MVP Windows - Embedded

www.devbuzz.com
www.knowdotnet.com
http://www.msmvps.com/williamryan/
"Vicky" <vi***@hh.com> wrote in message
news:eG**************@TK2MSFTNGP11.phx.gbl...

What is the best way of converting Null value in datatable numeric column to 0.

THanks

[Vicky]

But i am not making datatable , but opening datatable from a database using
a stored procedure.
Now in this case how to make sure that dbnull is converted to 0 withour
doing any changes in my stored procedure or database
"William Ryan eMVP"
<do********@comcast.nospam.net> wrote in message
news:uE**************@TK2MSFTNGP09.phx.gbl...

You can just set the datacolumn value to 0, for instance

DataTableName.Rows[0][ColumnIndex] = 0;
http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemdatadatacolumnclasstopic.asp
If you mean that when you create a new row that it defaults to 0 instead of dbnull, then you can set the DefaultValue property of the datacolumn
http://www.knowdotnet.com/articles/types.html
DataColumnName.DefaultValue = 0;

If you are talking about a dataGrid and want DbNull values to be reflected
as 0's instead of the literal null, then add a DataGridTableStyle, afterward add a DataGridColumnStyle and set the rows DefaultValue property to 0.
http://www.knowdotnet.com/articles/kdngrid.html

Since you mention null instead of DbNull (which is what the value will come back as) I thought this might be what you were referencing.

--
W.G. Ryan MVP Windows - Embedded

www.devbuzz.com
www.knowdotnet.com
http://www.msmvps.com/williamryan/
"Vicky" <vi***@hh.com> wrote in message
news:eG**************@TK2MSFTNGP11.phx.gbl...

What is the best way of converting Null value in datatable numeric

column to

0.

THanks

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

Hi Vicky,

A simple solution would be iterate in the rows read checking for null and
assigning it a 0 instead.

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Vicky" <vi***@hh.com> wrote in message
news:uH**************@tk2msftngp13.phx.gbl...

But i am not making datatable , but opening datatable from a database using a stored procedure.
Now in this case how to make sure that dbnull is converted to 0 withour
doing any changes in my stored procedure or database
"William Ryan eMVP"
<do********@comcast.nospam.net> wrote in message
news:uE**************@TK2MSFTNGP09.phx.gbl...

You can just set the datacolumn value to 0, for instance

DataTableName.Rows[0][ColumnIndex] = 0;

http://msdn.microsoft.com/library/de...us/cpref/html/ frlrfsystemdatadatacolumnclasstopic.asp

If you mean that when you create a new row that it defaults to 0 instead

of

dbnull, then you can set the DefaultValue property of the datacolumn
http://www.knowdotnet.com/articles/types.html
DataColumnName.DefaultValue = 0;

If you are talking about a dataGrid and want DbNull values to be

reflected as 0's instead of the literal null, then add a DataGridTableStyle,

afterward

add a DataGridColumnStyle and set the rows DefaultValue property to 0.
http://www.knowdotnet.com/articles/kdngrid.html

Since you mention null instead of DbNull (which is what the value will

come

back as) I thought this might be what you were referencing.

--
W.G. Ryan MVP Windows - Embedded

www.devbuzz.com
www.knowdotnet.com
http://www.msmvps.com/williamryan/
"Vicky" <vi***@hh.com> wrote in message
news:eG**************@TK2MSFTNGP11.phx.gbl...

What is the best way of converting Null value in datatable numeric

column

to

0.

THanks

[Claudio]

public int ConvertToInt(object valueFromDb)
{
try
{
return valueFromDb != DBNull.Value ? (int) valueFromDb : 0;
}
catch(InvalidCastException exc)
{
return 0;
}
}
int aNumber = ConvertToInt(whateverComesFromTheDB);


"Vicky" <vi***@hh.com> schrieb im Newsbeitrag
news:uH**************@tk2msftngp13.phx.gbl...

But i am not making datatable , but opening datatable from a database using a stored procedure.
Now in this case how to make sure that dbnull is converted to 0 withour
doing any changes in my stored procedure or database
"William Ryan eMVP"
<do********@comcast.nospam.net> wrote in message
news:uE**************@TK2MSFTNGP09.phx.gbl...

You can just set the datacolumn value to 0, for instance

DataTableName.Rows[0][ColumnIndex] = 0;

http://msdn.microsoft.com/library/de...us/cpref/html/ frlrfsystemdatadatacolumnclasstopic.asp

If you mean that when you create a new row that it defaults to 0 instead

of

dbnull, then you can set the DefaultValue property of the datacolumn
http://www.knowdotnet.com/articles/types.html
DataColumnName.DefaultValue = 0;

If you are talking about a dataGrid and want DbNull values to be

reflected as 0's instead of the literal null, then add a DataGridTableStyle,

afterward

add a DataGridColumnStyle and set the rows DefaultValue property to 0.
http://www.knowdotnet.com/articles/kdngrid.html

Since you mention null instead of DbNull (which is what the value will

come

back as) I thought this might be what you were referencing.

--
W.G. Ryan MVP Windows - Embedded

www.devbuzz.com
www.knowdotnet.com
http://www.msmvps.com/williamryan/
"Vicky" <vi***@hh.com> wrote in message
news:eG**************@TK2MSFTNGP11.phx.gbl...

What is the best way of converting Null value in datatable numeric

column

to

0.

THanks