I have records in a database that I want to display in a listview. The listview is so the user can see what records are attached to a project, so the data is limited and just for reference. That's why I am thinking listview. The listview is on a tab page. The data to fill that view will come from the user's input (a click on a folder in a treeview on a separate tab page). What I was thinking was add a table adapter to the listview, binding the litsview to it and executing an SQL. Something like myListview.tblAdapter.FillByRSID(13) (pseudo code, of course). My question is; am I thinking this correctly or have I misunderstood the processes?
You can tell I am really new to this, so be gentle with me. This screen shot is where the user would select the folder (the last node) gives up the data (018 in this case) which is used as they key to the data. The tab titled Runsheet is where the data will appear.
Should the table adapter be placed on the listview or on the tab page?
I'm using Visual Studio 10 Professional, Windows 7.
Thanks for the input.