How to Insert by param in VS 2005

P

Paul

Using VS 2005's wizards, I created a DataSet, and 4 sql statements for a Select, Insert, Update and Delete.
The Select statement is something like this:
SELECT ProductName, StoreID, Price, CategoryID, ProductID FROM Products WHERE (StoreID = @StoreID)

(very simple)

HOwever, how do I get the INSERT sttement to insert by StoreID?

On an aspx page, I created a DetailsView and checked Insert, Edit,Delete. I pass it a default StoreID parameter value. But when I view the page in a browser, and I chose to Insert, the StoreID shows up. I thought that that should be constant, the parameter that the user can not change.

How do I make it so that the user can add anything but the storeID, the parameter that was filtering the presentation?



TIA,



Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,994
Messages
2,570,223
Members
46,813
Latest member
lawrwtwinkle111

Latest Threads

Top