Hi,

Are you looking for something like that:
string qry = "MyValue";  //<----- or from a textbox in IP
ADOAdapterObject oNameTable = (ADOAdapterObject)
thisXDocument.DataAdapters["tblTest"];
oNameTable.Command = string.Format("Select * from tblTest where Test = '" +
qry + "'");
oNameTable.Query();

Hope that it helps.

Regards,

Franck Dauché