Problem with GridView RowCommand firing twice

[jondow]

Hi,
Im using VS2005 with VB.NET 2.0 in an ASP.NET website.

I have a gridview with a button:

<asp:ButtonField Text="Sort Up" CommandName="SortUp" ButtonType="Image" HeaderText="Order" ImageUrl="~/images/Arrow.jpg" />

The button fires the rowcommand with the command name SortUp which is as follows:

Protected Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridView1.RowCommand
If e.CommandName = "SortUp" Then
'if the sortup command button has been pressed then increase the sortorder field

'Convert the row index stored in the CommandArgument property to an Integer.
Dim index As Integer = Convert.ToInt32(e.CommandArgument)

'Retrieve the row ID that contains the button clicked by the user from the Rows collection.
Dim row = GridView1.DataKeys(index).Value

Dim strConn As String = ConfigurationManager.ConnectionStrings("con").ConnectionString
Dim con As Data.SqlClient.SqlConnection = New Data.SqlClient.SqlConnection(strConn)

Try

Dim cmd1 As New Data.SqlClient.SqlCommand("usp_SortOrderShift", con)
cmd1.CommandType = Data.CommandType.StoredProcedure
'add the static parameters
cmd1.Parameters.AddWithValue("@id", row)

'Open the connection & execute the procedure
con.Open()
cmd1.ExecuteNonQuery()
con.Close()



Catch ex As Exception
Label7.Text = ex.ToString
End Try

GridView1.DataBind()

End If

End Sub



My problem is that when I click the button the stored procedure is executed twice (ie the rowcommand is fired twice) - I have no idea why? Can anyone suggest a reason?

Thanks!

 

[ca8msm]

You've found a strange bug that was confirmed in 2.0 and (I think) fixed in version 3.5 of the framework. To get around the problem, change the ButtonType to a Link, and add an image element to the Text property e.g.

<asp:ButtonField ButtonType="Link" Text="&lt;img src='images/delete.gif' class='borderLess' /&gt;" ItemStyle-Width="20px"  />

-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[jondow]

Thank you Mark, I have spent ages trying to work that one out!