NullReferenceException Occured - dropdownlist ASP.Net 4 C#

Question

I have a dropdown containing blank, Yes and No. If the user selects No I want Label1 to say "No further info required".

I'm getting a nullreferenceexception when I debug - The value in SQL db of the field is NULL when the user gets to using the dropdown, I want them to be able to select Yes or No and also if they have selected and stored "Yes" or "No" previously, I also want them to be able to go back in and select blank which will feed NULL back into the database.

What's the simplest way of handling this? I assume the error is thrown because of the NULL value in the DB?

Code:

<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="true"
             SelectedValue='<%# Bind("BlahBlah") %>' 
             onselectedindexchanged="DropDownList1_SelectedIndexChanged">
            <asp:ListItem></asp:ListItem>
            <asp:ListItem>Yes</asp:ListItem>
            <asp:ListItem>No</asp:ListItem>
         </asp:DropDownList>`

full cs:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace FrontEnd_v1
{
public partial class WebForm1 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {


        if (DropDownList1.SelectedValue == "No")
        {
            Label1.Text="No Further Info Required";
        }

        else
        {
            Label1.Text="";
        }



    }
}

}

designer.cs:

//------------------------------------------------------------------------------
// <auto-generated>
//     This code was generated by a tool.
//
//     Changes to this file may cause incorrect behavior and will be lost if
//     the code is regenerated. 
// </auto-generated>
//------------------------------------------------------------------------------

namespace FrontEnd_v1 {


public partial class WebForm1 {

    /// <summary>
    /// FormView1 control.
    /// </summary>
    /// <remarks>
    /// Auto-generated field.
    /// To modify move field declaration from designer file to code-behind file.
    /// </remarks>
    protected global::System.Web.UI.WebControls.FormView FormView1;

    /// <summary>
    /// RM_Remediation control.
    /// </summary>
    /// <remarks>
    /// Auto-generated field.
    /// To modify move field declaration from designer file to code-behind file.
    /// </remarks>
    protected global::System.Web.UI.WebControls.SqlDataSource SQLSource;


    /// <summary>
    /// Button1 control.
    /// </summary>
    /// <remarks>
    /// Auto-generated field.
    /// To modify move field declaration from designer file to code-behind file.
    /// </remarks>
    protected global::System.Web.UI.WebControls.Button Button1;

    protected global::System.Web.UI.WebControls.DropDownList DropDownList1;

    protected global::System.Web.UI.WebControls.Label Label1;
    }
 }

It's declared in the designer.cs as - protected global::System.Web.UI.WebControls.Label Label1; the error is thrown when selecting anything from the dropdown in debug mode — user3294008
– user3294008, Commented Nov 7, 2014 at 12:05
Can you try this one <asp:ListItem Text="Select One" Value=""></asp:ListItem> <asp:ListItem Value="Yes" Text="Yes"></asp:ListItem> <asp:ListItem Value="No" Text="No"></asp:ListItem> — HaveNoDisplayName
– HaveNoDisplayName, Commented Nov 7, 2014 at 13:28

SanyTiger · Accepted Answer · 2014-11-07 12:09:28Z

1

If it is showing NULL in the SQL, it means that no value was inputted at it's place. You might wanna re-embed values into your DB because a NULL is virtually empty field.

answered Nov 7, 2014 at 12:09

SanyTiger

6661 gold badge9 silver badges23 bronze badges

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

2 Comments

user3294008 Over a year ago

Yeah I know that - I want it to be NULL in the SQL unless the user has selected Yes or No

SanyTiger Over a year ago

Then Specify it was string, as in string Result = "NULL"; in your code and store Result in SQL as Varchar field datatype

Genish Parvadia · Accepted Answer · 2014-11-07 12:11:48Z

1

try this code. Add Value in ListItem.

  <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="true"
         SelectedValue='<%# Bind("BlahBlah") %>' 
         onselectedindexchanged="DropDownList1_SelectedIndexChanged">
      <asp:ListItem></asp:ListItem>
      <asp:ListItem Value="Yes" Text="Yes"></asp:ListItem>
      <asp:ListItem Value="No" Text="No"></asp:ListItem>
    </asp:DropDownList>`

answered Nov 7, 2014 at 12:11

Genish Parvadia

1,4553 gold badges17 silver badges31 bronze badges

Collectives™ on Stack Overflow

NullReferenceException Occured - dropdownlist ASP.Net 4 C#

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related