Newbie questions: question 1

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jon Sellers - 25 Nov 2005 22:02 GMT

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?

Reply to this Message

Franck Dauché - 26 Nov 2005 07:47 GMT

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é

> Just finished F. Scott Barkers "InfoPath 2003". I now have a clue! However,
> first specific question:
[quoted text clipped - 3 lines]
> order number, entry date, and customerid. Do I modify the sql in the data
> connection or somewhere else?

Reply to this Message