Creating Stored procedure using Xml data

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • suneethakanchana
    New Member
    • Jun 2007
    • 3

    Creating Stored procedure using Xml data

    HI
    my xml structure is
    <?xml version="1.0" encoding="UTF-8" ?>

    <PARAMETERS xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance" xsi:noNamespace SchemaLocation= "EV_Parameters. xsd">

    <DATABASE db_name="EVOS">

    <STORED_PROC sp_name="usp_Ge tModuleOwnersBy ModuleName">

    <PARAMS sql_type="VarCh ar" sql_param_name= "@moduleNam e"></PARAMS>

    <PARAMS sql_type="Int" sql_param_name= "@errorCode ">

    <OUTPUT>0</OUTPUT>

    </PARAMS>

    <PARAMS sql_type="VarCh ar" sql_param_name= "@errorMessage" >

    <OUTPUT></OUTPUT>

    </PARAMS>

    i want to create store procedure in data using this data.
    By calling this xml in c# code.

    Thank you
Working...