Re: newbie: Need feedback about this!
- From: "Siva M" <shiva_sm@xxxxxxxxxxxxxxxxx>
- Date: Sun, 6 Aug 2006 21:18:49 +0530
Yet another approach is to send the array of strings as a single delimited
string (say, '|' separated) and parse it out in the stored proc.
"Jeff" <it_consultant1@xxxxxxxxxxxxxxxxxx> wrote in message
news:eivxWMWuGHA.4208@xxxxxxxxxxxxxxxxxxxxxxx
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
.
- References:
- newbie: Need feedback about this!
- From: Jeff
- newbie: Need feedback about this!
- Prev by Date: Re: Check if form already Open
- Next by Date: Re: Trying to send an ARP(Address Resolution Protocol) Message with Socket
- Previous by thread: Re: newbie: Need feedback about this!
- Next by thread: Re: newbie: Need feedback about this!
- Index(es):
Relevant Pages
|
