Same selectedvalue in dropdownlist??

[Karan_TN]

i m currently using ASP.NET with C# (.net 2005, 2.0 framework) i m taking the TEXT,VALUE from database (SQL server) and binding to an dropdownlist box. some values are same and the text differ. for example the text and value i m binding to an dropdownlist is mentioned below. First - 1 Second - 2 Third - 3 front - 1 Rear - 1 when i bind the above values and process, i cant pick up the values properly. once the "front" is selected, and i attempt to change for "Rear" or "First", its not reflecting... Why this problem?. thanks in advance...

[eyeseetee]

What do you mean by:

Karan_TN wrote:

once the "front" is selected, and i attempt to change for "Rear" or "First"

How are you changing this?

[Karan_TN]

Thanks for replying.... public void fxn() { MyLib.conn.Open(); MyLib.sqlda = new SqlDataAdapter("select TEXT,VALUE from tbl_test where criteria=hello", conn); sqlda.Fill(MyLib.ds); cbovalue1.DataValueField = "VALUE"; cbovalue1.DataTextField = "TEXT"; cbovalue1.DataSource = MyLib.ds; cbovalue1.DataBind(); cbovalue1.Items.Insert(0, new ListItem("", "")); ds.Reset(); ds.Clear(); ds.Dispose(); sqlda.Dispose(); conn.Close(); } by using the above coding i m binding the VALUE,TEXT to cbovalue1 dropdownlist box. when i m changing the value its not reflecting (as mentioned in my previous scrap). help me...

[eyeseetee]

Do you mean you have changed a value in the database and it is not reflecting in the dropdown list?

[trish_]

Here some fields have same values like First,front & rear have value 1. Hence if you select any text which has same value it points to first text which has value 1. solution : if possible change you sql quesry as select TEXT,concat(VALUE,TEXT)as VALUE from tbl_test where criteria=hello" now you will get the required text selected. If you need a value of selected,you need to pick only VALUE part from (VALUE,TEXT) combination

trish http://AllJobSearch.blogspot.com

modified on Monday, April 28, 2008 7:13 AM

[Karan_TN]

hai trish....... there is no function CONCAT in MS SQL server

[Karan_TN]

hai .netman, not changing the value in database. when i change the text in dropdownlist, its not fetching the value of the particular "selecteditem" for example if the drop down list consist of "A,B,C,D,E" as {dropdowntext} and the values are A=1;B=1;C=4;D=1;E=2; so,....... when i select the "A" no problem. sequencly i select "B", no problem. again i select "D", its not selecting.instead "A" remains there.

[trish_]

Yes there is no CONCAT fucntion in Sql Server .it's in ORACLE For Sql Server you can do the same thing with + sign e.g Select First_Col + Second_col from table

trish http://AllJobSearch.blogspot.com