January 13, 2011 at 10:02 am
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.
ListBox1ListBox2
View1Expression1
Expression2
Expression3
Expression4
My requirement is I need a stored procedure to insert those listbox items into a table.
Table should like as below...
View NameExpressions Name
View1 Expression1
View1 Expression2
View1 Expression3
View1 Expression4
Pls. provide me a solution
Thanks in Advance.
January 13, 2011 at 11:10 am
Well, I would suggest learning to write stored procs from one of the useful resources out there and/or hiring a consultant.
I would offer one free piece of advice however, this table definition...
View Name Expressions Name
View1 Expression1
View1 Expression2
View1 Expression3
View1 Expression4
Is not a good design, anytime you have something in a table that looks like an array odds are you are violating 3rd normal form.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply