AppendDataBoundItems giving dups

[David C]

I have a DropdownList tied to an SqlDataSource (table) used to select a
single company. I also want 2 options on this list, one for no selection
and one for firing an add new company process. However, when I add 2 manual
items, I get duplicates from the company table for each record in that
table. How can I get around this? Below is the control info.

<asp:DropDownList ID="ddlCompanyID" runat="server"
DataSourceID="SqlCompanies"

DataTextField="CompanyName" DataValueField="CompanyID"
AppendDataBoundItems="true">

<asp:ListItem Value="0" Text="--None--" />

<asp:ListItem Value="-1" Text="--<New Company>--" />

</asp:DropDownList>
Thanks.
David

[David Wier]

Could you explain in a little more detail, exactly what's happening?
when you talk about the duplicates, you're explaining something you haven't
referred to previously

Are you adding an item to the ddl, or adding something from the ddl to
somewhere else???

--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://iWritePro.com

"David C" <dl*****@lifetimeinc.comwrote in message
news:O%****************@TK2MSFTNGP03.phx.gbl...

>I have a DropdownList tied to an SqlDataSource (table) used to select a
single company. I also want 2 options on this list, one for no selection
and one for firing an add new company process. However, when I add 2
manual items, I get duplicates from the company table for each record in
that table. How can I get around this? Below is the control info.

<asp:DropDownList ID="ddlCompanyID" runat="server"
DataSourceID="SqlCompanies"

DataTextField="CompanyName" DataValueField="CompanyID"
AppendDataBoundItems="true">

<asp:ListItem Value="0" Text="--None--" />

<asp:ListItem Value="-1" Text="--<New Company>--" />

</asp:DropDownList>
Thanks.
David

[David C]

Sure. For example, I have 2 companies as follows:
CompanyID = 1
CompanyName = Acme Electronics

CompanyID = 2
CompanyName = Digital Services

When I pull down the drop down list it shows the above companies twice. I
think it might have something to do with the fact that I have 2 listitems
added.

David
"David Wier" <da*******@davidwier.nospam.comwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...

Could you explain in a little more detail, exactly what's happening?
when you talk about the duplicates, you're explaining something you
haven't referred to previously

Are you adding an item to the ddl, or adding something from the ddl to
somewhere else???

--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://iWritePro.com

"David C" <dl*****@lifetimeinc.comwrote in message
news:O%****************@TK2MSFTNGP03.phx.gbl...

>>I have a DropdownList tied to an SqlDataSource (table) used to select a
single company. I also want 2 options on this list, one for no selection
and one for firing an add new company process. However, when I add 2
manual items, I get duplicates from the company table for each record in
that table. How can I get around this? Below is the control info.

<asp:DropDownList ID="ddlCompanyID" runat="server"
DataSourceID="SqlCompanies"

DataTextField="CompanyName" DataValueField="CompanyID"
AppendDataBoundItems="true">

<asp:ListItem Value="0" Text="--None--" />

<asp:ListItem Value="-1" Text="--<New Company>--" />

</asp:DropDownList>
Thanks.
David