Data Connections

Re: Sql server and Infopath

sambita123 — Thu, 25 Sep 2008 08:32:39 GMT

thanks for the reply..

let me try... in this way..

Re: Sql server and Infopath

paresh — Thu, 25 Sep 2008 08:26:54 GMT

One way that I would suggest is to write a web service method that returns the dataset. Then add this webmethod as a secondary data connection in your infopath form and bind the dropdown with the return value of your webmethod i.e. the dataset.

HTH

Thanks,

Paresh

http://www.openzeas.com/blogs/Paresh/default.aspx

Re: Sql server and Infopath

sambita123 — Thu, 25 Sep 2008 07:44:11 GMT

thanks paresh for the help.

Actually i have a textbox in which i will write any item which i want to search,then i will click the button and after that it will search from sql database and it will show the matching items in a repeateting table.

So in button cllick event i have used some coding,

SqlConnection cn = new SqlConnection("server=aaa;database=CMS;UID=xyz;PWD=***;");
            cn.Open();
            SqlCommand cm = new SqlCommand();
            cm.Connection = cn;
            cm.CommandType = CommandType.Text;
            cm.CommandText = "select * from AreaMaster";
            SqlDataAdapter da = new SqlDataAdapter(cm);
            DataSet ds = new DataSet();
            da.Fill(ds);

            XmlNamespaceManager ns = this.NamespaceManager;

            XPathNavigator node = this.CreateNavigator().SelectSingleNode("/my:myFields/my:txt", NamespaceManager);

            for(int i=0;i<ds.Tables[0].Rows.Count;i++)
            {
                if (ds.Tables[0].Rows[i][1].ToString() == node.Value)
                {

                    cm.CommandText="select * from AreaMaster where AreaName='" + node.Value + "'";
                    DataSet ds1 = new DataSet();
                    da.Fill(ds1);



                }
            }

So now in data set i got the data's but my problem is how to show the data's in info path form.

As i am new to infopath don't have that much idae...

if their is any other way to do it..then let me know..........

So please help me.

Re: Sql server and Infopath

paresh — Thu, 25 Sep 2008 06:42:18 GMT

You can also take a look at the following link that has some steps that involves achieving what you are trying to do:

http://blogs.msdn.com/infopath/archive/2006/10/12/cascading-dropdowns-in-browser-forms.aspx

Thanks,

Paresh

Re: Sql server and Infopath

paresh — Thu, 25 Sep 2008 06:33:40 GMT

To which control do you want to bind the dataset?

You can add a secondary dataconnection that returns the dataset and bind it to controls like dropdown or any repeating control by going to the property window of the control.

Do let me know if you need any further info.

Thanks,
Paresh

http://www.openzeas.com/blogs/Paresh/default.aspx

Sql server and Infopath

sambita123 — Tue, 23 Sep 2008 09:03:38 GMT

Hay i am new to infopath.

I have a textbox and according to that textbox value i am filtering data from sql database.now in the datset i have the data ,but how to bind it in infopath form.

I Need help ! ! !