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

cjk · Accepted Answer · 2009-02-09 16:48:40Z

2

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

edited Feb 9, 2009 at 16:48

answered Feb 9, 2009 at 16:21

cjk

46.6k9 gold badges83 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Anonymous Over a year ago

Thank you so much. I put the "0" everywhere but there.That work great. I can now see the numbers. But, it is now doubling the numbers. There are 4 bowlers per team which means the number "1" will show up 4 times. And it does not populate the grids with info that is in there. Any suggestions. heryl

Anonymous Over a year ago

Thank you. It now only show one number. It is still not populating the tables. Any suggestions?

Anonymous Over a year ago

I git it working.Thanks for your help. Chery Dim bowlerQuery = From Bowler In Db.Bowlers _ Where Bowler.TeamNumber = Me.ToolStripComboBox1.SelectedItem.ToString() _ Select Bowler Me.BowlerBindingSource.DataSource = bowlerQuery

Collectives™ on Stack Overflow

LINQ to SQL error

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related