Author: bootzilla | Posted on: 11/11/2008 7:34:33 AM | Views : 259

I am trying to display results from a SQL query in a drop down box. Here is the code I current have;

Public Sub fillMonthlyDownloadsDropDownList()

Try
conn = New SqlClient.SqlConnection(strconn)
conn.Open()

Dim strSQL = "SELECT distinct d.group_descr, a.first_name, a.last_name, a.user_id, b.email, d.group_id FROM icc_user_data AS a LEFT OUTER JOIN icc_users AS b ON a.user_id = b.user_id LEFT OUTER JOIN icc_users_groups AS c ON a.user_id = c.user_id LEFT OUTER JOIN icc_groups AS d ON c.group_id = d.group_id WHERE (b.user_id NOT IN (249)) AND (d.group_id IS ...

Go to the complete details ...