Updating database using gridview
I have a SQL datasource which performs a join on multiple tables which is displayed through a gridview. So if you try to also define extra parameters, you will be passing too many.I would like to be able to edit the columns but can't figure out how to do an update on multiple tables at once. Also, using the refresh parameters button within the datasource wizard will create a parameter for a return value even if your stored procedure does not define one, so if your stored procedure does not have a return value you should remove this parameter.By Default, Grid View control displays Item Template which directly shows the Product Name and Unit Price columns but when user clicks Edit button Grid View automatically switches to Edit Item Template and display the control available inside Edit Item Template for user editing.Now I will show you the C# code behind file of the above ASP.
It enables you to select, sort, and edit these items.Here is an article on how to troubleshoot ' Procedure or function has too many arguments specified' in 2.0: Link,guid,ee69ddf8-3096-4818-abdb-0542d2fc191NOTE: If you find my response contains a reference to a third party World Wide Web site, I am providing this information as a convenience to you.Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality,safety, or suitability of any software or information found there.__________________________________________________Sincerely, Young Fang Microsoft Online Community Support Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question.In this tutorial I will show you how you can create an editable Grid View control for administrators to modify database records directly into the Grid View control.Editing the Grid View control can be an incredibly easy feature to add for certain database tables, especially those who have no foreign key associated and can easily be edited through the use of a standard Text Box web control as shown in the figure below: Before we start examining the ASP.