Set value of dropdown list in datagrid

[Eric J.]

I have a datagrid with a column containing a label and a dropdown (for the edit mode). When I choose edit, the dropdown should select the value corresponding to the label. Now it always selects the first item in the list.
I have no idea where I can put code for this. I tried without success in the OnEdit handler, but I cannot set the value of the dropdown list there.

Any suggestions?

 

[Thusith Kathaluwage]

maybe because you did not put your code inside IsPostBack checking. so
when you select the item in list server reloads the page with initialize
data with your slections. do include inside checking like this

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

If IsPostBack = False Then
Dim Con As New SqlConnection(strConnectionString)
Dim cmd As New SqlCommand("Select MovID, MovTitle FROM
Movie", Con)
Con.Open()
Dim drMovie As SqlDataReader = cmd.ExecuteReader

With ddlMovie
.DataSource = drMovie
.DataTextField = "MovTitle"
.DataValueField = "MovID"
.DataBind()
.Items.Insert(0, "<-- Select -->")

End With
Con.Close()
End If

End Sub

Hope this helps

Thusith