how to insert null into sql database with ADO.Net C#

Question

i have a DropDownList that display a collection of subset based on SetID from another ddl and some times it is null. how i can insert null value into database ? i tried with this code but not work:

CmdUpdate.Parameters.Add("@SubsetID",SqlDbType.Int);
if (ddlSubset.Items.Count!=0)
{
  CmdUpdate.Parameters["@SubsetID"].Value=ddlSubset.SelectedValue;
}
esle
{
  CmdUpdate.Parameters["@SubsetID"].Value=null;
}

MarcinJuraszek · Accepted Answer · 2013-03-24 15:48:49Z

16

Use System.DBNull class:

CmdUpdate.Parameters["@SubsetID"].Value = DBNull.Value;

answered Mar 24, 2013 at 15:48

MarcinJuraszek

126k15 gold badges199 silver badges267 bronze badges

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

Comments

Daniil · Accepted Answer · 2013-03-24 15:49:32Z

2

Use DBNull:

CmdUpdate.Parameters["@SubsetID"].Value = DBNull.Value;

answered Mar 24, 2013 at 15:49

Daniil

4133 silver badges10 bronze badges

Collectives™ on Stack Overflow

how to insert null into sql database with ADO.Net C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related