About dropdownlist binding

Question

0.00/5 (No votes)

See more:

I bind data to dropdown list But when i am running the project datas are repetedely comining in the dropdown list...I need a help
My code:

XML

<asp:DropDownList ID="drpPurcahseBrand" runat="server" Height="24px"
                                       Width="173px" AppendDataBoundItems="True" AutoPostBack="True">
                                  <asp:ListItem Text="Select Brand" Selected="true"></asp:ListItem>
                                   </asp:DropDownList>

C#

drpPurcahseBrand.DataSource =                        ClassLibrary1.mainclass.dset("brand_name", "");
            drpPurcahseBrand.DataValueField = "Brand";
            drpPurcahseBrand.DataTextField = "Brand";
            DataBind();

Stored Procedure:
ALTER PROCEDURE brand_name
	
AS
	select Brand from Rate
	RETURN

Posted 11-Sep-14 20:17pm

Member 10977666

Updated 11-Sep-14 20:46pm

v3

Add a Solution

Comments

Prasad Avunoori 12-Sep-14 2:27am

Can you please post your code?

santoshkrpathak@gmail.com 12-Sep-14 2:31am

Please explain bit more or post some Example code

Bhavik_Patel 12-Sep-14 5:10am

your code is right...can you elaborate in which condition this problem comes? It may be you are calling dropdownlist binding method twice

5 solutions

Solution 1

Do this
before you bind Data.

C#

drpPurcahseBrand.Items.Clear()

Posted 11-Sep-14 20:47pm

ChintanShukla

Solution 3

drpPurcahseBrand.Items.Clear()
drpPurcahseBrand.DataValueField = "Brand";
drpPurcahseBrand.DataTextField = "Brand";
DataBind();

Posted 11-Sep-14 21:22pm

praveenagarkar

Solution 5

Set AppendDataBoundItems="False" else delete this. It will work.

Posted 12-Sep-14 4:30am

Strikerzz Arut

Solution 2

remove return..

SQL

Stored Procedure:
ALTER PROCEDURE brand_name

AS
begin

    select Brand from Rate
end

Posted 11-Sep-14 21:02pm

/\jmot

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

pradiprenushe · Accepted Answer · 2014-09-11T22:49:00

Solution 4

set AppendDataBoundItems="True" to false

and in code

C#

drpPurcahseBrand.DataValueField = "Brand";
            drpPurcahseBrand.DataTextField = "Brand";
            DataBind();
ListItem lst = new ListItem ( "Select Brand" , "0" );
drpPurcahseBrand.Items.Add(lst );

Posted 11-Sep-14 22:49pm

pradiprenushe

About dropdownlist binding

5 solutions

Solution 1

Solution 3

Solution 4

Solution 5

Solution 2

Add your solution here

Preview 0

About dropdownlist binding

5 solutions

Solution 1

Solution 3

Solution 4

Solution 5

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us