Inserting NULL value

Question

i have a datetime column in my sql table.

i need to insert null into the table from c#page.

like :insert into TABLE (date)value('NULL' ).

i cannot insert sqldatatime.null. because it is 1/1/1900. i need NULL..

help me plese

Lisa M · Answer

From C# you can use DBNull.Value

Sreekanth · Answer

but ramesh if we crate dattetime filed to already existing table.our datatetime filed is filled with 'NULL'. i need the same result wen entering a date.My pblm is i have form with dateof birthetering filed.There is no validation for this filed. so wen saving data withou this data(DOB). i need null value. any other deafult datetime is avalid date and. in my form his birthday alert will become wrong.. thanks for u response. and i think now u got my requirement. pls help....

Ramesh · Answer

One simple solution is to chnge the type of database field value from date to string(If your requirement allows).