Iam Using dropdownlist.using get Function . select the value not selecting.it default selecting 1st value. how to slove this problem.

See more:

VB

ASP.NET

DropDownList

Protected Sub GetDeviceTypeDDL()
Try
cmd.Connection = con
cmd.CommandText = "SELECT [DEVCODE], [DEVDESC] FROM [TBL_DEVICETYPE_COD]"
cmd.Connection.Open()
dr = cmd.ExecuteReader()
'ddlSignatory.Items.Add("")
While dr.Read()
Dim newListItem As New ListItem()
newListItem.Text = dr.GetString(0).ToString()
newListItem.Value = dr.GetValue(1).ToString()
ddlDeviceType.Items.Add(newListItem)
End While
cmd.Connection.Close()
Catch ex As Exception
ddlDeviceType.Items.Add("")
cmd.Connection.Close()
End Try
End Sub
Protected Sub GetDeviceTypeDetails()

Dim da As New SqlDataAdapter("SELECT [DEVCODE], [DEVDESC] FROM [TBL_DEVICETYPE_COD]", strcon)
Dim dt As New Data.DataTable
da.Fill(dt)
da.Dispose()
ddlDeviceType.DataSource = dt
ddlDeviceType.DataTextField = "DEVDESC"
ddlDeviceType.DataValueField = "DEVCODE"
ddlDeviceType.DataBind()
'ddlcmp.ClearSelection()
End Sub