SQL Database Integration

Re: How to retrieve data from Ms Access into Infopath

zach007 — Wed, 07 Dec 2005 06:50:28 GMT

Hi,

Thanks for your helps..However, where to put all codes that you gave to me? Infopath or Access..???...if in Infopath, which part should I put the code in and also for Access, which part should I put in about the codes...???...and the tblTest is CUSTOMER (in my case)? and how about oNameTable? which one should I change?...is it just "qry" that need to be changed please? Please help me more details since I am a newbie for Inforpath..

Thank you for your kind helps and attention.

Best Regards,

Rully

Re: How to retrieve data from Ms Access into Infopath

franck — Wed, 07 Dec 2005 06:15:32 GMT

Hi Rully,

Welcome to InfoPathDev!
You could do it through a secondary data source and through code, using something around:

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

In your case, qry would be the employee ID read in a textbox.

your output values (from your secondary DOM) could be displayed with textboxes on your form.

Regards,

Franck Dauché

How to retrieve data from Ms Access into Infopath

zach007 — Wed, 07 Dec 2005 04:51:09 GMT

Dear Experts,

I have a form containing: EmployeeID, FirstName, LastName, Address, Telephone and Email (in my Ms Access database and called as a CUSTOMER table).

What should I do, if I would like to retrieve data by following action:

If I type the employee ID then click "Retrieve" button (or show button), then the rest of information will be appeared on each textfields such as FirstName, LastName, and so on.

Has anyone knows how to do this please?

I really need you helps.

Thank you for your kind helps.

Best Regards,

Rully