openxml - C# example please! - XML SOAP

You need to read the data from the file on the client and pass the content
as type NTEXT (assuming the data in the file is UTF-16 encoded, otherwise
you need to convert it first) to the stored proc via SqlParameter.

Best regards
Michael

"LW" <LW@discussions.microsoft.com> wrote in message
news:010A23E5-1301-4A3D-A998-59D4709F0A74@microsoft.com...
>I have created a stored procedure to use OPENXML to update my SQL2000
> database using an external XML file.
>
> What I need help on is:
> How to pass the XML file as a parameter to the stored procedure.
> Do I call SqlParameter ? If yes, besides the file name, it wants to know
> the dbType and size.
>
> Can someone post the snipped of code to do that ?
>
> Thanks in advance,
> LW