inserting null values in sql server 2008 using asp.net forms

Question

0.00/5 (No votes)

See more:

I have a SQL Insert statement that sends data to a SQL Server 2008 table.
The values are picked up from a form using ASP.NET

Sometimes the values will be blank or do not require an answer.
How can I insert these values as NULL into SQL server?
The asp.net form will not save unless I fill in zeros in black fields. But some of the fields in sql server 2008 are “allows null”, but when insert statement is excuted it needs zeros for black fields

Posted 19-Jul-12 10:16am

mayeso

Add a Solution

2 solutions

Solution 2

I think if you need to pass string data then use vb.net code like this Dim strValue = string.Empty and for c# string strValue = string.Empty
and you can use DB.Null also for the same
You have one more choice don't pass parameter in sql statement.
Don't pass parameter value in procedure as well, also
Assign null in procedure parameter like @strValue varchar(10)=null

if you will not pass parameter then this will work.

Thanks
Nayan Chavada

Posted 19-Jul-12 11:30am

Nayan Chavada

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Accepted Answer · 2012-07-19T10:18:00

Solution 1

DbNull.Value is how you select null to insert. Or you just use SQL that doesn't have an insert statement for those columns, then they will just stay null.

Posted 19-Jul-12 10:18am

Christian Graus

Comments

StianSandberg 19-Jul-12 16:32pm

5'd.

Member 11878307 7-Aug-15 1:14am

gdgdfdgf