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 |
|
rajeshnrh74
Starting Member
5 Posts |
 Posted - 2011-01-13 : 12:27:50
|
| Genius,Am developing an ASP.net based Web appln. with SQL Server 2008 as my backend.In aspx page I have 2 listbox controls as below.ListBox1 ListBox2View1 Expression1 Expression2 Expression3 Expression4My requirement is I need a stored procedure to insert those listbox items into a table.Table should like as below...View Name Expressions NameView1 Expression1View1 Expression2View1 Expression3View1 Expression4Pls. provide me a solutionThanks in Advance. |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-01-13 : 17:45:43
|
| SQL cannot see your controls. Your web application needs to extract the data from the controls and pass the data down to the database.=======================================Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986) |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-16 : 06:01:25
|
| in your front end app pass the selected values in listbox etc as a parameter to sql. write a procedure in sql accepting the parameter and returning you the result.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SP to Insert