Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2006-06-28 : 19:48:21
|
| any VB example for using reflection to build sqlparameters automatically in the code from a SProcThanks a lot |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-06-28 : 20:15:00
|
| Can you be more specific as to what you are looking for? |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-06-29 : 11:26:10
|
| Are you asking if a vb code could ask a SP what it's parameters are...before filling them in?If so...yes. I've seen an example of same (somewhere) before here. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-06-29 : 11:43:39
|
| The sqlcommmandbuilder class has a static method that will add the parameters from a stored procedure to a command.example:sqlCommand cm = new sqlCommand( .....);SqlCommandBuilder.DeriveParameters(cm);Now the Parameters() property of the command contains the parameters. |
|
|
|
rtutus
Aged Yak Warrior
522 Posts |
|
|
|
|
|
any VB example for using reflection to build sqlpa