I have an ascx file in my project which loads and displays correct data perfectly. However, when I attempt to write data to the DB from the textboxes nothing happens. Here's some sample:

1    <asp:SqlDataSource ID="faxDS" runat="server" ConnectionString="<%$ ConnectionStrings:TimeWSL2ConnectionString %>"
2                    SelectCommand="select fax, faxnotes from contact_fax where contact_fax.FK_fax_contact = @foreignKey"
3                    InsertCommand="Insert into contact_fax(fk_fax_contact, fax, faxnotes) values(@foreignKey, @fax, @faxnotes)"
4                    UpdateCommand="Update contact_fax set fax = @fax, faxNotes = @faxNotes where primkey = @primkey"
5                    DeleteCommand="Delete from contact_fax where primkey = @primkey">
6                        <SelectParameters>
7                             <asp:Parameter Name="foreignKey"    Type="Int64"    />
8                        </SelectParameters>
9                        <InsertParameters>
10                            <asp:Parameter  Name="foreignKey"   Type="Int64"    />
11                            <asp:Parameter Name="fax"          Type="String"   />
12                            <asp:Parameter Name="faxNotes"     Type="String"   />
13                       </InsertParameters>
14                       <UpdateParameters>
15                           <asp:Parameter Name="primkey"       Type="Int64"    />
16                           <asp:Parameter Name="fax"           Type="String"   />
17                           <asp:Parameter Name="faxNotes"      Type="String"   />
18                       </UpdateParameters>
19                       <DeleteParameters>
20                           <asp:Parameter Name="primkey"       Type="Int64"    />
21                       </DeleteParameters>
22                   </asp:SqlDataSource> 
23   
24    
25   
26   <asp:GridView ID="faxGV" runat="server" DataSourceID="faxDS" AutoGenerateColumns="false" OnRowCommand="faxGV_RowCommand1">           
27                       <Columns>                      
28                            <asp:TemplateField>
29                               <ItemTemplate>
30                                  <asp:Button Text="Edit"      CommandName="Edit"      CausesValidation="false"    runat="server" ID="btEdit"   PostBackUrl="~/details.aspx#vg"/>
31                                  <asp:Button Text="Delete"    CommandName="Delete"    CausesValidation="false"    runat="server" ID="btDelete" PostBackUrl="~/details.aspx#vg"/>
32                               </ItemTemplate>
33                               <EditItemTemplate>
34                                  <asp:Button Text="Update"    CommandName="Update"    CausesValidation="true"     runat="server" ID="btUpdate" PostBackUrl="~/details.aspx#vg"/>
35                                  <asp:Button Text="Cancel"    CommandName="Cancel"    CausesValidation="false"    runat="server" ID="btCancel" PostBackUrl="~/details.aspx#vg"/>
36                               </EditItemTemplate>
37                               <FooterTemplate>
38                                  <asp:Button Text="Insert"    CommandName="Insert"    CausesValidation="true"     runat="server" ID="btInsert" PostBackUrl="~/details.aspx#vg"/>
39                                  <asp:Button Text="Cancel"    CommandName="Cancel"    CausesValidation="false"    runat="server" ID="btCancel" PostBackUrl="~/details.aspx#vg"/>
40                               </FooterTemplate>
41                            </asp:TemplateField>
42                               
43                            <asp:TemplateField                 HeaderText="Fax">
44                               <ItemTemplate><asp:Label        ID="lblFax"    runat="server"  Text='<%# Eval("fax") %>'    /></ItemTemplate>
45                               <EditItemTemplate><asp:TextBox  ID="editFax"   runat="server"  Text='<%# Eval("fax") %>'    /></EditItemTemplate>
46                               <FooterTemplate><asp:TextBox    ID="faxInsert" runat="server"                               /></FooterTemplate>
47                            </asp:TemplateField>
48                       </Columns>
49                          
50                           <EmptyDataTemplate>
51                               <asp:Label      ID="lblInsFax"         Text="Fax"                runat="server" /><br />
52                               <asp:TextBox    ID="emptyFaxInsert"                            runat="server" /><br />
53                               <asp:Button     ID="btfaxEmptyInsert"           Text="Insert"    runat="server" CommandName="EmptyInsert"    UseSubmitBehavior="False"   PostBackUrl="~/details.aspx#vg"/>
54                               <asp:Button     ID="btEmptyCancel"      Text="Cancel"    runat="server" CommandName="Cancel"         CausesValidation="false"    PostBackUrl="~/details.aspx#vg"/>
55                           </EmptyDataTemplate>                             
56                   </asp:GridView>
57   
58    
59   
60   Public MustInherit Class contactInfo
61       Inherits System.Web.UI.UserControl
62   
63    
64
65   
66       Protected Sub faxGV_RowCommand1(ByVal sender As Object, ByVal e As GridViewCommandEventArgs)
67   
68           If e.CommandName = "EmptyInsert" Then
69               Try
70   
71                   Dim emptyFaxInsert As TextBox = CType(faxGV.Controls(0).Controls(0).FindControl("emptyFaxInsert"), TextBox)
72                   faxDS.InsertParameters("foreignKey").DefaultValue = foreignKey
73                   faxDS.InsertParameters("fax").DefaultValue = emptyFaxInsert.Text
74                   faxDS.Insert()
75   
76               Catch ex As Exception
77                   ' MsgBox(Err.Description)
78               End Try
79           End If
80   
81           If e.CommandName = "Insert" Then
82               Try
83                   Dim fRow As GridViewRow
84                   fRow = faxGV.FooterRow
85   
86                   Dim FaxInsert As TextBox = CType(fRow.FindControl("insertFax"), TextBox)
87                   faxDS.InsertParameters("foreignKey").DefaultValue = foreignKey
88                   faxDS.InsertParameters("fax").DefaultValue = FaxInsert.Text
89                   faxDS.Insert()
90   
91               Catch ex As Exception
92                   'MsgBox(Err.Description)
93               End Try
94           End If
95   
96           If e.CommandName = "Update" Then
97               Dim index As Integer = faxGV.EditIndex
98               Dim row As GridViewRow = faxGV.Rows(index)
99   
100              Dim editFax As TextBox = CType(row.FindControl("editFax"), TextBox)
101              Try
102                  faxDS.UpdateParameters("fax").DefaultValue = editFax.Text
103              Catch ex As Exception
104                  faxGV.EditIndex = -1
105                  faxGV.DataBind()
106  
107              End Try
108          End If
109  
110          If e.CommandName = "Cancel" Then
111              faxGV.EditIndex = -1
112              faxGV.DataBind()
113          End If
114          faxGV.EditIndex = -1
115          faxGV.DataBind()
116  
117      End Sub 

 Looks correct to me. Check any exceptions are coming. remove msgbox and write Response.write or cosole.writeline()

 Thank you for replying. No errors or exceptions of any kind seem to be occurring.  My debugging skills are quite nascent, however. I should be more clear about what is happening. When I click the insert button a row is created with the correct foreign key value but user entered data is lost.  Response.Write(emptyFaxInsert), for instance, writes nothing to the screen.

Maybe I should mention that, in the calling page, I have in the markup:

 

<asp:Repeater ID="Repeater1" runat="server" >
                    <ItemTemplate>
                        <tr><uc1:contactInfo2 ID="ContactInfo2" runat="server" 
                        contactName='<%# DataBinder.Eval(Container.DataItem, "contact_name") %>'
                        foreignKey=' <%# DataBinder.Eval(Container.DataItem, "primkey")      %>'/>
                    </tr></ItemTemplate>
                </asp:Repeater>

Dim IDs As IEnumerable = ContactDS.Select(DataSourceSelectArguments.Empty)
        Repeater1.DataSource = IDs
        Repeater1.DataBind()