InfoPath Dev

They are independent tables. I have to send two queries to two independent tables. Thanks

Hi, I have a form based on a microsoft sql database. I am able to get requested data from one table in the database. But now i need to add one more query sending to a different table in the same database and want the result. Is it possible in ...

Hi, I need to send a query to database and the generated table should be displayed in the form. Is this possible with infopath? Regards, Kiran

When i write this following small code i am getting error in the red line. Kindly help. Sub CTRL104_5_OnClick(eventObj)  Dim Startday Startday= XDocument.DOM.selectSingleNode("/my:Try_here/my:Leave_table/my:From/@my:Day").text End Sub

Hello,  Thank you very much. It got how to use it, and it works fine.

 Hi Swathip,            Very glad for the active reply. I think i was not quite clear in my previous reply. I want to know the number of 'Open's in the status column. That number should come in the text box.

 One more problem, can i fire a query to sql and get the result into a text box. For instance when i select 'Open' in the status column can i get number of 'Open's  in status column and get the value into a text box?

Thanks a lot for the quick response. It worked.

Say these a table with few rows and two columns, like name and email id, which is my secondary data source. The entries of a drop-down list box is the  name column. I want to populate a text box with the corresponding emaid id(from the secondary data source) when a certain value is chosen in drop-down box.

 I am new to infopath. I have a sql db as a secondary data source. I want to send a query with a button and add that generated values as the lookup values to dragdown box. Is that possible?