Newbie questions: question 1

[Jon Sellers]

Just finished F. Scott Barkers "InfoPath 2003". I now have a clue! However,
first specific question:

How do I query an access database for a range of values? Example: I have an
order table in access and I would like to query based on starting and ending
order number, entry date, and customerid. Do I modify the sql in the data
connection or somewhere else?

 

[Franck Dauché]

Hi,

You can use C# code behind:

string qry = "MyValue";
ADOAdapterObject oNameTable = (ADOAdapterObject)
thisXDocument.DataAdapters["tblTest"];
oNameTable.Command = string.Format("Select * from tblTest where Test = '" +
qry + "'");
oNameTable.Query();

You just need to modify the SQL statement to fit your case.

Hope that it helps.

Regards,

Franck Dauché