471,338 Members | 993 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,338 software developers and data experts.

Procedure or function has too many arguments specified

It seems other people have had this problem, but none of the solutions
proposed fixes my situation. If someone could review the code below
and tell me what I'm missing. Thank you!
<asp:FormView id="LogText" DataKeyNames="LogID" runat="server"
DataSourceID="dsEdit" DefaultMode="Edit">
<EditItemTemplate>
<asp:TextBox id="editText" runat="server" Text='<%#
Bind("LogText") %>' rows="25" columns="120" TextMode="MultiLine" />
<asp:Button Text="Save" CommandName="Update"
runat="server" />
</EditItemTemplate>
</asp:FormView>

<asp:SqlDataSource ID="dsEdit" runat="server"
ConnectionString="Data Source=(local);Initial
Catalog=testDB;Integrated Security=True"
ProviderName="System.Data.SqlClient" SelectCommand="usp_admin_edit"
UpdateCommand="usp_admin_update" SelectCommandType="StoredProcedure"
UpdateCommandType="StoredProcedure"
OldValuesParameterFormatString="{0}">
<UpdateParameters>
<asp:Parameter name="id" Type="Int32" />
<asp:ControlParameter name="strLog"
ControlID="LogText$editText" PropertyName="Text" Type="String" />
</UpdateParameters>

<SelectParameters>
<asp:QueryStringParameter DefaultValue="0" Name="id"
QueryStringField="LogID" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>


CREATE PROCEDURE [dbo].[usp_admin_update]
@id int,
@strLog text

AS
UPDATE tbl_Test
SET

LogText = @strLog
WHERE LogID = @id

Jul 22 '05 #1
0 3608

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Penn Markham | last post: by
3 posts views Thread by Justin | last post: by
1 post views Thread by Child | last post: by
9 posts views Thread by Leedrick | last post: by
reply views Thread by David Lozzi | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.