I have a SQL statements stored in the config.xml file.

There is a WHERE clause in the sql statements. The values in the Where clause will be known only at runtime. How can I do this? Some one suggested me to use OLEDBParameter object.
The sql statement is read from config.xml file


//The value of sTerm will changed based on the resultset of previous query.

string sTerm = "Overnight";

ssql = "SELECT Term, BenchMark FROM RATESLIVE WHERE Pricing_Tier = 1 AND Term = '" + sTerm + "'";

OleDbConnection oMSAccessConnection = new OleDbConnection(sConnectionstring);

OleDbCommand oMSAccessCommand = new OleDbCommand(ssql, oMSAccessConnection);

oMSAccessConnection.Open();

OleDbDataReader oDataReader = oMSAccessCommand.ExecuteReader();