newbie: Need feedback about this!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Jeff" <it_consultant1@xxxxxxxxxxxxxxxxxx>
Date: Sun, 6 Aug 2006 16:18:54 +0200

hey

asp.net 2.0

I have an array of strings which I need to send in as a parameter to a
stored proedure. As far as I know it's impossible to send an array into a
stored procedure. But I think a stored procedure accepts xml files as a
parameter. So I thought to create a DataSet and populate it with my array of
strings. Then use DataSet.WriteXml to generate the xml file.. Send this XML
file as a input parameter into the stored procedure and use OPENXML to loop
through the records in the xml file....

Is this a good way of doing it?...

Jeff

.

Follow-Ups:
- Re: newbie: Need feedback about this!
  - From: rossum
- Re: newbie: Need feedback about this!
  - From: Siva M
- Re: newbie: Need feedback about this!
  - From: Nicholas Paldino [.NET/C# MVP]

Prev by Date: Re: Intellisense options
Next by Date: Re: newbie: Need feedback about this!
Previous by thread: Please Help: Resource Files and Excel
Next by thread: Re: newbie: Need feedback about this!
Index(es):
- Date
- Thread

Relevant Pages

Re: newbie: Need feedback about this!
... I have an array of strings which I need to send in as a parameter to a ... But I think a stored procedure accepts xml files as a ...
(microsoft.public.dotnet.languages.csharp)
Re: newbie: Need feedback about this!
... Yet another approach is to send the array of strings as a single delimited ... But I think a stored procedure accepts xml files as a ...
(microsoft.public.dotnet.languages.csharp)
Re: newbie: Need feedback about this!
... I'd love a way to send an array as ... then access that table from your stored procedure. ... I have an array of strings which I need to send in as a parameter to a ... Then use DataSet.WriteXml to generate the xml file.. ...
(microsoft.public.dotnet.languages.csharp)
Re: K&R2 Secition 5.9 - major blunders
... Each element of b doesn't point to a 20 element array of int. ... This mistake is crucial because ... my explanation is really the qualities of something else: ... > The use of the array of pointers is to store the strings. ...
(comp.lang.c)
Re: K&R2 Secition 5.9 - major blunders
... Each element of b doesn't point to a 20 element array of int. ... This mistake is crucial because ... my explanation is really the qualities of something else: ... > The use of the array of pointers is to store the strings. ...
(comp.lang.c)