Hi again everyone.
I'm using Microsoft Access (2003), Visual C# .Net, and an OleDbConnection.
I've been filtering a data grid view by means of a Fill Command:
By simply calling this every time Column 2 changes, the datagrid view continually displays only the records that are relevant to the current object (which is denoted in colmn 2, obviously).Code:SELECT ID, [Column 2], [Column 3], [Column 4] FROM [Table 3] WHERE ([Column 2] = ?)
I now need to make it possible to select (and display) several objects at once (still filtering by column 2, but where Column 2 is equal to any item in the specified List<>. The list can be any size).
Is there a way to retrieve this? Or a better way of doing things?
Thanks in advance.
Qu.




Reply With Quote