Executing a script and returning the results..

You know how osql can return the results of executing a .sql script to a window? Is there any way to achieve that same behavior in .NET? I am in the process of working on an application that needs to execute a .SQL script (which is easy to do) and then return the actual SQL output from the execution to a window. How do I get that output? None of the sql data objects seem to support this.I actually figured this one out. I can launch a process (like the command prompt) and then return the output through a stream.

execute SQL store_procedure using XMLs data as parameters

Iwant to learn how can achieve as the subject say, thanks!Hope this link helps :http://eramseur.blogspot.com/2005/11/xml-integration-in-sql-server-2005.html
|||hi Eramseur, I can not open the link you give, pls help to double check, tks!|||Click Here!|||

Try the thread below for SQL Server 2000 XML related articles and download the SQL Server 2005 BOL (books online) for SQL Server 2005 XML stored proc code sample because XML is native in SQL Server 2005. Hope this helps.

http://forums.asp.net/1118260/ShowPost.aspx

http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en