<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="OverwriteChanges"
    ConnectionString="Data Source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
    DeleteCommand="DELETE FROM [aspnet_Membership] WHERE [UserName] =@original_UserName AND [FirstName]= @original_FirstName AND [LastName]= @original_LastName"
    OldValuesParameterFormatString="original_{0}"
    SelectCommand="SELECT * FROM [aspnet_Membership]"

    UpdateCommand="UPDATE [aspnet_Membership] SET [FirstName] = @FirstName, [LastName] = @LastName, [Company] = @Company, [PartsList] = @PartsList,
                  [UserName] = @UserName, [PasswordQuestion] = @PasswordQuestion, [PasswordAnswer] = @PasswordAnswer, [Role] = @Role, [Comment] =@Comment
                  WHERE [FirstName] = @original_FirstName AND [LastName] = @original_LastName AND [Company] = @original_Company AND
                  [PartsList] = @original_PartsList AND [UserName] = @original_UserName AND [PasswordQuestion] = @original_PasswordQuestion AND
                  [PasswordAnswer] = @original_PasswordAnswer AND [Role] = @original_Role AND [Comment] =@original_Comment">
       <UpdateParameters>
            <asp:Parameter Name="FirstName" Type="String" />
            <asp:Parameter Name="LastName" Type="String" />
            <asp:Parameter Name="Company" Type="String" />
            <asp:Parameter Name="PartsList" Type="String" />
            <asp:Parameter Name="UserName" Type="String" />
            <asp:Parameter Name="Password" Type="String" />
            <asp:Parameter Name="Email" Type="String" />
            <asp:Parameter Name="PasswordQueston" Type="String" />
            <asp:Parameter Name="PasswordAnswer" Type="String" />
            <asp:Parameter Name="Role" Type="String" />
            <asp:Parameter Name="Comment" Type="String" />
            <asp:Parameter Name="original_FirstName" Type="String" />
            <asp:Parameter Name="original_LastName" Type="String" />
            <asp:Parameter Name="original_Company" Type="String" />
            <asp:Parameter Name="original_PartsList" Type="String" />
            <asp:Parameter Name="original_UserName" Type="String" />
            <asp:Parameter Name="original_Password" Type="String" />
            <asp:Parameter Name="original_Email" Type="String" />
            <asp:Parameter Name="original_PasswordQuestion" Type="String" />
            <asp:Parameter Name="original_PasswordAnswer" Type="String" />
            <asp:Parameter Name="original_Role" Type="String" />
            <asp:Parameter Name="original_Comment" Type="String" />
       </UpdateParameters>
       <DeleteParameters>
            <asp:Parameter Name="original_FirstName" Type="String" />
            <asp:Parameter Name="original_LastName" Type="String" />
            <asp:Parameter Name="original_Company" Type="String" />
            <asp:Parameter Name="original_PartsList" Type="String" />
            <asp:Parameter Name="original_UserName" Type="String" />
            <asp:Parameter Name="original_Password" Type="String" />
            <asp:Parameter Name="original_Email" Type="String" />
            <asp:Parameter Name="original_PasswordQuestion" Type="String" />
            <asp:Parameter Name="original_PasswordAnswer" Type="String" />
            <asp:Parameter Name="original_Role" Type="String" />
            <asp:Parameter Name="original_Comment" Type="String" />
    </DeleteParameters>
</asp:SqlDataSource>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
        DataSourceID="SqlDataSource1" AllowPaging="True"
        AllowSorting="True" DataKeyNames="UserId" Caption="Select User"
        onselectedindexchanged="GridView1_SelectedIndexChanged"
        ToolTip="Select a user to view details about the selected user">
        <Columns>
            <asp:CommandField ShowSelectButton="True" />
            <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
            <asp:BoundField DataField="LastName" HeaderText="Last Name"
                SortExpression="LastName" />
            <asp:BoundField DataField="FirstName" HeaderText="First Name"
                SortExpression="FirstName" />
            <asp:BoundField DataField="UserName" HeaderText="User Name"
                SortExpression="UserName" />
            <asp:BoundField DataField="Company" HeaderText="Company"
                SortExpression="Company" />
            <asp:BoundField DataField="PartsList" HeaderText="Parts List"
                SortExpression="PartsList" />
            <asp:BoundField DataField="Role" HeaderText="Role" SortExpression="Role" />
        </Columns>
        <SelectedRowStyle BackColor = "Yellow" />
    </asp:GridView>