[RESOLVED] Need advice with LINQ code

[CADman69]

I am trying to find out what I did wrong with the following code.

        Dim filter1 = From Electrical In ElectricalPartsDataSet.Electrical _
                      Where Electrical.Product = "Resistor" _
                      Select Electrical.Product, Electrical.Name, Electrical.Picture, Electrical.Pdf

        Me.ElectricalDataGridView.DataSource = filter1 

My dataset name is "ElectricalParts" and the table name is "Electrical". The table consists only the fields that are in the select statement. Its small until I get the filtering working and understand it.

I placed this in a button just to run it. Eventually attaching it to a listbox that will contain different electrical products and the "Resistor" will be changed to reflect the listbox selection. This way the datagridview will filter accordingly.

I have 2 lines filled in the database, one of them is "Resistor", when the above code runs, the datagridview displays nothing.

Thanks,

PS. If additional info is required please let me know. I tried to cover it all, but might of missed something.