March 12, 2009 at 3:30 pm
I need to pass the XML file to the stored procedure.
I dont want to use OPENXML as i am storing the whole file.
As my App server and DB server is not on same machine i am not able to specify the file path the the OPENROWSET.
Is there any way in ADO.NET by which i can make this out.
March 12, 2009 at 3:50 pm
Load the XML file into you ADO.net based program and then pass it to SQL as an XML datatype.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 13, 2009 at 7:51 am
But Load mean what.
Should i use XMLDocument Object to load the xml file and pass this object as parameter value?
can you provide some sample code for this?
March 13, 2009 at 1:31 pm
Use XmlReader or XmlTextReader to load your XML file into a string, XMLDocument, XMLNode or XMLElement. Then pass it as a parameter value or insert it directly into a table record.
Sorry, I do not have any code of this that I can share.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 13, 2009 at 2:49 pm
Well....
Good hint. i was thinking on the same line.
Thanks.
March 13, 2009 at 3:41 pm
Glad I could help.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply