how to place a dbnull value

Question

hello all how to place DBNull value into a datetime field using c# code . the field is already have a value .and I want to change it to DBNULL tq denny

paul daniel · Answer

Refer this link http://www.c-sharpcorner.com/UploadFile/sd_patel/EnterNullValuesForDateTime11222005015742AM/EnterNullValuesForDateTime.aspx

Hirendra Sisodiya · Answer

hello Denny if you are using sql database then simply you can use this Query: update temp_table set Date_field =NULL where Date_field is not Null thank you please chk answere if you like

Amit Choudhary · Answer

hi friend Simply use following query syntax: cmd.CommandText= update table1 set DateAdded= + DBNULL +  where DateAdded= +DateTime.Now; Please mark as answer if it helps you.