Hi,
I have problem inserting null value through SQLCommand in VB.NET to SQL
Server.

dim cm as new sqlcommand
cm.commandtext = "insert into table1 (field1, field2, ....) values(var1,
var2,....)"

How to assign var2 <== NULL Value, so in SQL Server will appear as null
value ?

thanks,

Sam <(E-Mail Removed)> wrote:
> I have problem inserting null value through SQLCommand in VB.NET to SQL
> Server.
>
> dim cm as new sqlcommand
> cm.commandtext = "insert into table1 (field1, field2, ....) values(var1,
> var2,....)"
>
> How to assign var2 <== NULL Value, so in SQL Server will appear as null
> value ?

Use parameters and set the value to DBNull.Value.

See http://www.pobox.com/~skeet/csharp/faq/#db.parameters for more
information.

--
Jon Skeet - <(E-Mail Removed)>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

Sam wrote:

> Hi,
> I have problem inserting null value through SQLCommand in VB.NET to SQL
> Server.
>
> dim cm as new sqlcommand
> cm.commandtext = "insert into table1 (field1, field2, ....) values(var1,
> var2,....)"
>
> How to assign var2 <== NULL Value, so in SQL Server will appear as null
> value ?

Simply do not specify the field:
cm.commandtext = "insert into table1 (field1, field3, ....) values(var1,
var3,....)"

Or, as Jon said, use parameters and set the value to DBNull.Value or to
Nothing (VB.NET) or null (C#)

FB

--
Get LLBLGen Pro, the new O/R mapper for .NET: http://www.llblgen.com
My .NET Blog: http://weblogs.asp.net/fbouma
Microsoft C# MVP

Thanks a lot, it works !

"Sam" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
> I have problem inserting null value through SQLCommand in VB.NET to SQL
> Server.
>
> dim cm as new sqlcommand
> cm.commandtext = "insert into table1 (field1, field2, ....) values(var1,
> var2,....)"
>
> How to assign var2 <== NULL Value, so in SQL Server will appear as null
> value ?
>
> thanks,
>
>

Is there any way i can assign a null value to a Feild in a dataset where the
allow nulls property of that feild is set to false


Manu

hmmm .... your question seems to be a bit curious ...
if you have to enter a null value in a field, which does not allow to be
null ... you have to think about your design ....

Regards,
P@rick

PS: I think (hope) there is no way to do this action ... but I'm not sure
....


"Manu" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Is there any way i can assign a null value to a Feild in a dataset where
the
> allow nulls property of that feild is set to false
>
>
> Manu
>
>