473,406 Members | 2,707 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Binding to a Listbox... weird errors

Don't ask why it's coded this way.. the clueless developer before me
coded things upside down and insideout :\

Anyways,

We have a simple SQL Query that reads a table into a DataSet.

Here's the way the query is being built:

strSQL = "SELECT FirstName + ' ' + LastName as TextField, UserID AS
ValueField FROM tblStaff " & _
"WHERE CanBeAssigned = 1"
If Not objUtil.Session("blnSystemUser") Then
strSQL &= " AND UserName <> 'icompass' "
End If
strSQL &= " UNION " & _
"SELECT D.Name + ' - ' + S.FirstName + ' ' + S.LastName as
TextField, S.UserID AS ValueField " & _
"FROM tblStaff S, tblDepartments D " & _
"WHERE S.MainContact = 1 " & _
"AND S.DepartmentID = D.DepartmentID "
If Not objUtil.Session("blnSystemUser") Then
strSQL += " AND S.UserName <> 'icompass' "
End If
strSQL += " ORDER BY TextField "
dadSQL.SelectCommand.CommandText = strSQL
dadSQL.Fill(dstData, "tblItemStaffResponsible")
-------
'Binding
lstOwner.DataSource = objDataIn.DataSet
lstOwner.DataMember = "tblItemStaffResponsible"
lstOwner.DataTextField = "TextField"
lstOwner.DataValueField = "ValueField"
lstOwner.DataBind()

When it hits lstOwner.DataBind() It will catch an exception that tells me:

Message "Specified argument was out of the range of valid values.
Parameter name: value"
-----
The query that is ran returns these results:
------------------

TextField ValueField
Jake Sysadmone 2
Ryan Ternier 16
Any suggestions on why it's hitting the Catch?
Nov 19 '05 #1
0 996

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Jason | last post by:
Here is an odd issue. I am trying to shed some light on why this is causing a problem. I have an ArrayList. I am binding it to a ListBox control with has its Sort property set to True. If the...
3
by: me | last post by:
I've included a picture below to show what I am trying to accomplish. It is best to copy/paste into notepad to get the spacing correct. I have a dataset that contains 3 tables. Two of the tables...
8
by: Richard L Rosenheim | last post by:
I have a dataset containing a parent table related to a child table. The child table contains an ID field (which is configured as autonumber in the datatable), the ID of the parent, plus some...
1
by: A. Spiehler | last post by:
I'm trying to fill a listBox control with string members from an array of objects. I think using data binding is supposed to be the easiest way to do this. I've never used data binding before and...
3
by: Ali Chambers | last post by:
Hi, I have created a listbox called "dtlist1" on my VB.NET form. I call a procedure as follows: Private Sub openfile(flname As String) dtlist1.Items.Clear() etc..
1
by: pauled | last post by:
Hello all, Framework 1.1 VS 2003 Binding listbox. I have an array of objects that I am trying to use as the datasource for a listbox. The array is returned from a webservice and seems to be...
1
by: Peter | last post by:
Hi, I'm trying to create a form that shows table rows in a listbox. Several comboboxes expand the foreign key fields into text values from the parent tables, and there are also some textboxes...
0
by: EricLondaits | last post by:
Hi, I have an ASP.NET page with a ListBox that is data bound to a table with a single field (it holds a list of valid IDs). The page also has a textBox into which you can add new valid IDs, one...
0
by: furqanms | last post by:
Hello, I am new to WPF ,I am developing touch screen system using WPF. I am facing problem in Binding relative reference. Here is my code : <UserControl x:Class="uctlBrowser" ...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.