Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Pass string of values to stored procedure
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Pass string of values to stored procedure

 Post Reply Post Reply
Author
jamesb View Drop Down
Newbie
Newbie


Joined: 01 September 2003
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote jamesb Quote  Post ReplyReply Direct Link To This Post Topic: Pass string of values to stored procedure
    Posted: 03 September 2003 at 10:32am

I have a large web form - with 35 different textboxes, radiobuttons, drop-downs etc on it. I've written code to automatically parse through the controls on the page when it's submitted, and put all the values entered by the user into a string (could easily be an array of course). The problem I now have is whether there is any way to somehow automate this "string of values" being entered into the sql string (or stored procedure) to be sent to the database. Or am I going to have to write it all out as follows:

(CommandObj.Parameters.Add( "@FirstName", FirstName))
(CommandObj.Parameters.Add( "@Surname", Surname))

etc

Surely there must be a way to loop through the string, each time adding the value to the procedure, and not have to hard-code it 35 times? (I build a lot of similar forms and it would be nice to automate it somehow). If it can't be done with a stored procedure, then perhaps with a plain sql statement?

Thanks for any help

Back to Top
MorningZ View Drop Down
Senior Member
Senior Member
Avatar

Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793
Post Options Post Options   Thanks (0) Thanks(0)   Quote MorningZ Quote  Post ReplyReply Direct Link To This Post Posted: 03 September 2003 at 11:08am

I'd build (and do) a SQL string, a la:

sp_ThisProcThatDoesSomething 'Some String Value', 1, 'Another String'

etc

Contribute to the working anarchy we fondly call the Internet
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.