I want to take info from one table and put it in a list box.
The problem is that the info requires a JOIN between two tables.
I understand that if I want to only use one table I would do:
DataRowView row; row = (DataRowView)whateverAdapter.List[index]; listBox.Items.Add(row["Whatever"];
But how would I incorporate SQL statements, in particular JOIN statmenets into my Code?
I didn't really provide specifics, I just want to know how to use SQL statments in Visual Studio.