[ngrosh]

Having a lot of trouble trying to get the update command to work. With the databound controls when I try to update I don't get any response. I also tried to see if I could update with direct inputs in the update command.. but found that only half of my columns were updated and the data wasn't even assigned to the correct columns so I'm not really sure whats going on ;/.

data source and update command code

   <asp:AccessDataSource ID="AccessDataSource1" runat="server" 
                        DataFile="~/App_Data/HandyManTaylor.mdb" 
                        DeleteCommand="DELETE FROM [Customer] WHERE [Customer_ID] = ?" 
                        InsertCommand="INSERT INTO [Customer] ([Customer_ID], [Customer__First_Name], [Customer_Last_Name], [Customer_Address], [Customer_City], [Customer_State], [Customer_Zip], [Customer_Phone], [Customer_Email]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)" 
                        SelectCommand="SELECT * FROM [Customer]" 
                        UpdateCommand="UPDATE [Customer] SET [Customer__First_Name] = @Customer_First_Name, [Customer_Last_Name] = @Customer_Last_Name, [Customer_Address] = @Customer_Address, [Customer_City] = @Customer_City, [Customer_Zip] = @Customer_Zip, [Customer_Phone] = @Customer_Phone, [Customer_Email] = @Customer_Email WHERE [Customer_ID] = @Customer_ID">
                        <DeleteParameters>
                            <asp:Parameter Name="Customer_ID" Type="Int32" />
                        </DeleteParameters>
                        <UpdateParameters>
                            <asp:ControlParameter ControlID="txtFirstName" Name="Customer_First_Name" 
                                PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="txtLastName" Name="@Customer_Last_Name" 
                                PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="txtAddress" Name="@Customer_Address" 
                                PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="txtCity" Name="@Customer_City" 
                                PropertyName="Text" Type="String" />
                  
                            <asp:ControlParameter ControlID="txtZip" Name="@Customer_Zip" 
                                PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="txtPhoneNumber" Name="@Customer_Phone" 
                                PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="txtEmail" Name="@Customer_Email" 
                                PropertyName="Text" Type="String" />
                            <asp:Parameter DefaultValue="1" Name="@Customer_ID" Type="Int32" />
                        </UpdateParameters>
                        <InsertParameters>
                            <asp:Parameter Name="Customer_ID" Type="Int32" />
                            <asp:Parameter Name="Customer_First_Name" Type="String" />
                            <asp:Parameter Name="Customer_Last_Name" Type="String" />
                            <asp:Parameter Name="Customer_Address" Type="String" />
                            <asp:Parameter Name="Customer_City" Type="String" />
                            <asp:Parameter Name="Customer_State" Type="String" />
                            <asp:Parameter Name="Customer_Zip" Type="String" />
                            <asp:Parameter Name="Customer_Phone" Type="String" />
                            <asp:Parameter Name="Customer_Email" Type="String" />
                        </InsertParameters>
                    </asp:AccessDataSource>

code behind

Imports System.Data

Partial Class CustomerInformation
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim dv As DataView = DirectCast(AccessDataSource1.Select(DataSourceSelectArguments.Empty), DataView)

        For Each drv As DataRowView In dv
            txtAddress.Text = drv("Customer_Address").ToString()
            txtCity.Text = drv("Customer_City").ToString
            txtFirstName.Text = drv("Customer__First_Name").ToString
            txtLastName.Text = drv("Customer_Last_Name").ToString
            txtEmail.Text = drv("Customer_Email").ToString
            txtPhoneNumber.Text = drv("Customer_Phone").ToString
            txtZip.Text = drv("Customer_Zip").ToString

        Next

    End Sub


    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        AccessDataSource1.Update()
    End Sub
End Class

full code

Spoiler

[/c<%@ Page Title="" Language="VB" MasterPageFile="~/Assignment5MasterPage.master" AutoEventWireup="false" CodeFile="CustomerInformation.aspx.vb" Inherits="CustomerInformation" %>

<asp:Content ID="Content1" ContentPlaceHolderID="cphHead" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="cphMenu" Runat="Server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="cphRequestForm" Runat="Server">
    <div>
        <table class="TableAlign" id="BillsTable" runat="server" border="0" cellpadding="0" cellspacing="0">
            <tr>
                <td colspan='2' class="InitialTDStyle">
                    <asp:Label ID="lblTitle" runat="server" 
                        Text="CustomerInformation"></asp:Label> 
                    <asp:AccessDataSource ID="AccessDataSource1" runat="server" 
                        DataFile="~/App_Data/HandyManTaylor.mdb" 
                        DeleteCommand="DELETE FROM [Customer] WHERE [Customer_ID] = ?" 
                        InsertCommand="INSERT INTO [Customer] ([Customer_ID], [Customer__First_Name], [Customer_Last_Name], [Customer_Address], [Customer_City], [Customer_State], [Customer_Zip], [Customer_Phone], [Customer_Email]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)" 
                        SelectCommand="SELECT * FROM [Customer]" 
                        UpdateCommand="UPDATE [Customer] SET [Customer__First_Name] = @Customer_First_Name, [Customer_Last_Name] = @Customer_Last_Name, [Customer_Address] = @Customer_Address, [Customer_City] = @Customer_City, [Customer_Zip] = @Customer_Zip, [Customer_Phone] = @Customer_Phone, [Customer_Email] = @Customer_Email WHERE [Customer_ID] = @Customer_ID">
                        <DeleteParameters>
                            <asp:Parameter Name="Customer_ID" Type="Int32" />
                        </DeleteParameters>
                        <UpdateParameters>
                            <asp:ControlParameter ControlID="txtFirstName" Name="Customer_First_Name" 
                                PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="txtLastName" Name="@Customer_Last_Name" 
                                PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="txtAddress" Name="@Customer_Address" 
                                PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="txtCity" Name="@Customer_City" 
                                PropertyName="Text" Type="String" />
                  
                            <asp:ControlParameter ControlID="txtZip" Name="@Customer_Zip" 
                                PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="txtPhoneNumber" Name="@Customer_Phone" 
                                PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="txtEmail" Name="@Customer_Email" 
                                PropertyName="Text" Type="String" />
                            <asp:Parameter DefaultValue="1" Name="@Customer_ID" Type="Int32" />
                        </UpdateParameters>
                        <InsertParameters>
                            <asp:Parameter Name="Customer_ID" Type="Int32" />
                            <asp:Parameter Name="Customer_First_Name" Type="String" />
                            <asp:Parameter Name="Customer_Last_Name" Type="String" />
                            <asp:Parameter Name="Customer_Address" Type="String" />
                            <asp:Parameter Name="Customer_City" Type="String" />
                            <asp:Parameter Name="Customer_State" Type="String" />
                            <asp:Parameter Name="Customer_Zip" Type="String" />
                            <asp:Parameter Name="Customer_Phone" Type="String" />
                            <asp:Parameter Name="Customer_Email" Type="String" />
                        </InsertParameters>
                    </asp:AccessDataSource>
                    <asp:Button ID="Button1" runat="server" Text="Button" />
                 
                </td>
                <td class="ValidationStyle">&nbsp;</td>
            </tr>
            <tr runat="server">
                <td class="LabelStyle">
                   <asp:Label ID="lblFirstName" runat="server" Text="First Name" 
                        CssClass="LabelStyle"></asp:Label>
                </td>
                <td class="TextBoxTDStyle">
                    <asp:TextBox ID="txtFirstName" runat="server" CssClass="TextBoxStyle" ></asp:TextBox>
                </td>
                <td class="ValidationStyle">
                    <asp:RequiredFieldValidator ID="rfvFirstName" runat="server" 
                        ControlToValidate="txtFirstName" 
                        ErrorMessage="First Name must be supplied">*</asp:RequiredFieldValidator>
                </td>
            </tr>
            <tr runat="server" >
                <td class="LabelStyle">
                    <asp:Label ID="lblLastName" runat="server" Text="Last Name" 
                        CssClass="LabelStyle"></asp:Label>
                </td>
                <td class="style3">
                    <asp:TextBox ID="txtLastName" runat="server" CssClass="TextBoxStyle" ></asp:TextBox>
                </td>
                <td class="ValidationStyle">
                    <asp:RequiredFieldValidator ID="rfvLastName" runat="server" 
                        ControlToValidate="txtLastName" ErrorMessage="Last Name must be supplied">*</asp:RequiredFieldValidator>
                </td>
            </tr>
            <tr>
                <td class="LabelStyle">
                    <asp:Label ID="lblAddress" runat="server" Text="Address" CssClass="LabelStyle"></asp:Label>
                </td>
                <td class="TextBoxTDStyle">
                    <asp:TextBox ID="txtAddress" runat="server" CssClass="TextBoxStyle" ></asp:TextBox>
                </td>
                <td class="ValidationStyle">
                    <asp:RequiredFieldValidator ID="rfvAddress" runat="server" 
                        ControlToValidate="txtAddress" ErrorMessage="Address must be supplied">*</asp:RequiredFieldValidator>
                </td>
            </tr>
            <tr>
                <td class="LabelStyle">
                    <asp:Label ID="lblCity" runat="server" Text="City" CssClass="LabelStyle"></asp:Label>
                </td>
                <td class="TextBoxTDStyle">
                    <asp:TextBox ID="txtCity" runat="server" CssClass="TextBoxStyle" ></asp:TextBox>
                </td>
                <td class="ValidationStyle">
                    <asp:RequiredFieldValidator ID="rfvCity" runat="server" 
                        ControlToValidate="txtCity" EnableClientScript="False" 
                        ErrorMessage="City must be supplied">*</asp:RequiredFieldValidator>
                </td>
            </tr>
            <tr>
                <td class="LabelStyle">
                    <asp:Label ID="lblState" runat="server" Text="State" CssClass="LabelStyle"></asp:Label></td>
                <td class="TextBoxStyle">
                    <asp:DropDownList ID="ddlState" runat="server" CssClass="TextBoxStyle">
                        <asp:ListItem>Ohio</asp:ListItem>
                        <asp:ListItem>Kentucky</asp:ListItem>
                        <asp:ListItem>Indiana</asp:ListItem>
                        <asp:ListItem>West Virginia</asp:ListItem>
                    </asp:DropDownList>
                </td>
                <td class="ValidationStyle">
                      <asp:RequiredFieldValidator ID="rfvState" runat="server" 
                        ErrorMessage="State must be supplied" ControlToValidate="ddlState">*</asp:RequiredFieldValidator>
                </td>
            </tr>
            <tr>
                <td class="LabelStyle">
                    <asp:Label ID="lblZipCode" runat="server" Text="Zip Code" CssClass="LabelStyle"></asp:Label>
                </td>
                <td class="TextBoxTDStyle">
                    <asp:TextBox ID="txtZip" runat="server" CssClass="TextBoxStyle" ></asp:TextBox>
                </td>
                <td class="ValidationStyle">
                    <asp:RegularExpressionValidator ID="revZip" runat="server" 
                        ControlToValidate="txtZip" ErrorMessage="Zip Code must be in the proper format" 
                        ValidationExpression="\d{5}(-\d{4})?">*</asp:RegularExpressionValidator>
                    <asp:RequiredFieldValidator ID="rfvZip" runat="server" 
                        ControlToValidate="txtZip" ErrorMessage="Zip Code Must be supplied">*</asp:RequiredFieldValidator>
                </td>
            </tr>
            <tr>
                <td class="LabelStyle">
                    <asp:Label ID="lblPhoneNumber" runat="server" Text="Phone Number" 
                        CssClass="LabelStyle"></asp:Label>
                </td>
                <td class="TextBoxStyle">
                    <asp:TextBox ID="txtPhoneNumber" runat="server" CssClass="TextBoxStyle" ></asp:TextBox>
                </td>
                <td class="ValidationStyle">
                    <asp:RegularExpressionValidator ID="revPhoneNumber" runat="server" 
                        ControlToValidate="txtPhoneNumber" ErrorMessage="Phone Number must be in a valid format" 
                        ValidationExpression="((\(\d{3}\) ?)|(\d{3}-))?\d{3}-\d{4}">*</asp:RegularExpressionValidator>
                    <asp:RequiredFieldValidator ID="rfvPhone" runat="server" 
                        ControlToValidate="txtPhoneNumber" 
                        ErrorMessage="Phone Number must be supplied">*</asp:RequiredFieldValidator>
                </td>
            </tr>
            <tr>
                <td class="LabelStyle">
                    <asp:Label ID="lblEmail" runat="server" Text="Email Address" 
                        CssClass="LabelStyle"></asp:Label>
                </td>
                <td class="TextBoxStyle">
                    <asp:TextBox ID="txtEmail" runat="server" CssClass="TextBoxStyle" 
                        Height="22px" ></asp:TextBox>
                </td>
                <td class="ValidationStyle">
                    <asp:RegularExpressionValidator ID="revEmail" runat="server" 
                        ErrorMessage="Email Address must be in a valid format" 
                        ControlToValidate="txtEmail" 
                        ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*">*</asp:RegularExpressionValidator>
                    <asp:RequiredFieldValidator ID="rfvEmail" runat="server" 
                        ControlToValidate="txtEmail" ErrorMessage="Email Address must be supplied">*</asp:RequiredFieldValidator>
                </td>
            </tr>
     
            <tr runat="server">
                <td class="LabelStyle">
                    <asp:Button ID="btnSubmit" runat="server" Text="Submit" PostBackURL="processcustomerinformation.aspx"
      style="height: 26px" CssClass="TextBoxStyle" />   

                </td>
                <td class="TextBoxTDStyle">
                    <input id="btnReset" class="TextBoxStyle" type="reset" value="Reset" style="height: 26px" />
                </td>
                <td class="ValidationStyle">
                    &nbsp;</td>
            </tr>
        </table>
         </div>

</asp:Content>
<asp:Content ID="Content4" ContentPlaceHolderID="cphCopyRight" Runat="Server">
</asp:Content>