- This topic has 1 reply, 1 voice, and was last updated 9 years, 2 months ago by
.
-
Posts
-
-
HI All,
Through Sql Adapter, is it possible to retrive recordset from SQL and send that recordset data to frontend application (ASP.net or windows).
For eg.
I have Security master table in SQL 2005. I have written a procedure to get data from Security master. The procedure will return me data in following format,
<
Security Id=“REL“, name = “Reliance communication” type = “Equities”
/>
<
Security Id=“TCS“, name = “Tata Consultancy Service” type = “Equities”
/>
Through SQL Adapter in biztalk i am calling these procedure..
Now i want these procedure output on my frontend side, to display on screen..
IS there any way i can do these??
Any help would be highly appreciated.
Thanks in advance
-
Hi.
You can add another public receive-send port(Web). you will recieve the input message from the web page through this public port(Web), get your result from another port(SQL) and send your SQL result to through the former public port(Web).
After you have deployed this orchestration, you will then have to expose you orchestration as a web service.
Add this web service reference on your web application so you can invoke it ans get the results onto your page.
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.