Dynamically populating DropDownList in a datagrid

write this in codebehind. This reads the data from the database but u can use the readXml method of the dataset and popluate.

Public Function PopulateTitle() As DataSet
Dim cn As New SqlConnection
Dim daPricing As SqlDataAdapter
Dim dsPricing As New DataSet
Dim TempList As New DropDownList
Dim myRow As DataRow
cn = New SqlClient.SqlConnection("ur connection string")
cn.Open()
daPricing = New SqlDataAdapter("SELECT TITLE, TITLE_ID FROM XYZ ORDER BY TITLE", cn)
daPricing.Fill(dsPricing)
PopulateTitle = dsPricing
dsPricing.Dispose()
daPricing.Dispose()
cn.Close()
End Function

write the following in .aspx
  
      
       
      
      
       OnPreRender="setTitle" Width="176px">
       
      
     

Method which is highlighted is as follows

Public Sub setTitle(ByVal sender As Object, ByVal e As System.EventArgs)
Dim ddlTitle As DropDownList
ddlTitle = sender
If (Not ddlTitle Is Nothing And strServiceTitle <> "") Then
ddlTitle.ClearSelection()
ddlTitle.Items.FindByText(strServiceTitle).Selected = True
End If
End Sub

strServiceTitle is: