listbox datatextfield......

I'm having the issue of displaying the three elements from the table into the datatextfield of the listbox. I am using this sql statement:
strSQLA="SELECT UserID, playerName, ranking, playerName + ' --- ' + Tposition + ' --- ' + ranking as playerCombo from Allplayers WHERE UserID Is NULL AND NOT(RANKING = 0) ORDER BY ranking ASC" Any clue??

Yet it gives me an error saying. -The provider could not determine the Double value. For example, the row was just created, the default for the Double column was not available, and the consumer had not yet set a new Double value.

Line 51: Line 52: allpList.DataSource = CmdA.ExecuteReader(system.data.CommandBehavior.CloseConnection)Line 53: allpList.DataBind()Line 54: Line 55: ConnA.Close()

Did you specify the DataTextField and DataValueField for the listbox?
Eric
Yeah, that is what is killing me... It works if I leave out the ranking record...., but when I add it back in I get the error. Do I have to set it different when it is a long integer??

allpList.DataTextField="playerCombo"
allpList.DataValueField="playerName"
What are the DataTypes of 'Tposition' and 'ranking'? It may be that you need to do some conversion/casting in your sqlstatement.
They are both text fields and the ranking is long int like I said in the last post. I didn't know I need to do a cast, but I will try and hunt for an example. I am wondering if I need to convert it after the read or can I do it right in the SQL statement? thanks
You do the cast in your sql statement
SELECT CAST(field As nvarchar(50))
Some reading:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp
Eric