Change Command Text At Run Time

[ProjectExplorer]

I am connecting to an access database by dragging data objects onto my form (Dataset etc.) I want to be able to change the (OleDbCommand)Command Text property at run time so it includes the value from a text box in the query. But I dont know how to get to the Command Text property.

Can any one help please.

Thanks.

 

[Qik3Coder]

Keep in mind that the objects on the page are still objects, with properties.

This isn't exact, but you should be able to access the Command object for the dataset, which should have a CommandText property, which you can modify at will.


-Sometimes the answer to your question is the hack that works