asp.net dropdown menu items from sql

Question

I have a drop down menu

 <asp:DropDownList ID="ddlUser" runat="server" CssClass="form-

control" AppendDataBoundItems="True" DataSourceID="SqlDataSource2" 

DataTextField="Person" DataValueField="PersonID" 

OnSelectedIndexChanged="ddlUser_SelectedIndexChanged" AutoPostBack="True">

        <asp:ListItem>Select User</asp:ListItem>

        </asp:DropDownList>

        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="

<%$ ConnectionStrings:IBS_6 %>" SelectCommand="SELECT DISTINCT PersonID, PLName 

+ ' 

    ' + PFName + ',' + PMoNo AS Person, PFName, PLName, PMoNo, PEmail, PArea, 

PCity, PAge, PGender, PType, PStatus, dbTstamp FROM tbl_persons ORDER BY 

dbTstamp DESC"></asp:SqlDataSource>

if the value of any fields of file 'PMoNo' is blank or null then dropdown menu's item's display is blank. Howere the value of the item comes I can select the blank item.

Stefano Losi · Accepted Answer · 2017-07-12 18:17:24Z

2

If PfMoNo is null, then also PfName + ‘,’ + PfMoNo is null, so DropDown sees Person null and does not display text. You should use COALESCE(PfMoNo,‘’) instead of PfMoNo

answered Jul 12, 2017 at 18:17

Stefano Losi

8291 gold badge8 silver badges19 bronze badges

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

1 Comment

Mashhoor Gulati Over a year ago

This helped. Thanks.

Collectives™ on Stack Overflow

asp.net dropdown menu items from sql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related