insert blank values to database

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

How can i insert blank value or null value in database..
its suitable to all datatypes like int, char ,and ,date, decimal ..

if i give null mean it not accept by integer
i give textbox.text="" it also not accepted wat the solution

Posted 5-Jul-11 20:40pm

suryaswathi

Add a Solution

2 solutions

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)

2irfanshaikh · Answer 1 · 2011-07-05T20:43:00

Solution 1

use

int? i = null;

or

Nullable<int> i = null;</int>

variable declaration.

Posted 5-Jul-11 20:43pm

2irfanshaikh

Comments

suryaswathi 6-Jul-11 2:47am

its give eroor null is non nullable value

[no name] 6-Jul-11 2:50am

please provide the line of code....

suryaswathi 6-Jul-11 3:04am

hello sir

colname data type Null

name varchar NotNull
id int Null
dob datetime notm null

my table mixed up with null and not null..but i want to insert null or blank value to all records in the fields..this is my query

[no name] 6-Jul-11 3:14am

In database if the column is Allow NULL then only you can insert NULL value into it. And for string datatype like varchar, text, we can set black string. but in integer we cannot insert blank value. if it is allow null then insert NULL value else insert 0.

Try this

Insert into table values ('name', NULL, '12/FEB/2011');
NAME ID DOB

_Maxxx_ · Answer 2 · 2011-07-05T20:47:00

Solution 2

I'm not clear on what you are asking.

to insert a null value

insert into table
(column1, column2, column3)
values
(23, null,'Hello world')

Your textbox.text = implies you are using some programming language which has retrieved the data and are trying to display it, but have an issue if the data returned is null.

without knowing what programming language, any help needs to be generic - but you need to do something like

If row("column2") is DbNull.Value Then
  TextBox1.Text = String.empty
Else
  TextBox1.Text - row("Column2")
End If

Posted 5-Jul-11 20:47pm

_Maxxx_

Comments

suryaswathi 6-Jul-11 3:10am

hello sir

colname data type Null

name varchar NotNull
id int Null
dob datetime notm null

my table mixed up with null and not null..but i want to insert null or blank value to all records in the fields..this is my query

_Maxxx_ 6-Jul-11 7:56am

If you can't change the columns to acccept Null and you want to have a value that represents a null value, you have little choice but to use a 'magic' value for each field type that represents a Null value, then check for that in your code - so for int columns use -1, for exampel, for strings use an empty string (or "NULL") for dates use the minimum date value - more work in translating the magic values in your code - but nothing else you can do if you can't change the column properties