We have a VB application with a datagridview control on it.
It's connected to a SQL database and displaying the data fine, however we now want to have it only return data that satisfies a specified "select ...." statement.
We can't find an example of how to do this. We need an example. This is Visual Studio 2008 using .Net 3.5. I don't know if that matters though.
Can someone send the code or a pointer to where there is an example of doing this?
We don't want to see how to change what is visible (by hiding rows in the dataview grid) or that sets one dataviewgrid on another. We want to know how to change the data it selects and returns.
We'll take an example in C# if we can translate it.