First of all i don't want to just bind the column in dataset to listbox and have it display all the data, i just want it to display list of items that in a column for a selected row(and it can have multiple rows under same id) appear. So table looks like:
2 second note
2 third note
2 4th note
3 5th note
so if a user selects a row with id =2 in datagid, then listbox should add Nots related to all the rows that have that selected it. In this case it should add those 3 notes if any of the id=2 is selected.
If i just bind listbox to datasource, set valuemember and display member, they just dump entire table's notes in that listbox. How can i make it so it will only do as i described above?