Re: newbie: Need feedback about this!

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

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

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

If your database can parse Comma Separated Variable (CSV) files, then
that would be an alternative way of sending the strings.

rossum

.

Relevant Pages

  • 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)
  • 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!
    ... 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)