LINQ to SQL error

Question

I have a form in which I am able to list a parent table using datagridview. I also have a child payment table that list all the payments made. I have added a combo box so I can make my search more efficient. Everythhing worked great until I added to box. Now I get this error==

InValidCastException == Conversion from string "" to type 'Double' is not valid.

Can you please helpme correct this?? I am using SQL Server 2005 and Visual Studios 2008.

Dim teamList = From Bowler In Db.Bowlers _ Where Bowler.TeamNumber <> "" _ Order By Bowler.TeamNumber _ Select Bowler.TeamNumber For Each TeamNumber In teamList Me.ToolStripComboBox1.Items.Add(TeamNumber) Next End Sub

Thanks Cheryl

Answer 1

I assume Bowler.TeamNumber is a Double datatype. This means you cannot do

Bowler.TeamNumber <> ""

instead you can only do

Bowler.TeamNumber <> 0

or

Bowler.TeamNumber <> NULL

EDIT: Following on from comment, you need something like this:

Dim teamList = (From Bowler In Db.Bowlers _ 
Where Bowler.TeamNumber <> "" _ 
Order By Bowler.TeamNumber _ 
Select Bowler.TeamNumber ).Distinct()

For Each TeamNumber In teamList 
Me.ToolStripComboBox1.Items.Add(TeamNumber) 
Next