<div>
<div class="content wysiwyg-content">
I need to write a c# webservice to accept a 1 character parameter and xml and pass this to a SQL Server 2005 stored procedure which will accept the 2 parameters (accepting the xml as an xml type in SQL)<br />
<br />
Can anyone give me an example. Thanks
</div>
</div>


I need to write a c# webservice to accept a 1 character parameter and xml and pass this to a SQL Server 2005 stored procedure which will accept the 2 parameters (accepting the xml as an xml type in SQL)

Can anyone give me an example. Thanks

C# web service XML pass to stored procedure

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.