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>
<asp:Link Button ID="UpdateButto n" runat="server"
CausesValidatio n="True"
CommandName="Up date" Text="Update" />
<asp:Link Button ID="UpdateCance lButton"
runat="server"
CausesValidatio n="False" CommandName="Ca ncel"
Text="Cancel" />
</EditItemTemplat e>
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>
<asp:Link Button ID="UpdateButto n" runat="server"
CausesValidatio n="True"
CommandName="Up date" Text="Update" />
<asp:Link Button ID="UpdateCance lButton"
runat="server"
CausesValidatio n="False" CommandName="Ca ncel"
Text="Cancel" />
</EditItemTemplat e>