dropdown list box value show according to database value

Question

1.00/5 (1 vote)

See more:

i have a record and i want to edit record and when i click on edit button i am showing old values in form for editing and there is also dropdownlist box in edit option there is office code and office name bound wigth ddl and i fill whole ddl items and value now i want that value of ddl is selected as user previously selected and value is stores in database i can show old values in text boxes but how to show old value in ddl
plz help mine code is in asp.net using VB

Posted 25-Nov-13 6:07am

UD(IA)

Add a Solution

2 solutions

Solution 2

always use trim function whenever we pick value from textvalue from database

Posted 30-Nov-13 23:05pm

UD(IA)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Abhinav S · Accepted Answer · 2013-11-25T06:30:00

Solution 1

You can store the old value in a variable and then set the selectedvalue in the drop down to this value.

Posted 25-Nov-13 6:30am

Abhinav S

Comments

UD(IA) 25-Nov-13 17:42pm

i do this but not work..
Dim office1 = read1("Office_Cd").ToString()
ddl_editOffice.SelectedValue = office1

UD(IA) 25-Nov-13 18:36pm

'ddl_editOffice' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value

i got this type of error when i try to do this
office_Cd="01"
Dim sql1 As String = "select * from Office_Mast where Office_Cd='" & officeCd.Trim & "' order by Office_Name"
Dim cmd3 As New SqlCommand(sql1, conn)
Dim dr1 As SqlDataReader
dr1 = cmd3.ExecuteReader
ddl_editOffice.DataTextField = "Office_Name"
ddl_editOffice.DataValueField = "Office_Cd"
ddl_editOffice.DataBind()
ddl_editOffice.Items.Insert(0, "--Select--")
If dr1.IsClosed = False Then dr1.Close()
ddl_editOffice.SelectedValue = officeCd