• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

In ASP.NET i have a grid view for which i have used query builder for Select Statement and a Stored Procedure for update statement. But when i try to update the grid view, it doesn't update it

In ASP.NET i have a grid view for which i have used query builder for Select Statement and a Stored Procedure for update statement. But when i try to update the grid view, it doesn't update it in the tables but doesn't even throw any error. It just remains as it is.

I tried with Forms View too, they dont update. The parameters i used in my stored procedure were taken out of the select statement only, no extra paramters used so no errors.

Its really urgent, i would appreciate any help.
0
nickladdha
Asked:
nickladdha
  • 2
  • 2
2 Solutions
 
Jerry MillerCommented:
Do you have the control that is refreshing the data set to AutoPostBack = True?

http://www.w3schools.com/aspnet/prop_webcontrol_textbox_autopostback.asp

0
 
nickladdhaAuthor Commented:
What control, its a regular grid view which has all the buttons that come with it. The Edit button and after the edit, you see update and cancel/. Once update is pressed, it postsback and the grid view is seen again but with no change,

Kindly reply.
0
 
mayank_joshiCommented:
after update be sure to set the datasource  of gridview once again and call the databind method.
0
 
nickladdhaAuthor Commented:
NOT ACCURATE
0
 
Jerry MillerCommented:
You would have to have something that is triggering the need to refresh, button click, checkbox, or a data change in a textbox. If the gridview is located inside an update panel and the control value is set to AutoPostBack = True, then it will refresh. Of course you have to set the dataset again in the change event (OnClick, OnChange, AfterUpdate, etc) of that control.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now