I have the following code....
VB Code:
commSQL.Connection = cn commSQL.CommandText = "Select Stores From EmpStores_View Where " & _ "LoginName = '" & Request.Cookies("LoginName").Value & "' Order By Stores" datRead = commSQL.ExecuteReader strDistStores = "" Do While datRead.Read If strDistStores.Trim() = "" Then strDistStores = "And (Location = '" & _ datRead.Item("Stores") & "'" Else strDistStores += " Or Location = '" & _ datRead.Item("Stores") & "'" End If Loop strDistStores += ")"
Now when I'm done here, I want to bind this same datasource to a combo box.
What I don't know how to do is get to the first record after I run it through my loop.
Thanks




Reply With Quote