Retrieve data from SQL database

[Ron Simissen]

hello

ive got a problem...
i just started working with infopath (yes im a real noob)

i made in MS SQL a small database, in infopath i made a form. with this form
i can insert new data in the database (that works fine)

now i want to read/retrieve the data from the database.

1st is it possible to do this with info path?
2nd does anyone have a good link for a good step by step howto to create
this (i mean wat button should i use, maybe js i dont know???) or can someone
explain this al to me

thanx for the reply,

Ron Simissen

 

[Andrew Watt [MVP - InfoPath]]

Ron,

I assume that you created your form using the New From Data Connection
option. Right?

Are you using the original release? Or are you using SP1?

If you go to the Data Source task pane do you see both query fields
and data fields?

You should be able to pretty much just drag the data fields on to a
(new, if you wish) view and then add submit functionality.

Andrew Watt
MVP - InfoPath
Author: InfoPath 2003 Kick Start

On Thu, 18 Nov 2004 02:55:08 -0800, Ron Simissen <Ron

 

[Michelle]

Hi Ron,

(1) Yes it is possible to query data from a database.
(2) Are you using script or managed code? Are you using InfoPath SP1?
You can look at the following links to help you out:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;826992

http://msdn.microsoft.com/library/d...-us/ipsdk/html/ipsdkIntegrateWithAccessDB.asp

http://office.microsoft.com/en-us/assistance/HA011199501033.aspx

You can do a couple things:
(1) Have an infopath form based on a DB that retrieves the data
automatically when the form is opened and just display that data
(2) Have an infopath form based on a DB that retrieves the data when
the user clicks a button. This case is particularly useful if you
want to use parameters in the query.

How you do this will depend on whether you are dealing with the Main
DOM or a secondary data source.

Things to look for are DataAdapter, QueryAdapter, Secondary
Datasources.

Hope this gets you started.

Michelle

 

[Ron Simissen]

thnx it worked thank you all for helping me

greetings
Ron