Send A String Of Xml To Sql Using .Net
I Need To Know The Best Way To Send A String Of Xml To Sql Using .Net
So I Can Get A Table Of Inputs
All What I Have Done Is
1- Get The Data And Fill It In DataTable Object
2- Fill a DataSet With The Previous Table
3- Get XmlString From DataSet
4- Send String To Sql As A parameter
In sql
5- Using SP_XML_PrepareDocument and openXML Procedures To Get The Table Of Inputs
Is There any Comment
Ahmed Ali
Software Developer
__________________
Ahmed Ali
Senior Software Developer
|