how to pass null value to database from cmd.Parameters.AddWithValue in asp.net

user_7894852 0
Viewed 3016

I want to save NULL in database for column while textbox is empty. Here is my code,

cmd.Parameters.AddWithValue("@RedirectUris", ((RedirectUris.Text == "") ? DBNull.Value.ToString() : RedirectUris.Text));

where RedirectUris is textbox id.
In this scenario database is saving empty value not as NULL. Please help me to do this.

asp.net sql c#
3 Answers

You can use the short format:

// update
cmd.Parameters.AddWithValue("@ResponseTimeDays", responseTimeDays ?? Convert.DBNull);

// insert
new SqlParameter("@ResponseTimeDays", cinfo.ResponseTimeDays ?? Convert.DBNull)
user_37521720
Related