Formview not updating data correctly

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Cirene

    Formview not updating data correctly

    I have a formview that is calling a stored procedure (thru an sqldatasource)
    to update 2 tables. When I execute the update it runs fine, with no errors.
    But the data does NOT change. Any ideas why?

    Here's the stored proc, the datasource and the edit template of the
    formview...

    *************** STORED PROC*********** ********
    ALTER PROCEDURE dbo.UpdateCompa nyUsers
    (
    @UserId uniqueidentifie r,
    @CompanyUserId int,
    @CompanyId int,
    @FirstName nvarchar(MAX),
    @LastName nvarchar(MAX),
    @Phone nvarchar(MAX),
    @Phone2 nvarchar(MAX),
    @Fax nvarchar(MAX),
    @Email nvarchar(MAX)
    )
    AS

    BEGIN
    UPDATE CompanyUsers
    SET
    CompanyId=@Comp anyId,
    FirstName=@Firs tName,
    LastName=@LastN ame,
    Phone=@Phone,
    Phone2=@Phone2,
    Fax=@Fax
    WHERE (CompanyUserId = @CompanyUserId)

    UPDATE dbo.aspnet_Memb ership WITH (ROWLOCK)
    SET
    Email = @Email,
    LoweredEmail = LOWER(@Email)
    WHERE
    @UserId = UserId

    RETURN
    END

    *************** *SQL DATA SOURCE********* ***********
    <asp:SqlDataSou rce ID="sdsUser" runat="server"
    ConnectionStrin g="<%$ ConnectionStrin gs:ConnectionSt ring %>"
    :
    UpdateCommand=" UpdateCompanyUs ers"
    UpdateCommandTy pe="StoredProce dure">
    :
    <UpdateParamete rs>
    <asp:Paramete r Name="UserId" />
    <asp:Paramete r Name="CompanyUs erId" Type="Int32" />
    <asp:Paramete r Name="CompanyId " Type="Int32" />
    <asp:Paramete r Name="FirstName " Type="String" />
    <asp:Paramete r Name="LastName" Type="String" />
    <asp:Paramete r Name="Phone" Type="String" />
    <asp:Paramete r Name="Phone2" Type="String" />
    <asp:Paramete r Name="Fax" Type="String" />
    <asp:Paramete r Name="Email" Type="String" />
    </UpdateParameter s>
    </asp:SqlDataSour ce>

    *************** ****FORM VIEW EDIT TEMPLATE******* ***************
    <EditItemTempla te>
    <table class="style1">
    <tr>
    <td class="style2">
    Company:</td>
    <td>
    <telerik:RadCom boBox ID="RadComboBox 1"
    Runat="server"
    DataSourceID="s dsCompanies"
    DataTextField=" CompanyName"
    DataValueField= "CompanyId"
    SelectedValue=' <%# Bind("CompanyId ") %>'>
    <CollapseAnimat ion Duration="200"
    Type="OutQuint" />
    </telerik:RadComb oBox>
    </td>
    </tr>
    <tr>
    <td class="style2">
    First Name:</td>
    <td>
    <asp:TextBox ID="FirstNameTe xtBox"
    runat="server"
    Text='<%# Bind("FirstName ") %>' />
    </td>
    </tr>
    <tr>
    <td class="style2">
    Last Name:</td>
    <td>
    <asp:TextBox ID="LastNameTex tBox"
    runat="server"
    Text='<%# Bind("LastName" ) %>' />
    </td>
    </tr>
    <tr>
    <td class="style2">
    Phone:</td>
    <td>
    <asp:TextBox ID="PhoneTextBo x"
    runat="server" Text='<%# Bind("Phone") %>' />
    </td>
    </tr>
    <tr>
    <td class="style2">
    Phone2:</td>
    <td>
    <asp:TextBox ID="Phone2TextB ox"
    runat="server" Text='<%# Bind("Phone2") %>' />
    </td>
    </tr>
    <tr>
    <td class="style2">
    Fax:</td>
    <td>
    <asp:TextBox ID="FaxTextBox " runat="server"
    Text='<%# Bind("Fax") %>' />
    </td>
    </tr>
    <tr>
    <td class="style2">
    Email:</td>
    <td>
    <asp:TextBox ID="EmailTextBo x"
    runat="server" Text='<%# Bind("Email") %>' />
    </td>
    </tr>
    <tr>
    <td class="style2">
    <asp:Label ID="CompanyUser IdLabel1"
    runat="server"
    Text='<%# Eval("CompanyUs erId") %>'
    Visible="False" />
    </td>
    <td>
    <asp:Label ID="Label1" runat="server"
    Text='<%# Eval("UserId") %>'
    Visible="False" ></asp:Label>
    </td>
    </tr>
    </table>
    &nbsp;<asp:Link Button ID="UpdateButto n" runat="server"
    CausesValidatio n="True"
    CommandName="Up date" Text="Update" />
    &nbsp;<asp:Link Button ID="UpdateCance lButton"
    runat="server"
    CausesValidatio n="False" CommandName="Ca ncel"
    Text="Cancel" />
    </EditItemTemplat e>


Working...