I have read the forums extensively, as well as am in the middle of 2 C# ASP.NET programming books, and am still running into lots of errors.
I have properly updated the UpdateCommand but no matter what it seems to fail when I try to submit the updates, regardless if in gridview or detailview.
A common error I'm getting is:
Code: Select all
'price' parameter is missing at the statement
Even with simple code I have problems
Code: Select all
Untitled Page
"
ProviderName="" SelectCommand="SELECT `item_id`, `description`, `retail`, `price`, `special` FROM `auction_items`" UpdateCommand="UPDATE auction_items SET price = ?, special = ? WHERE item_id = ? ">
This is just one variation. I have attempted to many that it is rather exhausting and difficult for me to tell you at this point.
The parameter issue is the common problem I am having though. At first I was doing my UpdateCommand statements with SET name=@name type queries, but that wasn't working. I then switched to the question marks after reading a simlar thread, but am still having no luck.
- I am looking to a simple guide for C# users to make the simplest updates, deletions and inserts. Can you please e-mail or PM me this information.
- Any ideas as to what I am doing wrong at this point?
- I would rather interact with the queries one on one, instead of having it all server side, as right now I'm having much problems. I am unable to find any documentaiton on how to run a simple select query and have the result stored to an arraylist. Can I please have some examples.
Thanks for your prompt help.