INSERT NULL TI DATETIMR FILED

Abdu Rafeeq

I TRIED TO INSERT NULL INTO DATETIME FILED , ATTHE TIME ERROR MESSAGE IS DATE PARAMETER VALUE NOT SUPPLIED,

THIS CASE RISES WHEN MORE FILEDS IN THE TABLE,INCLUDES DATEFILED

.....
I GIVES QUERY ""INSERT INTO TMPTABLE VALUES(1,266,NULL)"

..........

NOT GOT ERROR WHEN DIRECT EXCUTE ONLY DATE FILED WITH NULL,AT THE TIME IT WILL SUCCESS,,,,
LIKE THIS "INSERT INTO TMPTABLE(BACKDATE) VALUES(NULL)"

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abdullah Munshi14y ago
Accepted answer
You need to pass the null value, try this code, cmd.Parameters.AddWithValue("@Date",System.DBNull.Value);
Abdu Rafeeq14y ago
hi sude,,ur answer is correct, but i have some problem also

whis is

my query is to pass values to database

Create procedure addvalue

@empname nvarchar(500),
@Date datetime

as begin
insert into emp(name,date)values(@empname,@Date)
end

i got error
Procedure or Function 'addvalue' expects parameter '@Date', which was not supplied.

i think this problem arise due to @datetime is null

How to solve ?
Abdu Rafeeq14y ago
hi abdulla ,,ur answer is correct, but i have some problem also

whis is

my query is to pass values to database

Create procedure addvalue

@empname nvarchar(500),
@Date datetime

as begin
insert into emp(name,date)values(@empname,@Date)
end

i got error
Procedure or Function 'addvalue' expects parameter '@Date', which was not supplied.

i think this problem arise due to @datetime is null

How to solve ?
Abdullah Munshi14y ago
Try this, INSERT INTO TMPTABLE (field1,field2,field3) VALUES(1,266,NULL) specify the field names instead of field1,field2,field3.
Abdu Rafeeq14y ago
but cannot inset null to the particular datefied
Suthish Nair14y ago
http://www.c-sharpcorner.com/Forums/Thread/157493/retrive-null-value-from-datetme-picker.aspx
Aarti14y ago
Hi,

replace this I GIVES QUERY ""INSERT INTO TMPTABLE VALUSE(1,266,NULL)"

with
"INSERT
INTO TMPTABLE VALUES(1,266,NULL)"
Jignesh Trivedi14y ago
hi,

how are u insert record in dabase using any code?
have u any variable for assign date time? if yes make it nullble.

DateTime? mydatetime;

kindly share more details on same.

hope this help.