I have a datagrid that's connected to a COMMAND. What I would like to do is change part of the sql statement at run-time. Currently the "where name " is hard coded. I want the "where name =" to be whatever name is displayed in combo1.text. At run-time, all i need is to change my combo1.text and it updates the command for my data grid. I don't have a clue. So, if there's a solution out there, i'm pretty much going to need an example.

Thanks.