GridView RowUpdating event not firing

[John007]

I am using a SQLDataSource to populate my gridview in ASP.Net 2.0. When I hit Edit, the textboxes appear and I am able to edit my values. When I hit Update, the changes are not saved, and there is no error message. I put a breakpoint on the RowUpdating event handler and found that the event is not fired. Right now, I have not written code for the Update event. I am just wondering why the event is not firing. Here Person_ID is the primary key. Please help. Thanks.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:BoundField DataField="PERSON_ID" HeaderText="ID" />
<asp:BoundField DataField="YEAR" HeaderText="Year" />
</Columns>
</asp:GridView>
 

'in code behind

 Private Sub BindGrid()
 GridView1.DataSource = GetData(iID, iYear)
 GridView1.DataBind()
 End Sub
 
 
Protected Sub GridView1_RowEditing(ByVal sender As Object, ByVal e As GridViewEditEventArgs) Handles GridView1.RowEditing
GridView1.EditIndex = e.NewEditIndex
BindGrid()
End Sub
 
Protected Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As GridViewUpdateEventArgs) Handles GridView1.RowUpdating
'handle Update here
End Sub
 

[Frinavale]

I am using a SQLDataSource to populate my gridview in ASP.Net 2.0. When I hit Edit, the textboxes appear and I am able to edit my values. When I hit Update, the changes are not saved, and there is no error message. I put a breakpoint on the RowUpdating event handler and found that the event is not fired. Right now, I have not written code for the Update event. I am just wondering why the event is not firing. Here Person_ID is the primary key. Please help. Thanks.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:BoundField DataField="PERSON_ID" HeaderText="ID" />
<asp:BoundField DataField="YEAR" HeaderText="Year" />
</Columns>
</asp:GridView>
 

'in code behind

 Private Sub BindGrid()
 GridView1.DataSource = GetData(iID, iYear)
 GridView1.DataBind()
 End Sub
 
 
Protected Sub GridView1_RowEditing(ByVal sender As Object, ByVal e As GridViewEditEventArgs) Handles GridView1.RowEditing
GridView1.EditIndex = e.NewEditIndex
BindGrid()
End Sub
 
Protected Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As GridViewUpdateEventArgs) Handles GridView1.RowUpdating
'handle Update here
End Sub
 

Did you put the break point at line 12 in the "code behind"?
I see no reason why this would not fire.

You cannot put a break point inside that function because there is nothing to break on.

-Frinny

[John007]

Thanks for your reply.

Yes, I did put the breakpoint at the RowUpdating line (and not in the function). In the RowEditing function, the edit textboxes appear and I can get the "old" values Then the page renders, I edit the textboxes and hit Update. Then the page posts back, the text boxes go back to being labels and the new values are lost, and the RowUpdating code never fires.

[Frinavale]

Thanks for your reply.

Yes, I did put the breakpoint at the RowUpdating line (and not in the function). In the RowEditing function, the edit textboxes appear and I can get the "old" values Then the page renders, I edit the textboxes and hit Update. Then the page posts back, the text boxes go back to being labels and the new values are lost, and the RowUpdating code never fires.

You have to make sure that you aren't setting your GridView's data when it is not postback. If you do this, your GridView's source will be refreshed before you're able to grab the new values out of it.

I'm having a very hard time understand what would prevent your event from being fired. Do you have some sort of JavaScript functionality that may be stopping it?

-Frinny

[John007]

Frinny, it was a post-back, binding issue after all! Thanks for your reply.

[jcp001]

Hi all,

I seem to be having the same issue but I don't quite follow the trouble with the above post. Sorry, I'm a newbie on this application. Can you explain the T/S a little more or maybe point me to another post that may have already covered it?

Any help would greatly be appreciated!!!

[Frinavale]

Hi all,

I seem to be having the same issue but I don't quite follow the trouble with the above post. Sorry, I'm a newbie on this application. Can you explain the T/S a little more or maybe point me to another post that may have already covered it?

Any help would greatly be appreciated!!!

Hi JCP!

A common problem people have with GridViews is understanding when to data bind the data source to the GridView.

It's quite common that people create the data source and bind this source to the GridView in their Page_Load() method.

What happens with this is that the source is being created every time the user submits the page.

This means that when the user does an update, the data from that update is lost.

You should create your data source once (on the user's first visit) and store it into Session for later use, and only bind the GridView to the data source when it is necessary to do so.

I would recommend trying this out and starting a new thread in the .NET Forum so that other people can learn from the experience too.

:)

Cheers!

-Frinny

[rubin8083]

Check if you have put any validators on your page. Because the page will not go for post back until all validators are validated.

[smkowalczyk]

You may need to turn off validation even if you are not validating anything. It seems like the JavaScript can get mangled otherwise.

If you are using command buttons, then do not use AutoGenerateEdi tButton.

<asp:CommandField ShowEditButton="true" ButtonType="Link" 
CausesValidation="false" />

[jpl0509]

For others with this issue, try:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
       GridView.DataSource = DataSource1
       GridView.DataBind()
    End If[/indent]End Sub