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; } ```

Accepted Answer

Use `System.DBNull` class:

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

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

Solution

Problem