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.

 All Forums
 Development Tools
 ASP.NET
 Putting a Variable in a Sql Parameter?

Author  Topic 

davidshq
Posting Yak Master

119 Posts

Posted - 2005-06-10 : 16:28:00
In ASP.NET 2.0 you can use things like SelectParameters to tell SQL Server about variables, etc. that are in the program but not actually in the database. So, a user enters the number 10 in a textbox, you can create a ControlParameter that picks this up and creates a variable such as @NumberofIceCreamBarstoEat that can be used by SQL Server. My question is, what if you have a local variable, one that operates only in a Sub. Is there an easy way to assign this as a Parameter?
David.

- http://www.civilwarsearch.com/
- http://www.thehungersite.com/
- http://www.grid.org/
   

- Advertisement -