hello - trying to forrest gump my way though a simple webdatagrid with the option to add a row.  the row adding seems to work (as does the row deleting - although we receive a Async request failed with a keynotfoundexception).  not sure why this is happending.  here is my markup and code behind:

 

  

<asp:ScriptManager ID="ScriptManager1" runat="server">

       

</asp:ScriptManager>

   

    

<asp:SqlDataSource ID="ds_Parts" runat="server"

       

ConnectionString="<%$ ConnectionStrings:CustomQuoteConnectionString %>"

       

SelectCommand="select * from PartMasterRelatedParts inner join partmaster on partmaster.partnumber = PartMasterRelatedParts.OriginalPartNumber  where PartMasterRelatedParts.OriginalPartNumber = @id"

        

SelectCommandType="Text"

         

InsertCommand="insert into PartMasterRelatedParts (OriginalPartNumber,RelatedPartNumber) values (@OriginalPartNumber, @RelatedPartNumber) "

        

InsertCommandType="Text"

       

DeleteCommand="delete from PartMasterRelatedParts where RelatedPartID = @RelatedPartID"

       

DeleteCommandType="Text" >

       

<SelectParameters>

           

<asp:QueryStringParameter Name="ID" QueryStringField="ID" />

       

</SelectParameters>

        

<InsertParameters >

            

<asp:Parameter Name="OriginalPartNumber" Type="String" />

           

<asp:Parameter Name="RelatedPartNumber" Type="String"/>

           

       

</InsertParameters>

       

<DeleteParameters>

             

<asp:Parameter Name="RelatedPartID" Type="Int32" />

       

</DeleteParameters>

    

</asp:SqlDataSource>

    

<p>

       

<asp:HyperLink ID="HyperLink1" runat="server"><<== back to part</asp:HyperLink>

      

</p>

      

      

<p></p>

      

        

<ig:WebDataGrid ID="WebDataGrid1" runat="server" Width="96%" AutoGenerateColumns="False"

            

DataSourceID="ds_Parts"  DataKeyFields="RelatedPartID"

            

OnRowAdding="WebDataGrid1_RowAdding" 

            

OnRowDeleted="WebDataGrid1_RowDeleting"    >

       

<Columns>

          

               

<ig:BoundDataField DataFieldName="RelatedPartID" Key="RelatedPartID" Hidden="true"></ig:BoundDataField>

            

<ig:BoundDataField DataFieldName="RelatedPartNumber" Key="RelatedPartNumber">

               

<Header Text="Related Part #" />

           

</ig:BoundDataField>

            

<ig:BoundDataField DataFieldName="Description" Key="Description">

               

<Header Text="Description" />

           

</ig:BoundDataField>

       

         

</Columns>

            

<Behaviors>

                

<ig:EditingCore>

                    

<Behaviors>

                        

<ig:CellEditing>

                        

</ig:CellEditing>

                        

<ig:RowAdding >

                                

<EditModeActions MouseClick="Single" />

                       

</ig:RowAdding>

                        

<ig:RowDeleting />

                    

</Behaviors>

                

</ig:EditingCore>

                

<ig:Selection CellClickAction="Row" RowSelectType="Single">

                

</ig:Selection>

                

<ig:RowSelectors>

                

</ig:RowSelectors>

                

<ig:Sorting>

                

</ig:Sorting>

            

</Behaviors>

      

</ig:WebDataGrid>

 

===================

=================== here is the code-behind

===================

Imports

System.Web.UI.Page

Imports

System

Imports

System.Data

Imports

System.Configuration

Imports

System.Web

Imports

System.Web.Security

Imports

System.Web.UI

Imports

System.Web.UI.WebControls

Imports

System.Web.UI.WebControls.WebParts

Imports

System.Web.UI.HtmlControls

Imports

System.Data.SqlClient

Imports

System.Web.Configuration

Imports

Infragistics.Web.UI.GridControls

　

Partial

Class Parts_relatedParts

   

Inherits System.Web.UI.Page

   

Sub Page_Load(ByVal Sender As Object, ByVal E As EventArgs) Handles Me.Load

        HyperLink1.NavigateUrl =

"/parts/editpart.asp?id=" & Request.QueryString("ID")

        HyperLink1.Target =

"_parent"

   

End Sub

   

Protected Sub WebDataGrid1_RowAdding(ByVal sender As Object, ByVal e As Infragistics.Web.UI.GridControls.RowAddingEventArgs) Handles WebDataGrid1.RowAdding

       

Dim Conn As New SqlConnection(ConfigurationManager.ConnectionStrings("CustomQuoteConnectionString").ConnectionString)

       

Dim cmd As SqlCommand

       

Dim strSQL As String

        strSQL =

"insert into PartMasterRelatedParts (OriginalPartNumber,RelatedPartNumber) values (" & _

               

"'" & Request.QueryString("ID") & "', " & _

               

"'" & e.Values("RelatedPartNumber") & "') "

        cmd =

New SqlCommand(strSQL, Conn)

        cmd.CommandType =

CommandType.Text

        Conn.Open()

        cmd.ExecuteNonQuery()

        Conn.Close()

       

'Response.Redirect("/parts/editpart.asp?ID=" & Request.QueryString("ID"))

   

End Sub

   

Protected Sub WebDataGrid1_RowDeleting(ByVal sender As Object, ByVal e As Infragistics.Web.UI.GridControls.RowDeletedEventArgs) Handles WebDataGrid1.RowDeleted

       

Dim Conn As New SqlConnection(ConfigurationManager.ConnectionStrings("CustomQuoteConnectionString").ConnectionString)

       

Dim cmd As SqlCommand

       

Dim strSQL As String

        strSQL =

"delete from PartMasterRelatedParts where RelatedPartID = " & _

               

"'" & e.RowID("RelatedPartID")

　

        cmd =

New SqlCommand(strSQL, Conn)

        cmd.CommandType =

CommandType.Text

        Conn.Open()

        cmd.ExecuteNonQuery()

        Conn.Close()

   

End Sub

End

Class

not sure what i am doing wrong - any help would be appreciated.

 

thanks!