Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: .NET4
Hi,
I want to set value to stored procedure from code behind. I know how to set parameter value individually. But in this case, i am not aware of number of parameters of stored procedure also not aware of name of parameters. I am aware of stored procedure only. How can i acheive this?
please help me. thanks in advance
Posted 16-Sep-12 21:10pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

First you have to get a list of the parameters. Some methods are shown in e.g. http://stackoverflow.com/questions/3038364/get-stored-procedure-parameters-by-either-c-sharp-or-sql[^]
Then you can iterate thru the list and supply the appropriate values.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 mhegazy94 460
1 Sergey Alexandrovich Kryukov 430
2 Ravi Bhavnani 190
3 Kornfeld Eliyahu Peter 185
4 Shemeemsha RA 160
0 Sergey Alexandrovich Kryukov 7,135
1 OriginalGriff 6,801
2 CPallini 5,350
3 George Jonsson 3,619
4 Gihan Liyanage 2,797


Advertise | Privacy | Mobile
Web02 | 2.8.140922.1 | Last Updated 17 Sep 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100