Hello, I am trying to populate aListBox witha field(RName) from a LINQ to SQL database (DataClasses1.dbml),table(RTables) filteredby field RType. The RType is being selected by the user from ComboBox1 which is databound to that field. ComboBox1 displaysthe dataproperly but the ListBox displays nothing. This is the code but I am not sure where to put it or why it doesn't work. I've tried to put it in the ComboBox1_SelectedIndexChanged, the ListBox event,and the Form Load event. Thanks for looking. Any help is appreciated.

Hi Audm,

Modify the code snippet similar the following code snippet. Hope this helps.




Best regards,
Riquel

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Audm,

Add a breakpoint to check whether the RByType contains the data. You also can read this article about how to use Linq to SQL in this scenario.

Best regards,
Riquel

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Thanks, Riquel. I'll try that.

Riquel,

I tried what you said and there is data if I do a watch whilestepping through the codebut I don't see any with using a breakpoint. I am getting the exception:

A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

Do you know what that is? I looked at the article you suggested and although the example is in C#, I could understand it enough to realize that they were doing the same thing I am. I couldn't see anywhere where I could've done it wrong.

Hi Audm,

Modify the code snippet similar the following code snippet. Hope this helps.




Best regards,
Riquel

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.