Command And Parameter [Visual Web Developer 2005]

[+John Teacake MVC]

Hey People, Long time since ive posted in here. I have a little problem. For those of you who are familiar with the Microsoft Visual Web Developer tool I have a question to ask. For those who aren?t familiar with the tool I really suggest you take a look at it. Just a quick Google search away. It?s a free download from Microsoft and really handy for rapid development of webpage?s etc. Anyway as for my problem, here goes.

On my page I have several text boxes and I want to insert them into an SQL backend table (On the click of a button, But that work:pok :p ). I?m just taking a guess here and trying to use the feature as shown below. How do I use it because I?ve done all the obvious things but when it inserts the values into the table it just inserts the name of the parameter instead of the value from the textbox, if that makes sense? So if I had a parameter called "Description" that was linked to "TxtDescription" It would insert the value "Description" Into every record in the SQL table rather than the value in the text box. Can anyone shed any light please! Any help would be greatly appreciated.

[azcodemonkey]

Are you trying to insert or update? Insert should just insert a new row with your value. Update is going to update every row, unless you differentiate in your where clause.

I have a stored proc that takes all those params. If the productId is null or 0, it performs an insert, otherwise, it takes that productId and applies an update where the row has an equivalent productId.

Edited June 15, 2006 by weenur