Protected
Sub BindToImageList(ByVal combo As RadComboBox)
''Populate the datatable
Dim sConnString As String = ConfigurationManager.ConnectionStrings("PU89").ConnectionString
Dim objConnection As New SqlClient.SqlConnection(sConnString)
Dim strSQL As String
strSQL =
"SELECT * FROM tblPhotoGallery; "
Dim objDR As SqlDataReader
Dim command As New SqlClient.SqlCommand(strSQL, objConnection)
Dim strFullPath As String
Dim strFileName As String
Me.rcboImage.Items.Add(New RadComboBoxItem("", ""))
Try
objConnection.Open()
objDR = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
While objDR.Read()
strFullPath = objDR(
"ImagePath")
strFileName = Path.GetFileName(strFullPath)
Me.rcboImage.Items.Add(New RadComboBoxItem(strFileName, strFileName))
Me.rcboImage.FindItemByText(strFileName).ImageUrl = objDR("ImagePath")
Me.rcboImage.FindItemByText(strFileName).DisabledImageUrl = objDR("ImagePath")
End While
Catch ex As Exception
Response.Write(ex.Message)
Response.End()
Finally
If objConnection.State = ConnectionState.Open Then
objConnection.Close()
End If
End Try
End Sub