Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Displaying data in a listbox

Author  Topic 

vk18
Posting Yak Master

146 Posts

Posted - 2006-10-20 : 16:13:48
Hello friends,

I am trying to populate list of values in a listbox. but it is displaying only one value instead of multiple values. here is the code for that. I think i should not use
datarow. can you guys help me with this ..
Thx


Public Sub populatesubgroup(ByVal subgroupid As String)

Dim dbFunctions As New DatabaseUtilities
Dim sql As String
Dim objDataRow As DataRow

Try
sql = "SELECT description,ckext FROM tblsubgroups where ckid = " & subgroupid
objDataRow = dbFunctions.GetSQLDataRow(CONNECTIONSTRING, sql)

If objDataRow("description") Is DBNull.Value Then
Else
'Me.lstsubgroup.selectedvalue = objDataRow("description")

End If

End Try
   

- Advertisement -