quote:

---

Originally posted by Kristen

What happens if you query the database with:

SELECT * FROM tblsubgroups where ckid = 'MySubGroupID'

from, say, Query Analyser?

By the by, you should name the columns instead of "SELECT *" - presumably you only want two columns for your SELECT list?

If someone adds a TEXT column (or several TEXT columns!!) to that table in the future you will be bringing back shed-loads of data that your application doesn't use, and it will crucify your performance - and you'll be searching for, and fixing!, all the SELECT * code for days, weeks and maybe years!

Kristen

---

quote:

---

Originally posted by vk18

Hello Friends,

I am trying to fill the list box with multiple values when i search with id, but it is not working. here is my code.
can you guys tell me what am i doing wrong..? Appreciate your help
Thx



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


sql = "SELECT * 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 sub

---

quote:

---

Originally posted by Kristen

"In Query Analyzer it is working fine. It is just that list box is not displaying the multiple items in it."

Then the problem is in your application logic that displays the data

"Also there are only 2 columns in this table so i don't need to worry about using Select *"

Don't be so naive, you most certainly do.

Kristen

---