troubleshooting Question

How to show a blank for first item in drop down list

Avatar of obb-taurus
obb-taurusFlag for Canada asked on
C#ASP.NET
5 Comments1 Solution309 ViewsLast Modified:
I have a few drop down lists in my ASP.NET web form and would like them not to display the first entry of the data that's used to populate the control, I would like it to be either blank or that it says something like "Choose Item".  The code I use to load and bind the controls is as follows:

cboCategoryList.DataSource = database.GetInventoryCategories();
cboCategoryList.DataValueField = "ID";
cboCategoryList.DataTextField = "Description";
cboCategoryList.DataBind();

 public DataView GetInventoryCategories()
    {

        string selectStatement =
            "SELECT ID, Description " +
            "FROM InventoryCategories " +
            "ORDER BY ID";
        SqlDataAdapter da = new SqlDataAdapter(selectStatement, _connectionString);
        DataTable dt = new DataTable();

        try
        {
            da.Fill(dt);
            return dt.DefaultView;
        }
        catch (SqlException ex)
        {
            throw ex;
        }
        finally
        {
            _connectionString.Close();
        }
    }
ASKER CERTIFIED SOLUTION
ukerandi

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros