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

Question

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.

Arion · Accepted Answer · 2017-05-22 07:01:03Z

4

You can do this:

cmd.Parameters.AddWithValue("@RedirectUris", 
        string.IsNullOrEmpty(RedirectUris.Text) 
        ? (object)DBNull.Value : 
        RedirectUris.Text);

Might make sense to check if the value of the textbox is null or empty

answered May 22, 2017 at 7:01

Arion

31.3k10 gold badges74 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Anki Over a year ago

It is better because here we do'nt need to create new SqlParameter.

huse.ckr · Accepted Answer · 2017-05-22 07:01:41Z

3

cmd.Parameters.Add(new SqlParameter("@RedirectUris", string.IsNullOrEmpty(RedirectUris.Text) ? (object)DBNull.Value : RedirectUris.Text));

answered May 22, 2017 at 7:01

huse.ckr

53012 silver badges39 bronze badges

Comments

dev-siberia · Accepted Answer · 2019-05-18 15:50:33Z

1

You can use the short format:

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

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

answered May 18, 2019 at 15:50

dev-siberia

2,8742 gold badges23 silver badges17 bronze badges

Collectives™ on Stack Overflow

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

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related