Hi All

I have both the Beginning & Professional ASP.Net2 books with me and have no problem using the Gridview and SQLDatasource using VWD's help. But what I am looking to do now is create a commandfield button within the GridView that triggers an event which ultimately performs a stored procedure through the SQLDataSource.

The reason being is that I have 2 Gridviews which have seperate SQLDataSources as they point to different tables and I am wanting to DELETE a Selected row from Table1's Gridview and INSERT into Table2's Gridview.

The way I thought I could do this is that each Gridview when selecting a row's command button would trigger an event which manually performs their SQLDatasource's Stored Procedure. But I am really not sure on the Syntax at all.

If you could point me in the direction of a good site or your knowledge, that would be great.

Rit

__________________
Rit
www.designandonline.co.uk
INSPIRE | CREATE | DELIVER

Create a button column. Set the command name property (Ex "MyCommand"). Then use the RowCommand event of the grid:

    Protected Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs ) Handles GridView1.RowCommand
        If e.CommandName = "MyCommand" Then
         ...Do your stuff here

        End If
    End Sub

Jim