how to send NULL to database?

[Bllich]

hy, I have int column 'number' in my table that allowes nulls

when I instance a dataTable in my winform app. and I want to do
table.AddTableRow(string name, int number);
I need to send null value for 'number' to my table. I don't know how..
I tried with Nullable<int> and else .. didn't work.
using sql 2005 express

please help!
thanks.

 

[PS]

hy, I have int column 'number' in my table that allowes nulls

when I instance a dataTable in my winform app. and I want to do
table.AddTableRow(string name, int number);
I need to send null value for 'number' to my table. I don't know how..
I tried with Nullable<int> and else .. didn't work.
using sql 2005 express

please help!
thanks.

When they were building the place the workmen didn't want their tools
stolen. For your other question use DBNull.Value

 

[Bllich]

When they were building the place the workmen didn't want their tools
stolen. For your other question use DBNull.Value

it would be easy if it was a string type column, but this is int type
so I still get an Error - cannot convert from 'System.DBNull' to 'int'.

 

[PS]

it would be easy if it was a string type column, but this is int type
so I still get an Error - cannot convert from 'System.DBNull' to 'int'.

I don't use data table that much but the following worked for me

DataTable dt = new DataTable();
dt.Columns.Add("MYIntColumn", typeof(int));
DataRow newRow = dt.NewRow();
newRow[0] = DBNull.Value;
dt.Rows.Add(newRow);
Console.WriteLine(dt.Rows[0].IsNull(0));

PS

 

[Peter Bradley]

That's because int is a value type and not a reference type. You need to
box your int to make it an object and therefore a reference type which can
be null

http://www.csharpfriends.com/Articles/getArticle.aspx?articleID=38


Peter

 

[Bllich]

That's because int is a value type and not a reference type. You need
to box your int to make it an object and therefore a reference type
which can be null

http://www.csharpfriends.com/Articles/getArticle.aspx?articleID=38


Peter

Peter, thank you very much

 

[Bllich]

I don't use data table that much but the following worked for me

DataTable dt = new DataTable();
dt.Columns.Add("MYIntColumn", typeof(int));
DataRow newRow = dt.NewRow();
newRow[0] = DBNull.Value;
dt.Rows.Add(newRow);
Console.WriteLine(dt.Rows[0].IsNull(0));

PS

thank you for your reply PS!

 

[Mark Wilden]

When they were building the place the workmen didn't want their tools
stolen. For your other question use DBNull.Value

What happened before they built the door?

///ark

 

[Philippe]

What happened before they built the door?

///ark

Door is the first thing they install.. they actually have some guy hold
it up while they build the frame,then the walls...

<ducking>

P.

 

[Nitin Sharma]

Nitin Sharma
(Guru .Net)

 

[Nitin Sharma]

You can insert Null values(0 for int) in databse for any int, suppose
int column name is Empid

U can declare @Empid as a paramaeter in Stored Procedure
Create procedure PABC
@Empid int,
@name1 varchar(255)
as
INSERT INTO ABC
(Empid,name1)
VALUES (ISNULL(@Empid,''),@name1)

OR

U can also declare parameters in stored procedure like:--

Alter procedure PABC
@Empid int = 0,
@name1 varchar(255) = null
as
INSERT INTO ABC
(Empid,name1)
VALUES (@Empid,@name1)

So here u can go .......

Nitin Sharma
(Guru .Net)

 

[Bllich]

You can insert Null values(0 for int) in databse for any int, suppose
int column name is Empid

U can declare @Empid as a paramaeter in Stored Procedure
Create procedure PABC
@Empid int,
@name1 varchar(255)
as
INSERT INTO ABC
(Empid,name1)
VALUES (ISNULL(@Empid,''),@name1)

OR

U can also declare parameters in stored procedure like:--

Alter procedure PABC
@Empid int = 0,
@name1 varchar(255) = null
as
INSERT INTO ABC
(Empid,name1)
VALUES (@Empid,@name1)

So here u can go .......

Nitin Sharma
(Guru .Net)

nice, thank you!