MS SQL Server :: Gridview / SqlDataSource Error - Procedure Or Function &<stored Procedure Name&> Has Too Many Arguments Specified.

Procedure Or Function Sp_AddDealer Has Too Many Arguments Specified (error Via SqlDataSource)
Procedure or function sp_AddDealer has too many arguments specified.
I am experiencing the 'too many arguments specified' error. I am running on SQL 2005. The Parameters lists on SQL server (when I view a dropdown under the sp name) shows a 'returns integer' (but without the @ the signifies a parameter).I have looked around the forums and haven't seen quite this flavor of this error. My forehead is sore from beating it against the wall... any clue would be appreciated!
The error occurs when I click the 'new' link button, enter some data and then click the update link button after ... BOOM - Procedure or function sp_AddDealer has too many arguments specified.
Thanks!!
Chip Kigar
Here is the stored Procedure:

set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgo
ALTER PROCEDURE [dbo].[sp_AddDealer] @sCarcareSystem varchar(100), @sDealerName varchar(50), @sDealerPhysAddrStreet varchar(200), @sDealerPhysAddrCity varchar(100), @sDealerPhysAddrState varchar(10), @sDealerPhysAddrZip varchar(20), @nReturnCode bigint output, @nReturnId bigint output AS
SET NOCOUNT ON  DECLARE @m_nCt bigint  SET @nReturnCode = 0 SET @nReturnId = 0
-- VALIDATE IF (@nReturnCode = 0) BEGIN  SELECT   @m_nCt = COUNT(tblDealers.[_DealerId])   FROM    tblDealers    WHERE   [Dealer Name] = @sDealerName   IF (@m_nCt >0)  BEGIN   SET @nReturnCode = -2000 --'Error for exsiting Dealer'   SET @nReturnId = 0  END END
-- PROCESS IF (@nReturnCode = 0) BEGIN  SET @nReturnCode = -2 --' Error getting new record id'  DECLARE @m_nNewRecId bigint  SET @m_nNewRecId = 0  EXEC sp_GetNewRecId @m_nNewRecId output  IF (@m_nNewRecId > 0)  BEGIN   SET @nReturnCode = -1 --'Error adding Dealer'   INSERT INTO     tblDealers    (    [_DealerId],    [Carcare System],    [Dealer Name],    [Dealer Phys Addr Street],    [Dealer Phys Addr City],    [Dealer Phys Addr State],    [Dealer Phys Addr Zip]    )    VALUES    (    @m_nNewRecId,    @sCarcareSystem,    @sDealerName,    @sDealerPhysAddrStreet,    @sDealerPhysAddrCity,    @sDealerPhysAddrState,    @sDealerPhysAddrZip    )    SET @nReturnCode = 0 --'Success'   SET @nReturnId = @m_nNewRecId
   END  END

Here is the SQLDataSource. I plugged the ID parameter, so I got a schema back, but no data.

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"        InsertCommand="sp_AddDealer" InsertCommandType="StoredProcedure"         SelectCommand="sp_GetDealerByDealerId"   SelectCommandType="StoredProcedure">        <SelectParameters>            <asp:Parameter DefaultValue="2" Name="nDealerId" Type="Int64" />            <asp:Parameter DefaultValue="" Direction="Output" Name="nReturnCode" Type="Int64" />            <asp:Parameter Direction="Output" Name="nReturnId" Type="Int64" />        </SelectParameters>        <InsertParameters>            <asp:Parameter Name="sCarcareSystem" Type="String" />            <asp:Parameter Name="sDealerName" Type="String" />            <asp:Parameter Name="sDealerPhysAddrStreet" Type="String" />            <asp:Parameter Name="sDealerPhysAddrCity" Type="String" />            <asp:Parameter Name="sDealerPhysAddrState" Type="String" />            <asp:Parameter Name="sDealerPhysAddrZip" Type="String" />            <asp:Parameter Direction="InputOutput" Name="nReturnCode" Type="Int64" />            <asp:Parameter Direction="InputOutput" Name="nReturnId" Type="Int64" />        </InsertParameters>    </asp:SqlDataSource>
Here is the Formview:

    <asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1">        <EditItemTemplate>            _DealerId:            <asp:TextBox ID="_DealerIdTextBox" runat="server" Text='<%# Bind("_DealerId") %>'>            </asp:TextBox><br />            Carcare System:            <asp:TextBox ID="Carcare_SystemTextBox" runat="server" Text='<%# Bind("[Carcare System]") %>'>            </asp:TextBox><br />            Dealer Name:            <asp:TextBox ID="Dealer_NameTextBox" runat="server" Text='<%# Bind("[Dealer Name]") %>'>            </asp:TextBox><br />            Address Street:            <asp:TextBox ID="Address_StreetTextBox" runat="server" Text='<%# Bind("[Address Street]") %>'>            </asp:TextBox><br />            Address City:            <asp:TextBox ID="Address_CityTextBox" runat="server" Text='<%# Bind("[Address City]") %>'>            </asp:TextBox><br />            Address State:            <asp:TextBox ID="Address_StateTextBox" runat="server" Text='<%# Bind("[Address State]") %>'>            </asp:TextBox><br />            Address Zip:            <asp:TextBox ID="Address_ZipTextBox" runat="server" Text='<%# Bind("[Address Zip]") %>'>            </asp:TextBox><br />            <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"                Text="Update">            </asp:LinkButton>            <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"                Text="Cancel">            </asp:LinkButton>        </EditItemTemplate>        <InsertItemTemplate>            _DealerId:            <asp:TextBox ID="_DealerIdTextBox" runat="server" Text='<%# Bind("_DealerId") %>'>            </asp:TextBox><br />            Carcare System:            <asp:TextBox ID="Carcare_SystemTextBox" runat="server" Text='<%# Bind("[Carcare System]") %>'>            </asp:TextBox><br />            Dealer Name:            <asp:TextBox ID="Dealer_NameTextBox" runat="server" Text='<%# Bind("[Dealer Name]") %>'>            </asp:TextBox><br />            Address Street:            <asp:TextBox ID="Address_StreetTextBox" runat="server" Text='<%# Bind("[Address Street]") %>'>            </asp:TextBox><br />            Address City:            <asp:TextBox ID="Address_CityTextBox" runat="server" Text='<%# Bind("[Address City]") %>'>            </asp:TextBox><br />            Address State:            <asp:TextBox ID="Address_StateTextBox" runat="server" Text='<%# Bind("[Address State]") %>'>            </asp:TextBox><br />            Address Zip:            <asp:TextBox ID="Address_ZipTextBox" runat="server" Text='<%# Bind("[Address Zip]") %>'>            </asp:TextBox><br />            <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"                Text="Insert">            </asp:LinkButton>            <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"                Text="Cancel">            </asp:LinkButton>        </InsertItemTemplate>        <ItemTemplate>            _DealerId:            <asp:Label ID="_DealerIdLabel" runat="server" Text='<%# Bind("_DealerId") %>'>            </asp:Label><br />            Carcare System:            <asp:Label ID="Carcare_SystemLabel" runat="server" Text='<%# Bind("[Carcare System]") %>'>            </asp:Label><br />            Dealer Name:            <asp:Label ID="Dealer_NameLabel" runat="server" Text='<%# Bind("[Dealer Name]") %>'>            </asp:Label><br />            Address Street:            <asp:Label ID="Address_StreetLabel" runat="server" Text='<%# Bind("[Address Street]") %>'>            </asp:Label><br />            Address City:            <asp:Label ID="Address_CityLabel" runat="server" Text='<%# Bind("[Address City]") %>'>            </asp:Label><br />            Address State:            <asp:Label ID="Address_StateLabel" runat="server" Text='<%# Bind("[Address State]") %>'>            </asp:Label><br />            Address Zip:            <asp:Label ID="Address_ZipLabel" runat="server" Text='<%# Bind("[Address Zip]") %>'>            </asp:Label><br />            <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New"                Text="New">            </asp:LinkButton>        </ItemTemplate>    </asp:FormView>

View Replies !

GridView Using Sqldatasource Stored Procedure
hi, sorry for asking.im using a gridview and bind it to the sqldatasource.currently the im using the ide to perfrom the binding of the gridview and the sqldatasource.for the insert command, im using the sqldatasource store procedure to insert the value.the store procedure will return an error code if error was found.how was i able to get the return value, since everything was generated by the ide?

View Replies !

GridView Via SQLDataSource And Stored Procedure
Help!I am trying to fill my datagrid using the SQLDataSource, using a stored procedure.The stored procedure expects a parameter which I can collect via the querystring, or a string. How can I pass the parameter through the SQLDatasSource?My SQLDataSource is SQLData1. I already have:SQLData1.SelectCommandType = SqlDataSourceCommandType.StoredProcedureSQLData1.SelectCommand = "dbo.get_players"Thanks in advance,Karls

View Replies !

Error: Procedure Or Function Has Too Many Arguments Specified
Hi,

I've found that I'm not the first one to get the error

"Procedure or function x has too many arguments specified"

while working with Stored Procedures (which is no surprise at all). But
all suggested solutions didn't help, maybe this is because I
misunderstood the whole concept. The situation is: On my page there is
a FormView control including the EditItemTemplate. The database
contains a Stored Procedure called UpdatePersonByID which is working
fine as long as executed in Visual Web Developer. Here's the procedure
code:

ALTER PROCEDURE dbo.UpdatePersonByID
    (
        @LastName varchar(50),
        @FirstName varchar(50),
        @Phone varchar(50),
        @PhonePrivate varchar(50),
        @PhoneMobile varchar(50),
        @Email varchar(50)
    )
AS
    UPDATE
        tblPersons
        SET
            PersonLastName = @LastName,
            PersonFirstName = @FirstName,
            PersonPhone = @Phone,
            PersonPhonePrivate = @PhonePrivate,
            PersonPhoneMobile = @PhoneMobile,
            PersonEmail = @Email
        WHERE
            PersonLastName = @LastName
    RETURN

This is not exactly what it will finally have to do, of course the
WHERE-clause later will contain an ID comparison. But since I tried to
break down my code as much as possible I changed it to what you see
right now. Here's the aspx-source (the red stuff is what I think is
important):

<%@ Page
    Language="VB"
    MasterPageFile="fb10.master"
    AutoEventWireup="false"
    CodeFile="codebehind/staff.aspx.vb"
    Inherits="staff"
    meta:ResourceKey="PageResource"
%>
<%@ MasterType VirtualPath ="~/fb10.master" %>
<asp:Content
    ID="ContentStaff"
    ContentPlaceHolderID="cphContentMain"
    Runat="Server">

    <h3 id="hdStaff" runat="server" meta:resourcekey="Staff" />

    
    <asp:SqlDataSource
        ID="srcStaff"
        runat="server"
        ConflictDetection="CompareAllValues"
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
        SelectCommandType="StoredProcedure"
        SelectCommand="SelectPersonNames"
    />
    <asp:DropDownList
        ID="ddlStaff"
        runat="server"
        DataSourceID="srcStaff"
        DataTextField="CompleteName"
        DataValueField="PersonID"
        AutoPostBack="True">
    </asp:DropDownList>

    
    <asp:SqlDataSource
        ID="srcPerson"
        runat="server"
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
        ProviderName="System.Data.SqlClient"
        SelectCommand="SelectPersonByID"
        SelectCommandType="StoredProcedure"
        UpdateCommand="UpdatePersonByID"
        UpdateCommandType="StoredProcedure"
        OldValuesParameterFormatString="{0}" >
        <SelectParameters>
            <asp:ControlParameter
                ControlID="ddlStaff"
                DefaultValue="1"
                Name="ID"
                PropertyName="SelectedValue"
                Type="Int32" />
        </SelectParameters>
        <UpdateParameters>
            <asp:Parameter Name="LastName" Type="String" />
            <asp:Parameter Name="FirstName" Type="String" />
            <asp:Parameter Name="Phone" Type="String" />
            <asp:Parameter Name="PhonePrivate" Type="String" />
            <asp:Parameter Name="PhoneMobile" Type="String" />
            <asp:Parameter Name="Email" Type="String" />
        </UpdateParameters>
    </asp:SqlDataSource>

    
    <asp:SqlDataSource
        ID="srcBuildings"
        runat="server"
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
        ProviderName="System.Data.SqlClient"
        SelectCommand="SelectBuildings"
        SelectCommandType="StoredProcedure">
    </asp:SqlDataSource>

    <asp:FormView
        ID="fvStaff"
        runat="server"
        DataSourceID="srcPerson">
        <EditItemTemplate>
            
            <asp:SqlDataSource
                ID="srcRooms"
                runat="server"


ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
                ProviderName="System.Data.SqlClient"
                SelectCommand="SelectRoomsByBuildingID"
                SelectCommandType="StoredProcedure">
                <SelectParameters>
                    <asp:ControlParameter


ControlID="ddlBuildings"


DefaultValue="1"


Name="ID"


PropertyName="SelectedValue"


Type="Int32"
                    />
                </SelectParameters>
            </asp:SqlDataSource>

            <asp:Label
cssClass="lblIdentifier" ID="lblLastName" runat="server"
meta:resourcekey="LastName" />

<asp:TextBox cssClass="staff" ID="LastName" runat="server"
Text='<%# Bind("PersonLastName")
%>'></asp:TextBox><br />

            <asp:Label
cssClass="lblIdentifier" ID="lblFirstName" runat="server"
meta:resourcekey="FirstName" />

<asp:TextBox cssClass="staff" ID="FirstName" runat="server"
Text='<%# Bind("PersonFirstName")
%>'></asp:TextBox><br />

            <asp:Label
CssClass="lblIdentifier" ID="lblBuilding" runat="server"
meta:resourcekey="Building"></asp:Label>
            <asp:DropDownList
                ID="ddlBuildings"
                cssClass="small"
                runat="server"
                DataSourceID="srcBuildings"
                DataTextField="BuildingAbbreviation"
                DataValueField="BuildingID"
                AutoPostBack="True"
                SelectedValue='<%# Bind("RoomBuildingID") %>'


OnSelectedIndexChanged="ddlBuildings_SelectedIndexChanged">
            </asp:DropDownList><br />

            <asp:Label
cssClass="lblIdentifier" ID="lblRoom" runat="server"
meta:resourcekey="Room" />
            <asp:DropDownList
                ID="ddlRooms"
                cssClass="small"
                runat="server"
                DataSourceID="srcRooms"
                DataTextField="RoomName"
                DataValueField="RoomID"
                AutoPostBack="true"

    SelectedValue='<%# Bind("PersonRoomID") %>'>
            </asp:DropDownList><br />

            <asp:Label
cssClass="lblIdentifier" ID="lblPhone" runat="server"
meta:resourcekey="Phone" />

<asp:TextBox cssClass="staff" ID="Phone" runat="server" Text='<%#
Bind("PersonPhone") %>'></asp:TextBox><br />

            <asp:Label
cssClass="lblIdentifier" ID="lblPhonePrivate" runat="server"
meta:resourcekey="Private" />

<asp:TextBox cssClass="staff" ID="PhonePrivate" runat="server"
Text='<%# Bind("PersonPhonePrivate")
%>'></asp:TextBox><br />

            <asp:Label
cssClass="lblIdentifier" ID="lblPhoneMobile" runat="server"
meta:resourcekey="Mobile" />

<asp:TextBox cssClass="staff" ID="PhoneMobile" runat="server"
Text='<%# Bind("PersonPhoneMobile")
%>'></asp:TextBox><br />

            <asp:Label
cssClass="lblIdentifier" ID="lblEmail" runat="server"
meta:resourcekey="Email" />

<asp:TextBox cssClass="staff" ID="Email" runat="server" Text='<%#
Bind("PersonEmail") %>'></asp:TextBox><br />


<asp:LinkButton cssClass="lnkButton" ID="UpdateCancelButton"
runat="server" CausesValidation="False" CommandName="Cancel"
Text="<%$resources:translations,
Cancel%>"></asp:LinkButton>

<asp:LinkButton cssClass="lnkButton" ID="UpdateButton"
runat="server" CausesValidation="True" CommandName="Update"
Text="<%$resources:translations,
Update%>"></asp:LinkButton>
        </EditItemTemplate>
        <InsertItemTemplate>
            <asp:Label
cssClass="lblIdentifier" ID="lblLastName" runat="server"
meta:resourcekey="LastName" />

<asp:TextBox ID="PersonLastNameTextBox"
runat="server"></asp:TextBox><br />

            <asp:Label
cssClass="lblIdentifier" ID="lblFirstName" runat="server"
meta:resourcekey="FirstName" />

<asp:TextBox ID="PersonFirstNameTextBox"
runat="server"></asp:TextBox><br />

            <asp:Label
cssClass="lblIdentifier" ID="lblBuilding" runat="server"
meta:resourcekey="Building" />

<asp:TextBox ID="BuildingAbbreviationTextBox"
runat="server"></asp:TextBox><br />

            <asp:Label
cssClass="lblIdentifier" ID="lblRoom" runat="server"
meta:resourcekey="Room" />

<asp:TextBox ID="RoomNameTextBox"
runat="server"></asp:TextBox><br />


<asp:LinkButton cssClass="lnkButton" ID="InsertCancelButton"
runat="server" CausesValidation="False" CommandName="Cancel"
Text="<%$resources:translations,
Cancel%>"></asp:LinkButton>

<asp:LinkButton cssClass="lnkButton" ID="InsertButton"
runat="server" CausesValidation="True" CommandName="Insert"
Text="<%$resources:translations,
Insert%>"></asp:LinkButton>
        </InsertItemTemplate>
        <ItemTemplate>
            <asp:Label
cssClass="lblIdentifier" ID="lblLastName" runat="server"
meta:resourcekey="LastName" />
            <asp:Label
cssClass="lblValue" ID="PersonLastNameLabel" runat="server"
Text='<%# Bind("PersonLastName") %>'></asp:Label><br
/>

            <asp:Label
cssClass="lblIdentifier" ID="lblFirstName" runat="server"
meta:resourcekey="FirstName" />
            <asp:Label
cssClass="lblValue" ID="PersonFirstNameLabel" runat="server"
Text='<%# Bind("PersonFirstName") %>'></asp:Label><br
/>

            <asp:Label
cssClass="lblIdentifier" ID="lblBuilding" runat="server"
meta:resourcekey="Building" />
            <asp:Label
cssClass="lblValue" ID="BuildingAbbreviationLabel" runat="server"
Text='<%# Bind("BuildingAbbreviation")
%>'></asp:Label><br />

            <asp:Label
cssClass="lblIdentifier" ID="lblRoom" runat="server"
meta:resourcekey="Room" />
            <asp:Label
cssClass="lblValue" ID="RoomLabel" runat="server" Text='<%#
Bind("RoomName") %>'></asp:Label><br />

            <asp:Label
cssClass="lblIdentifier" ID="lblPhone" runat="server"
meta:resourcekey="Phone" />
            <asp:Label
cssClass="lblValue" ID="PhoneLabel" runat="server" Text='<%#
Bind("PersonPhone") %>'></asp:Label><br />

            <asp:Label
cssClass="lblIdentifier" ID="lplPhonePrivate" runat="server"
meta:resourcekey="Private" />
            <asp:Label
cssClass="lblValue" ID="PhonePrivateLabel" runat="server" Text='<%#
Bind("PersonPhonePrivate") %>'></asp:Label><br />

            <asp:Label
cssClass="lblIdentifier" ID="lblPhoneMobile" runat="server"
meta:resourcekey="Mobile" />
            <asp:Label
cssClass="lblValue" ID="PhoneMobileLabel" runat="server" Text='<%#
Bind("PersonPhoneMobile") %>'></asp:Label><br />

            <asp:Label
cssClass="lblIdentifier" ID="lblEmail" runat="server"
meta:resourcekey="Email" />
            <asp:Label
cssClass="lblValue" ID="EmailLabel" runat="server" Text='<%#
Bind("PersonEmail") %>'></asp:Label><br />


<asp:LinkButton cssClass="lnkButton" ID="DeleteButton"
runat="server" CausesValidation="False" CommandName="Delete"
Text="<%$resources:translations,
Delete%>"></asp:LinkButton>

<asp:LinkButton cssClass="lnkButton" ID="EditButton" runat="server"
CausesValidation="False" CommandName="Edit"
Text="<%$resources:translations,
Edit%>"></asp:LinkButton>
        </ItemTemplate>
    </asp:FormView>
</asp:Content>

And then once again a totally different question: Is there a way to
post the highlighted aspx or vb code into this forum and keep the
colors? i think I've seen that in some posts but didn't wanna do it
manually.

Thanks once again for trying to help,

Toob

View Replies !

ERROR: Too Many Arguments Passed To Stored Procedure
Hi,

We have an application written in ASP that calls a MS-SQL stored procedure and passes several parameters. Once in a while, we get this error, but most of the time it works. We can also run this in SQL query analyzer without ever a problem. We've looked at the obvious and found nothing wrong.

Please help! Any suggestions are appreciated.
(I posted this in ASP discussion board but no one replied)

Colleen

--------------------------------------------------------------------------------

|

View Replies !

Procedure Or Function Has Too Many Arguments Specified
Hi,I have a simple stored procedure that basically SELECT some data from database. I am calling this stored procedure using a sqldatasource. The first time I try it, it works perfectly fine. But I get the error message "Procedure or function has too many arguments specified" the second time I try to search for thing. This is the code that I have that called the stored procedure: Session("SearchItem") = txtSearch.Text.Trim SqlDataSource1.SelectCommand = "_MyStoredProcedure" SqlDataSource1.SelectParameters.Add("SearchItem", Session("SearchItem")) SqlDataSource1.SelectCommandType = SqlDataSourceCommandType.StoredProcedure Gridview1.DataSourceID = "SqlDataSource1" Gridview1.DataBind() The following is the code in the stored procedure: CREATE PROCEDURE [dbo].[_MyStoredProcedure] ( @SearchItem nvarchar(255) = NULL)ASSELECT Field1, Field2, Field3 FROM Registration WHERE((@SearchItem IS NULL) OR (Field1 LIKE '%' + @SearchItem + '%') OR (Field2 LIKE '%' + @SearchItem + '%'))GO Please help.Stan

View Replies !

Procedure Or Function Has Too Many Arguments Specified
I have a Typed Dataset in an applcation <<Table structure in database is also same as Dataset>>
<xs:element name="WC_CMNT_TXT">     <xs:complexType>      <xs:sequence>       <xs:element name="WC_CMNT_TXT_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int"        msdata:AutoIncrementSeed="-2" msdata:AutoIncrementStep="-1" />       <xs:element name="WC_RSPRC_ID" type="xs:int" />       <xs:element name="WC_CMNT_TYP_ID" type="xs:int" />       <xs:element name="CMNT_TXT" type="xs:string" minOccurs="0" />       <xs:element name="ENT_TISTMP" msdata:ReadOnly="true" type="xs:dateTime" minOccurs="0" />      </xs:sequence>     </xs:complexType>  </xs:element>
First Column is a Primary key.
CMNT_TXT is fetched using WC_RSPRC_ID and WC_CMNT_TYP_ID and binded to a text box.
if no row is returned then empty row s created in a dataset by
            this.dsCommentText.WC_CMNT_TXT.AddWC_CMNT_TXTRow(132,9,String.Empty,System.DateTime.Now);
Till here it s working fine.
Now when i update the data in a database using data-adapter , i get the error message as "Procedure or function AddWC_CMNT_TXT has too many arguments specified"
Insert Commnad is as below :
   SqlDataAdapter da = new SqlDataAdapter();         da.TableMappings.Add("Table","WC_CMNT_TXT");      #region Insert Command   SqlCommand cmdInsert = new SqlCommand();   cmdInsert.UpdatedRowSource = UpdateRowSource.OutputParameters;   cmdInsert.CommandText = "cas_wrkstn_dbo.AddWC_CMNT_TXT";   cmdInsert.CommandType = System.Data.CommandType.StoredProcedure;    cmdInsert.Parameters.Add(new SqlParameter("@cmnt_txt", SqlDbType.VarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "CMNT_TXT", DataRowVersion.Current, null));   cmdInsert.Parameters.Add(new SqlParameter("@wc_rsprc_id", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "WC_RSPRC_ID", DataRowVersion.Current, null));   cmdInsert.Parameters.Add(new SqlParameter("@wc_cmnt_typ_id", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "WC_CMNT_TYT_ID", DataRowVersion.Current, null));      cmdInsert.Parameters.Add(new SqlParameter("@wc_cmnt_txt_id", SqlDbType.Int, 4, ParameterDirection.Output, false, 0, 0, "WC_CMNT_TXT_ID", DataRowVersion.Current, null));   cmdInsert.Parameters.Add(new SqlParameter("@ent_tistmp", SqlDbType.DateTime, 8, ParameterDirection.Output, false, 0, 0, "ENT_TISTMP", DataRowVersion.Original, null));   da.InsertCommand = cmdInsert;

Stored Procedure s :
ALTER procedure AddWC_CMNT_TXT        (        @cmnt_txt    varchar(5000),      @wc_cmnt_typ_id int,      @wc_rsprc_id int,      @wc_cmnt_txt_id int output,        @ent_tistmp    datetime output   )                as        set nocount on;                declare @error int;                insert into WC_CMNT_TXT        (        CMNT_TXT ,       WC_RSPRC_ID,      WC_CMNT_TYP_ID, ENT_TISTMP     )        values        (        @cmnt_txt ,       @wc_rsprc_id ,       @wc_cmnt_typ_id, getdate()      )                if @@rowcount = 1        begin        select           @wc_cmnt_txt_id = WC_CMNT_TXT_ID ,           @ent_tistmp = ENT_TISTMP                   from WC_CMNT_TXT with (nolock)           where (WC_CMNT_TXT_ID = scope_identity())                end                select @error = @@error                return @error

Please suggest wht to do

View Replies !

Procedure Or Function '' Has Too Many Arguments Specified.
Im getting this error when looping through a gridview. Im trying to save each row into the database. The weird thing is that it saves the first row, but errors out on the second.If I only add one item to the gridview, it works. The second row is screwing it up somehow. Any ideas? ------------------------------------------------------------------------------------------------------------------------------------------------------------------Some of my code to get an idea of how im doing it:(This
is for a shopping cart. It displays the products in the shopping cart.
If the order is approved by the CC processing company, each product
entry is saved in the DB. The gridview is being populated by my
ShoppingCart Profile Object.) SqlConnection objConn = new SqlConnection(ConfigurationManager.ConnectionStrings["rdevie"].ConnectionString);
SqlCommand objCmd = new SqlCommand("InsertOrderDetails", objConn);
objCmd.CommandType = CommandType.StoredProcedure;

objConn.Open();

foreach (GridViewRow row in gvOrderDetails.Rows)
{
objCmd.Parameters.Add("@idOrder", SqlDbType.Int).Value = orderNum;
objCmd.Parameters.Add("@fldName", SqlDbType.NVarChar).Value = ((Label)row.FindControl("lblName")).Text;
objCmd.Parameters.Add("@fldUnitPrice", SqlDbType.Money).Value = ((Label)row.FindControl("lblUnitPrice")).Text;
objCmd.Parameters.Add("@fldQuantity", SqlDbType.Int).Value = Convert.ToInt32(((Label)row.FindControl("lblQuantity")).Text);
if (!String.IsNullOrEmpty(((Label)row.FindControl("lblSku")).Text))
objCmd.Parameters.Add("@fldSku", SqlDbType.NVarChar).Value = ((Label)row.FindControl("lblSku")).Text;
else
objCmd.Parameters.Add("@fldSku", SqlDbType.NVarChar).Value = DBNull.Value;
objCmd.Parameters.Add("@fldSize", SqlDbType.NVarChar).Value = ((Label)row.FindControl("lblSize")).Text;
objCmd.Parameters.Add("@fldLogo", SqlDbType.NVarChar).Value = ((Label)row.FindControl("lblLogo")).Text;
objCmd.Parameters.Add("@fldPlacement", SqlDbType.NVarChar).Value = ((Label)row.FindControl("lblPlacement")).Text;
objCmd.Parameters.Add("@fldColor", SqlDbType.NVarChar).Value = ((Label)row.FindControl("lblColor")).Text;

objCmd.ExecuteNonQuery();
}

objCmd.Dispose();
objConn.Close();
objConn.Dispose();

View Replies !

Procedure Or Function Has Too Many Arguments Specified
I have tried to introduce information in webform with sp and she leaves the following error

View Replies !

Procedure Or Function Has Too Many Arguments Specified
Hello All,
I am having a very strange problem which I cannot figure out. I am using the ASP.NET 2.0 SqlDataSource control to insert a news item into a SQL Express database. When inserting the a message I receive the following error: Procedure or function has too many arguments specified
However according to me every thing adds up. Can anyone please help me figure out what is wrong? Here is the code:
SqlDataSource: <asp:SqlDataSource ID="sqlNews" runat="server" ConnectionString="<%$ ConnectionStrings:FlevoOptiekDB %>" SelectCommandType="StoredProcedure" SelectCommand="dbo.usp_News_ByID" InsertCommandType="StoredProcedure" InsertCommand="dbo.usp_News_Insert" UpdateCommandType="StoredProcedure" UpdateCommand="dbo.usp_News_Update" DeleteCommandType="StoredProcedure" DeleteCommand="dbo.usp_News_Delete" OldValuesParameterFormatString="{0}"> <SelectParameters> <asp:QueryStringParameter Name="p_iNewsID" QueryStringField="news_ID" /> </SelectParameters> <UpdateParameters> <asp:Parameter Name="p_dtmPublished" Type="DateTime" /> <asp:Parameter Name="p_sTitle" /> <asp:Parameter Name="p_sDescription" /> <asp:Parameter Name="p_sStaticUrl" /> <asp:Parameter Name="p_iPhotoID" /> <asp:Parameter Name="p_iNewsID" /> <asp:Parameter Name="p_iAlbumID" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="p_dtmPublished" Type="DateTime" /> <asp:Parameter Name="p_sTitle" /> <asp:Parameter Name="p_sDescription" /> <asp:Parameter Name="p_sStaticUrl" /> <asp:Parameter Name="p_iPhotoID" /> <asp:Parameter Name="p_iAlbumID" /> </InsertParameters> <DeleteParameters> <asp:QueryStringParameter Name="p_iNewsID" QueryStringField="news_ID" /> </DeleteParameters> </asp:SqlDataSource>Stored procedure:ALTER PROCEDURE dbo.usp_News_Insert( @p_sTitle VARCHAR(256), @p_sDescription TEXT, @p_sStaticUrl VARCHAR(256), @p_dtmPublished DATETIME, @p_iPhotoID INT, @p_iAlbumID INT)AS /* SET NOCOUNT ON */ INSERT INTO dbo.tbNews(news_Title, news_Description, news_StaticUrl, news_Published, photo_ID, album_ID) VALUES(@p_sTitle, @p_sDescription, @p_sStaticUrl, @p_dtmPublished, @p_iPhotoID, @p_iAlbumID) RETURN
Thanks, Maurits

View Replies !

Procedure Or Function Has Too Many Arguments Specified
I have two tables: Person (member_no, name) and Participant (participant, member_no) member_no is the primary key in Person.The stored procedure is:CREATE PROCEDURE dbo.InsertRecs@member_no char(10),@name char(10),@participant char(10)ASbegininsert into person (member_no, name)values (@member_no, @name)select @member_no = @@Identityinsert into participant (participant, member_no)values (@participant, @member_no)endGOWhen I run this via the DetailsView control and try to insert a record I always get "Procedure or function InsertRecs has too many arguments specified"If I remove the second table from the stored procedure it works fine.Does anyone have any ideas?

View Replies !

Procedure Or Function Has Too Many Arguments Specified
Hi there
I'm a newbie to ASP.net development.I'm getting this error message "Procedure or function has too many arguments specified." when inserting/editing/deleting data from the formview control.
I executed the stored procedures and had no problems with it but when executed from the web page i encountered the error message mentioned earlier.
Would appreciate it very much if someone can point out what it is that i'm doing wrong.
Thanks in advance.
Customer table:Customer_ID       nchar(10), primary keyFname                  varchar(50)Lname                  varchar(50)Job_ID                  smallint
Stored Procedures:1) InsertCustomersALTER PROCEDURE dbo.InsertCustomers@CustID  nchar(10),@FName  varchar(50),@LName  varchar(50),@JobID  smallintASInsert into Customers (Customer_ID, FName, LName, Job_ID)Values (@CustID, @FName, @LName, @JobID)RETURN
2) UpdateCustomersALTER PROCEDURE dbo.UpdateCustomers@FName  varchar(50),@LName  varchar(50),@JobID  smallint,@CustID  nchar(10)ASUpdate Customers set FName = @FName, LName = @LName, Job_ID = @JobIDWhere Customer_ID = @CustID RETURN
3) DeleteCustomersALTER PROCEDURE dbo.DeleteCustomers@CustID  nchar(10)ASDelete Customers where Customer_ID = @CustID RETURN
Web Page:<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default4.aspx.vb" Inherits="Default4" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server">    <title>Untitled Page</title></head><body>    <form id="form1" runat="server">    <table width="100%">        <tr>            <td colspan="2">                 <asp:FormView ID="FormView1" runat="server" AllowPaging="True"                     DataKeyNames="Customer_ID" DataSourceID="SqlDataSource1" Width="100%">                    <EditItemTemplate>                        Customer_ID:                        <asp:Label ID="Customer_IDLabel1" runat="server" Text='<%# Eval("Customer_ID") %>'>                        </asp:Label><br />                        Fname:                        <asp:TextBox ID="FnameTextBox" runat="server" Text='<%# Bind("Fname") %>'>                        </asp:TextBox><br />                        lname:                        <asp:TextBox ID="lnameTextBox" runat="server" Text='<%# Bind("lname") %>'>                        </asp:TextBox><br />                        job_id:                        <asp:TextBox ID="job_idTextBox" runat="server" Text='<%# Bind("job_id") %>'>                        </asp:TextBox><br />                        <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"                            Text="Update">                        </asp:LinkButton>                        <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"                            Text="Cancel">                        </asp:LinkButton>                    </EditItemTemplate>                    <InsertItemTemplate>                        Customer_ID:                        <asp:TextBox ID="Customer_IDTextBox" runat="server" Text='<%# Bind("Customer_ID") %>'>                        </asp:TextBox><br />                        Fname:                        <asp:TextBox ID="FnameTextBox" runat="server" Text='<%# Bind("Fname") %>'>                        </asp:TextBox><br />                        lname:                        <asp:TextBox ID="lnameTextBox" runat="server" Text='<%# Bind("lname") %>'>                        </asp:TextBox><br />                        job_id:                        <asp:TextBox ID="job_idTextBox" runat="server" Text='<%# Bind("job_id") %>'>                        </asp:TextBox><br />                        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"                            Text="Insert">                        </asp:LinkButton>                        <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"                            Text="Cancel">                        </asp:LinkButton>                    </InsertItemTemplate>                    <ItemTemplate>                        Customer_ID:                        <asp:Label ID="Customer_IDLabel" runat="server" Text='<%# Eval("Customer_ID") %>'>                        </asp:Label><br />                        Fname:                        <asp:Label ID="FnameLabel" runat="server" Text='<%# Bind("Fname") %>'></asp:Label><br />                        lname:                        <asp:Label ID="lnameLabel" runat="server" Text='<%# Bind("lname") %>'></asp:Label><br />                        job_id:                        <asp:Label ID="job_idLabel" runat="server" Text='<%# Bind("job_id") %>'></asp:Label><br />                        <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit"                            Text="Edit">                        </asp:LinkButton>                        <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete"                            Text="Delete">                        </asp:LinkButton>                        <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New"                            Text="New">                        </asp:LinkButton>                    </ItemTemplate>                </asp:FormView>            </td>        </tr>        <tr>            <td colspan="2">                <asp:SqlDataSource ID="SqlDataSource1" runat="server"                     ConnectionString="<%$ ConnectionStrings:pubsConnectionString %>"                     InsertCommand="InsertCustomers" InsertCommandType="StoredProcedure"                     SelectCommand="SelectCustomers" SelectCommandType="StoredProcedure"                     UpdateCommand="UpdateCustomers" UpdateCommandType="StoredProcedure" DeleteCommand="DeleteCustomers" DeleteCommandType="StoredProcedure">                    <InsertParameters>                        <asp:Parameter Name="CustID" Type="String" />                        <asp:Parameter Name="FName" Type="String" />                        <asp:Parameter Name="LName" Type="String" />                        <asp:Parameter Name="JobID" Type="Int16" />                    </InsertParameters>                    <UpdateParameters>                        <asp:Parameter Name="FName" Type="String" />                        <asp:Parameter Name="LName" Type="String" />                        <asp:Parameter Name="JobID" Type="Int16" />                        <asp:Parameter Name="CustID" Type="String" />                    </UpdateParameters>                    <DeleteParameters>                        <asp:Parameter Name="CustID" Type="String" />                    </DeleteParameters>                </asp:SqlDataSource>            </td>        </tr>        <tr>            <td colspan="2">            </td>        </tr>    </table>    </form></body></html>

View Replies !

Procedure Or Function Has Too Many Arguments
Dear all,I have the following stored proc:-SET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS OFF GOALTER PROCEDURE dbo.stpLoginUser(@login Varchar(255),@password Varchar(255),@email Varchar(255) OUTPUT,@username Varchar(255) OUTPUT,@id int OUTPUT)ASBEGIN/*Check for valid login and password*/SET @username = ' 'Select @id = id_u, @username = first_name, @email = email from pod_Users where email = @login AND u_password = @passwordENDGOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS ON GOand basically the user enters a username and a password.However I got the following error:-Procedure or function has too many argumentsI tried renaming my stored proc name but to no avail.I am calling this stored proc from a vb.net program as follows:-Dim conn As SqlConnectionDim cmd As SqlCommandDim RetVal As Integer = -1Dim FullName As String' create the conection object for scalar reader to useconn = New SqlConnectionconn.ConnectionString = ConnectionString' return the players pk_playercmd = New SqlCommandcmd.CommandType = CommandType.StoredProcedurecmd.Connection = conncmd.CommandText = "stpLoginUser"cmd.Parameters.Add("@login", SqlDbType.NVarChar, 255)cmd.Parameters("@login").Value = usernamecmd.Parameters.Add("@password", SqlDbType.NVarChar, 255)cmd.Parameters("@password").Value = passwordcmd.Parameters.Add("@username", SqlDbType.NVarChar, 255)cmd.Parameters("@username").Direction = ParameterDirection.Outputcmd.Parameters.Add("@email", SqlDbType.NVarChar, 255)cmd.Parameters("@email").Direction = ParameterDirection.Outputcmd.Parameters.Add("@id", SqlDbType.Int)cmd.Parameters("@id").Direction = ParameterDirection.OutputTryconn.Open()cmd.ExecuteNonQuery()RetVal = cmd.Parameters("@id").Value()FullName = cmd.Parameters("@username").Value()'CatchCatch e As ExceptionConsole.WriteLine(e.ToString()) ' Print the error message to the user.RetVal = -1Finallyconn.Close()End TryCan anybody help me pls?Thanks for your help

View Replies !

Procedure Or Function Sppaintinsert Has Too Many Arguments Specified, Please Help
Hi,I cant see why this will not work, when i run the page and try and perform a function it clicks me out and underlines
SQLCommand.ExecuteNonQuery() with this error Procedure or function sppaintinsert has too many arguments specified
Code below:
Imports System.IO
Imports System.Data
Imports System.Data.SqlClientPartial Class admin
Inherits System.Web.UI.PageProtected Sub btnUpload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUpload.Click
Dim strFileName As String
Dim strFilePath As String
Dim strFolder As String
Dim strPicTitle As StringDim SQLConnection As Data.SqlClient.SqlConnectionDim SQLCommand As Data.SqlClient.SqlCommand

strFolder = "C:Documents and SettingsRoss HintonMy DocumentsVisual Studio 2005WebSitesjessicawebsitePictures"
strFileName = oFile.PostedFile.FileName
strFileName = Path.GetFileName(strFileName)
strPicTitle = TextBox1.Text
If (Not Directory.Exists(strFolder)) Then
Directory.CreateDirectory(strFolder)
End If
strFilePath = strFolder & strFileName
If File.Exists(strFilePath) Then
lblUploadResult.Text = strFileName & " already exists on the server!"
ElseSQLConnection = New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|picturesdb.mdf;Integrated Security=True;User Instance=True")SQLCommand = New SqlCommand
SQLCommand.CommandType = CommandType.StoredProcedure
If DropDownList.SelectedItem.Value = 0 Then
SQLCommand.CommandText = "paintingpictures"
Else
SQLCommand.CommandText = "spdrawinsert"
End If
SQLCommand.Connection = SQLConnection
SQLConnection.Open()
SQLCommand.Parameters.AddWithValue("@image", "Pictures" + strFileName) ' sp parameter nameSQLCommand.Parameters.AddWithValue("@Title", strPicTitle)
SQLCommand.ExecuteNonQuery()
oFile.PostedFile.SaveAs(strFilePath)
lblUploadResult.Text = strFileName & " has been successfully uploaded."
End If
frmConfirmation.Visible = TrueEnd Sub
End ClassALTER PROCEDURE paintingpictures
@image VARCHAR(50)
AS
INSERT INTO pictable([image])
VALUES (@image)

View Replies !

Procedure Or Function &<stored_procedure_name&> Has Too Many Arguments Specified.
Thanks in advance,
I am getting the "Procedure or function JobsDb_Development_Update has too many arguments specified." error. Below is the sp and the vwd generated sqldatasource, any suggestions?
Thanks
Nick

Update Stored Procedure:
ALTER PROCEDURE [dbo].[JobsDb_Development_Update]
@sDevelopmentArea varchar(255), @sDevelopmentGoals text, @sDevelopmentPlans text, @sCurrentStatus text, @sFutureState text, @sDetermineFactor text, @bMentorRequested bit,@sMentorList text, @dtCheckPointDate datetime, @dtDateUpdated datetime, @iPlanPKID int
AS
UPDATE JobsDb_Development
SET DevelopmentArea = @sDevelopmentArea, DevelopmentGoals = @sDevelopmentGoals, DevelopmentPlans = @sDevelopmentPlans, CurrentStatus = @sCurrentStatus,
FutureState = @sFutureState, DetermineFactor = @sDetermineFactor, MentorRequested = @bMentorRequested, MentorList = @sMentorList, CheckPointDate = @dtCheckPointDate,
DateUpdated = @dtDateUpdated
WHERE (PlanPKID = @iPlanPKID)
SQL Data Source:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:MyProviderConnectionString %>"
DeleteCommand="JobsDb_Development_Delete" DeleteCommandType="StoredProcedure"
InsertCommand="JobsDb_Development_Insert" InsertCommandType="StoredProcedure"
SelectCommand="JobsDb_Development_SelectOne"
SelectCommandType="StoredProcedure" UpdateCommand="JobsDb_Development_Update"
UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="txtUserName" Name="sUserName"
PropertyName="Text" Type="String" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="iPlanPKID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="sDevelopmentGoals" Type="String" />
<asp:Parameter Name="sDevelopmentPlans" Type="String" />
<asp:Parameter Name="sCurrentStatus" Type="String" />
<asp:Parameter Name="sFutureState" Type="String" />
<asp:Parameter Name="sDetermineFactor" Type="String" />
<asp:Parameter Name="bMentorRequested" Type="Boolean" />
<asp:Parameter Name="sMentorList" Type="String" />
<asp:Parameter Name="dtCheckPointDate" Type="DateTime" />
<asp:Parameter Name="dtDateUpdated" Type="DateTime" />
<asp:Parameter Name="iPlanPKID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="sUserName" Type="String" />
<asp:Parameter Name="sDevelopmentArea" Type="String" />
<asp:Parameter Name="sDevelopmentGoals" Type="String" />
<asp:Parameter Name="sDevelopmentPlans" Type="String" />
<asp:Parameter Name="sCurrentStatus" Type="String" />
<asp:Parameter Name="sFutureState" Type="String" />
<asp:Parameter Name="sDetermineFactor" Type="String" />
<asp:Parameter Name="bMentorRequested" Type="Boolean" />
<asp:Parameter Name="sMentorList" Type="String" />
<asp:Parameter Name="dtCheckPointDate" Type="DateTime" />
<asp:Parameter Name="dtDateAdded" Type="DateTime" />
<asp:Parameter Name="dtDateUpdated" Type="DateTime" />
<asp:Parameter Direction="InputOutput" Name="iPlanPKID" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>

View Replies !

HELP!!! - Procedure Or Function SpInsertNewProduct Has Too Many Arguments Specified
Hi All,
I'm getting this annoying message when I try to call my Sp on an insert. I've executed the SP straight from SQL Server 2005 Express and it works fine. but I think I have a problem how I'm calling it.
The SP-------------------------------------------------------------------------
ALTER PROCEDURE dbo.spInsertNewProduct(
@productName nvarchar(50),
@productSummary text,
@productDesc text,
@productPhoto int,
@productFeaturelist text,
@productTestimonials text,
@productFile1 int,
@productFile1_Title nvarchar(50),
@productFile2 int,
@productFile1_Title nvarchar(50),
@NewProductID int OUTPUT)AS
-- inserts new product
INSERT INTO [tbl_products] ([productName], [productSummary], [productDesc], [productPhoto], [productFeaturelist], [productTestimonials], [productFile1], [productFile1_Title], [productFile2], [productFile2_Title])
VALUES (@productName, @productSummary, @productDesc, @productPhoto, @productFeaturelist, @productTestimonials, @productFile1, @productFile1_Title, @productFile2, @productFile2_Title);
-- Read the just-inserted productID into @NewProductID
SET @NewProductID = SCOPE_IDENTITY();
-------------------------------------------------------------------------
The DataSource-------------------------------------------------------------------------
<asp:SqlDataSource ID="dsproduct" runat="server" ConnectionString="<%$ ConnectionStrings:myConn %>"            InsertCommand="spInsertNewProduct" InsertCommandType="StoredProcedure">            <InsertParameters>                <asp:Parameter Name="productName" Type="String" />                <asp:Parameter Name="productSummary" Type="String" />                <asp:Parameter Name="productDesc" Type="String" />                <asp:Parameter Name="productPhoto" Type="String" />                <asp:Parameter Name="productFeaturelist" Type="String" />                <asp:Parameter Name="productTestimonials" Type="String" />                <asp:Parameter Name="productFile1" Type="String" />                <asp:Parameter Name="productFile1_Title" Type="String" />                <asp:Parameter Name="productFile2" Type="String" />                <asp:Parameter Name="productFile2_Title" Type="String" />                <asp:Parameter Direction="Output" Name="NewProductID" Type="Int32" />            </InsertParameters>        </asp:SqlDataSource>-------------------------------------------------------------------------
In code behind I grab params from front end dropdowns:-------------------------------------------------------------------------
    Sub InsertProduct(ByVal Src As Object, ByVal Args As DetailsViewInsertEventArgs)
        dsProduct.InsertParameters("productPhoto").DefaultValue = CType(dvEditProduct.FindControl("ddlProdImage"), DropDownList).SelectedValue
        dsProduct.InsertParameters("productFile1").DefaultValue = CType(dvEditProduct.FindControl("ddlProdFile1"), DropDownList).SelectedValue
        dsProduct.InsertParameters("productFile2").DefaultValue = CType(dvEditProduct.FindControl("ddlProdFile2"), DropDownList).SelectedValue
        lblStatus.Text = "Product has been added to the database"    End Sub-------------------------------------------------------------------------
I can't see how in the VB front end file how there can be too many params? Any help is greatly appreciated!

View Replies !

Procedure Or Function StoredProcedure1 Has Too Many Arguments Specified
Hi,

I keep on getting the same error for my stored procedure:System.Data.SqlClient.SqlException: Procedure or function StoredProcedure1 has too many arguments specified.The procedure itself looks like this:@imie varchar(255), @nazwisko varchar(255), @email varchar(255), @username varchar(255), @password varchar(255), @id_roli Int, @PESEL varchar(11), @ulica text, @numer_domu int, @numer_mieszkania int, @kod_pocztowy varchar(7), @miasto text, @telefon text, @id_kandydat int, @id_kierunku int, @id_stan int ASBeginSet nocount on Insert into Uzytkownik (imie, nazwisko, email, username, password, id_roli, PESEL, ulica, numer_domu, numer_mieszkania, kod_pocztowy, miasto, telefon) values ( @imie, @nazwisko, @email, @username, @password, @id_roli, @PESEL, @ulica, @numer_domu, @numer_mieszkania, @kod_pocztowy, @miasto, @telefon) select @id_kandydat=@@IDENTITY Insert into Kandydat_na_Kierunek (id_kandydat, id_kierunku, id_stan) Values (@id_kandydat, @id_kierunku, @id_stan) SET NOCOUNT OFF ENDand the code that uses it: SqlConnection con; con = new SqlConnection("Data Source=ELF;Initial Catalog=logos;Integrated Security=True"); SqlCommand cmd = new SqlCommand("StoredProcedure1", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@imie", TextBox3.Text)); cmd.Parameters.Add(new SqlParameter("@nazwisko", TextBox4.Text)); cmd.Parameters.Add(new SqlParameter("@email", TextBox6.Text)); cmd.Parameters.Add(new SqlParameter("@username", Label2.Text)); cmd.Parameters.Add(new SqlParameter("@password", Label1.Text)); cmd.Parameters.Add(new SqlParameter("@id_roli", '1')); cmd.Parameters.Add(new SqlParameter("@PESEL", TextBox5.Text)); cmd.Parameters.Add(new SqlParameter("@ulica", TextBox8.Text)); cmd.Parameters.Add(new SqlParameter("@numer_domu", TextBox9.Text)); cmd.Parameters.Add(new SqlParameter("@numer_mieszkania", TextBox10.Text)); cmd.Parameters.Add(new SqlParameter("@kod_pocztowy", TextBox11.Text)); cmd.Parameters.Add(new SqlParameter("@miasto", TextBox12.Text)); cmd.Parameters.Add(new SqlParameter("@telefon", TextBox13.Text)); if (DropDownList1.SelectedValue == "1") { } else { cmd.Parameters.Add(new SqlParameter("@id_kierunku", DropDownList1.SelectedValue)); cmd.Parameters.Add(new SqlParameter("@id_stan", '1')); } if (DropDownList2.SelectedValue == "1") { } else { cmd.Parameters.Add(new SqlParameter("@id_kierunku", DropDownList2.SelectedValue)); cmd.Parameters.Add(new SqlParameter("@id_stan", '1')); } if (DropDownList3.SelectedValue == "1") { } else { cmd.Parameters.Add(new SqlParameter("@id_kierunku", DropDownList3.SelectedValue)); cmd.Parameters.Add(new SqlParameter("@id_stan", '1')); } con.Open(); cmd.ExecuteNonQuery(); con.Close();Could somebody explain what is wrong with this? I dpn't really unserstand the meaning of error. Any help will be apreaciated.Regards,N.

View Replies !

Procedure Or Function SavePhotoHotelLang Has Too Many Arguments Specified.
Hi all I having suffering from a strange behavior when trying to update. I receive the following error :

Here is my code: Procedure or function SavePhotoHotelLang has too many arguments specified.

<asp:SqlDataSource ID="SqlDataSourceHotelPhotoList" runat="server" ConnectionString="<%$ ConnectionStrings:smileDBConnectionString %>"SelectCommand="SELECT phl.PhotoHotelLangId, ph.smallfilepath, ph.photorank, pht.Type, phl.name, phl.description, ph.PhotoHotelId FROM datPhotoHotel ph
INNER JOIN datPhotoHotelType pht ON ph.PhotoHotelTypeId = pht.PhotoHotelTypeId
LEFT OUTER JOIN datPhotoHotelLang phl on ph.PhotoHotelId = phl.PhotoHotelId WHERE HotelId = @HotelId and ( LanguageId = @languageId or LanguageId is null)"
UpdateCommand="SavePhotoHotelLang" UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:QueryStringParameter Name="HotelId" QueryStringField="HotelId" Type="int32" />
<asp:ControlParameter Name="languageId" ControlID="ddlLanguageForGV" PropertyName="SelectedValue" Type="int32" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="name"/>
<asp:Parameter Name="Description" />
<asp:ControlParameter Name="languageId" ControlID="ddlLanguageForGV" PropertyName="SelectedValue"/>
<asp:Parameter Name="PhotoHotelLangId" />
<asp:Parameter Name="PhotoHotelId" />
</UpdateParameters>
</asp:SqlDataSource>
<Grids:BulkEditGridView
ID="GvHotelPhotoList" runat="server"
DataSourceID="SqlDataSourceHotelPhotoList" AutoGenerateColumns="false" SaveButtonID="saveBtn"
DataKeyNames="PhotoHotelLangId, PhotoHotelId">
<Columns>
<asp:TemplateField>
<itemtemplate>
<asp:Image id="smallimage" runat="server" ImageUrl='<%# Eval("smallFilePath") %>'></asp:Image>
</itemtemplate>
<Edititemtemplate>
<asp:Image id="smallimageedit" runat="server" ImageUrl='<%# Eval("smallFilePath") %>'></asp:Image>
</Edititemtemplate>
</asp:TemplateField>
<asp:BoundField DataField="Name" HeaderText="Name"/>
<asp:BoundField DataField="Description" FooterText="Description"/>
<asp:BoundField DataField="photorank" HeaderText="Rank" ReadOnly="true"/>
<asp:BoundField DataField="Type" FooterText="Type" ReadOnly="true"/>
</Columns></Grids:BulkEditGridView>
">'>'>
alter procedure SavePhotoHotelLang         @name varchar(100),                                        @Description varchar(500),                                        @languageId int,                                        @PhotoHotelLangId int,                                        @PhotoHotelId intasbegin
        if ( @PhotoHotelLangId is null )        begin
                        insert into dbo.datPhotoHotelLang (                        name,                        Description,                        languageId                        )                        values (@name,                        @Description,                        @languageId,                        @PhotoHotelId)        end        else        begin
                        update dbo.datPhotoHotelLang    set name = @name,                                                            Description = @Description                                                        where PhotoHotelLangId = @PhotoHotelLangId
        endend

View Replies !

Procedure Or Function DeleteSender Has Too Many Arguments Specified.
I'm Deleting my record in the database using stored procedure and I'm always getting this error :Procedure or function DeleteSender has too many arguments specified. same as I insert record... here's my stored proc for delete:set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[DeleteSender]@RecNo int ASDELETE FROM [Sender] WHERE [RecNo] = @RecNo for insert:set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[InsertSender](@SenderID nvarchar(50), @SenderLastName nvarchar(50), @SenderFirstName nvarchar(50), @SenderAddress nvarchar(50), @SenderCity nvarchar(50), @SenderState nvarchar(25), @SenderZip nvarchar(10), @SenderTel nvarchar(25), @FS int, @TB int, @Status nvarchar(10), @EndBalance money)ASINSERT INTO [Sender] ([SenderID], [SenderLastName], [SenderFirstName], [SenderAddress], [SenderCity], [SenderState], [SenderZip], [SenderTel], [FS], [TB], [Status], [EndBalance]) VALUES (@SenderID, @SenderLastName, @SenderFirstName, @SenderAddress, @SenderCity, @SenderState, @SenderZip, @SenderTel, @FS, @TB, @Status, @EndBalance) aspx:<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %><%@ Register src="FormControl.ascx" TagName="FormControl" TagPrefix="uc1" %><%@ Register Assembly="RadGrid.Net2" Namespace="Telerik.WebControls" TagPrefix="radG" %><%@ Register Assembly="RadComboBox.Net2" Namespace="Telerik.WebControls" TagPrefix="radC" %><%@ Register Assembly="RadInput.Net2" Namespace="Telerik.WebControls" TagPrefix="radI" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server"> <title>Sender</title> <link href="sender.css" rel="stylesheet" type="text/css" /></head><body> <form id="form1" runat="server"> <div class="wrapper"> <div class="banner"> <radG:RadGrid ID="rgSender" runat="server" GridLines="None" DataSourceID="sqlDataSource1" EnableAJAX="True" ShowStatusBar="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowAutomaticDeletes="True" Skin="3D" AutoGenerateColumns="False"> <MasterTableView CommandItemDisplay="Top" DataKeyNames="RecNo" DataSourceID="sqlDataSource1"> <ExpandCollapseColumn Visible="False"> <HeaderStyle Width="19px" /> </ExpandCollapseColumn> <RowIndicatorColumn Visible="False"> <HeaderStyle Width="20px" /> </RowIndicatorColumn> <EditFormSettings EditFormType="Template"> <FormTemplate> <table border="0"> <tr> <td> <asp:Label ID="Label1" runat="server" Text="Record No.:" Visible='<%# rgSender.EditIndexes.Count > 0 %>'></asp:Label></td> <td> <radI:RadTextBox ID="rtbRecNo" runat="server" Text='<%# Bind("RecNo") %>' Visible='<%# rgSender.EditIndexes.Count > 0 %>'> </radI:RadTextBox></td> <td> <asp:Label ID="Label8" runat="server" Text="Zip Code:"></asp:Label></td> <td> <radI:RadTextBox ID="rtbZip" runat="server" Text='<%# Bind("SenderZip") %>'> </radI:RadTextBox></td> </tr> <tr> <td> <asp:Label ID="Label2" runat="server" Text="Sender ID:"></asp:Label></td> <td><radI:RadTextBox ID="rtbSenderID" runat="server" Text='<%# Bind("SenderID") %>'> </radI:RadTextBox></td> <td> <asp:Label ID="Label9" runat="server" Text="Telephone #:"></asp:Label></td> <td><radI:RadTextBox ID="rtbTel" runat="server" Text='<%# Bind("SenderTel") %>'> </radI:RadTextBox></td> </tr> <tr> <td><asp:Label ID="Label3" runat="server" Text="First Name:"></asp:Label></td> <td><radI:RadTextBox ID="rtbFName" runat="server" Text='<%# Bind("SenderFirstName") %>'> </radI:RadTextBox></td> <td> <asp:Label ID="Label10" runat="server" Text="Total Free Sent:"></asp:Label></td> <td><radI:RadTextBox ID="rtbFS" runat="server" Text='<%# Bind("FS") %>'> </radI:RadTextBox></td> </tr> <tr> <td><asp:Label ID="Label4" runat="server" Text="Last Name:"></asp:Label></td> <td><radI:RadTextBox ID="rtbLName" runat="server" Text='<%# Bind("SenderLastName") %>'> </radI:RadTextBox></td> <td><asp:Label ID="Label11" runat="server" Text="Total Box Sent:"></asp:Label></td> <td> <radI:RadTextBox ID="rtbBS" runat="server" Text='<%# Bind("TB") %>'> </radI:RadTextBox></td> </tr> <tr> <td> <asp:Label ID="Label5" runat="server" Text="Address:"></asp:Label></td> <td><radI:RadTextBox ID="rtbAddress" runat="server" Text='<%# Bind("SenderAddress") %>'> </radI:RadTextBox></td> <td><asp:Label ID="Label12" runat="server" Text="Status:"></asp:Label></td> <td><radI:RadTextBox ID="rtbStatus" runat="server" Text='<%# Bind("Status") %>'> </radI:RadTextBox></td> </tr> <tr> <td><asp:Label ID="Label6" runat="server" Text="City:"> </asp:Label></td> <td> <radI:RadTextBox ID="rtbCity" runat="server" Text='<%# Bind("SenderCity") %>'> </radI:RadTextBox></td> <td><asp:Label ID="Label13" runat="server" Text="End Balance:"></asp:Label></td> <td><radI:RadTextBox ID="rtbEndBalance" runat="server" Text='<%# Bind("EndBalance") %>'> </radI:RadTextBox></td> </tr> <tr> <td> <asp:Label ID="Label7" runat="server" Text="State:"></asp:Label></td> <td><radI:RadTextBox ID="rtbState" runat="server" Text='<%# Bind("SenderState") %>'> </radI:RadTextBox> </td> <td> <asp:Button ID="btnUpdate" Text='<%# IIf(CType(Container,GridItem).OwnerTableView.IsItemInserted,"Insert","Update") %>' runat="server" CommandName='<%# IIf(CType(Container,GridItem).OwnerTableView.IsItemInserted,"PerformInsert","Update") %>'></asp:Button>   <asp:Button ID="btnCancel" Text="Cancel" runat="server" CausesValidation="False" CommandName="Cancel"></asp:Button></td> </tr> </table> </FormTemplate> </EditFormSettings> <Columns> <radG:GridEditCommandColumn ButtonType="ImageButton"/> <radG:GridTemplateColumn HeaderText="Sender ID" UniqueName="TCSenderID"> <ItemTemplate> <asp:Label ID="lblSenderID" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "SenderID") %>'></asp:Label> </ItemTemplate> </radG:GridTemplateColumn> <radG:GridTemplateColumn HeaderText="First Name" UniqueName="TCSenderFName"> <ItemTemplate> <asp:Label ID="lblSenderFName" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "SenderFirstName") %>'></asp:Label> </ItemTemplate> </radG:GridTemplateColumn> <radG:GridTemplateColumn HeaderText="Last Name" UniqueName="TCSenderLName"> <ItemTemplate> <asp:Label ID="lblSenderLName" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "SenderLastName") %>'></asp:Label> </ItemTemplate> </radG:GridTemplateColumn> <radG:GridButtonColumn UniqueName="ButtonColumn" ConfirmText="Are you sure?" Text="Delete" CommandName="Delete" ButtonType="ImageButton" ImageUrl="RadControls/Grid/Skins/Default/Delete.gif" /> </Columns> </MasterTableView> </radG:RadGrid></div> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConString_TO_Cargo %>" SelectCommandType="StoredProcedure" SelectCommand="sp_SelectSender" DeleteCommandType="StoredProcedure" DeleteCommand="DeleteSender" InserCommandType="StoredProcedure" InsertCommand="InsertSender" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE [Sender] SET [SenderID] = @SenderID, [SenderLastName] = @SenderLastName, [SenderFirstName] = @SenderFirstName, [SenderAddress] = @SenderAddress, [SenderCity] = @SenderCity, [SenderState] = @SenderState, [SenderZip] = @SenderZip, [SenderTel] = @SenderTel, [FS] = @FS, [TB] = @TB, [Status] = @Status, [EndBalance] = @EndBalance WHERE [RecNo] = @original_RecNo AND [SenderID] = @original_SenderID AND [SenderLastName] = @original_SenderLastName AND [SenderFirstName] = @original_SenderFirstName AND [SenderAddress] = @original_SenderAddress AND [SenderCity] = @original_SenderCity AND [SenderState] = @original_SenderState AND [SenderZip] = @original_SenderZip AND [SenderTel] = @original_SenderTel AND [FS] = @original_FS AND [TB] = @original_TB AND [Status] = @original_Status AND [EndBalance] = @original_EndBalance"> <DeleteParameters> <asp:Parameter Name="RecNo" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="SenderID" Type="String" /> <asp:Parameter Name="SenderLastName" Type="String" /> <asp:Parameter Name="SenderFirstName" Type="String" /> <asp:Parameter Name="SenderAddress" Type="String" /> <asp:Parameter Name="SenderCity" Type="String" /> <asp:Parameter Name="SenderState" Type="String" /> <asp:Parameter Name="SenderZip" Type="String" /> <asp:Parameter Name="SenderTel" Type="String" /> <asp:Parameter Name="FS" Type="Int32" /> <asp:Parameter Name="TB" Type="Int32" /> <asp:Parameter Name="Status" Type="String" /> <asp:Parameter Name="EndBalance" Type="Decimal" /> <asp:Parameter Name="original_RecNo" Type="Int32" /> <asp:Parameter Name="original_SenderID" Type="String" /> <asp:Parameter Name="original_SenderLastName" Type="String" /> <asp:Parameter Name="original_SenderFirstName" Type="String" /> <asp:Parameter Name="original_SenderAddress" Type="String" /> <asp:Parameter Name="original_SenderCity" Type="String" /> <asp:Parameter Name="original_SenderState" Type="String" /> <asp:Parameter Name="original_SenderZip" Type="String" /> <asp:Parameter Name="original_SenderTel" Type="String" /> <asp:Parameter Name="original_FS" Type="Int32" /> <asp:Parameter Name="original_TB" Type="Int32" /> <asp:Parameter Name="original_Status" Type="String" /> <asp:Parameter Name="original_EndBalance" Type="Decimal" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="SenderID" Type="String" /> <asp:Parameter Name="SenderLastName" Type="String" /> <asp:Parameter Name="SenderFirstName" Type="String" /> <asp:Parameter Name="SenderAddress" Type="String" /> <asp:Parameter Name="SenderCity" Type="String" /> <asp:Parameter Name="SenderState" Type="String" /> <asp:Parameter Name="SenderZip" Type="String" /> <asp:Parameter Name="SenderTel" Type="String" /> <asp:Parameter Name="FS" Type="Int32" /> <asp:Parameter Name="TB" Type="Int32" /> <asp:Parameter Name="Status" Type="String" /> <asp:Parameter Name="EndBalance" Type="Decimal" /> </InsertParameters> </asp:SqlDataSource> <br /> <radG:RadGrid ID="rgSenderDetails" runat="server" AutoGenerateColumns="False" GridLines="None"> <MasterTableView> <ExpandCollapseColumn Visible="False"> <HeaderStyle Width="19px" /> </ExpandCollapseColumn> <RowIndicatorColumn Visible="False"> <HeaderStyle Width="20px" /> </RowIndicatorColumn> </MasterTableView> </radG:RadGrid><br /> </div> </form></body></html> hope you can help me guys/// stings...

View Replies !

Procedure Or Function InsertUpdateArtist_Tracks Has Too Many Arguments Specified.
Hi
While coding with ASP.NET 2.0 I came across this error "Procedure or function InsertUpdateArtist_Tracks has too many arguments specified."
Its quite frustrating because I dont know what arguments are being referred to because I've clearly assigned the correct parameters with their correct values to this Stored procedure :InsertUpdateArtist_Tracks
Please can some help me with this? is there something fundamentality wrong with my code (Below) or is this a know Microsoft stuff up?
or by the way I'm using SQL Server 2005 and ASP.NET 2.0
Below is my sample code:
..............
'Insert or Update Artist_tracks table
Response.Write("<br><b>Inserting or Updating Artist_tracks table</b>")
AT_Title = SearchArtistsResults(i).title
AT_Meta_ID = SearchArtistsResults(i).meta_id
AT_AA_ID = AA_ID
Dim ParamTitle As SqlParameter
Dim ParamMeta As SqlParameter
Dim ParamAA_ID As SqlParameter
dbCommand.CommandText = "InsertUpdateArtist_Tracks"
dbCommand.CommandType = Data.CommandType.StoredProcedure
dbCommand.Connection = conn
ParamTitle = dbCommand.Parameters.Add(New SqlParameter("@AT_Title", Data.SqlDbType.VarChar, 50))
ParamTitle.Value = AT_Title
ParamTitle.Direction = Data.ParameterDirection.Input
Response.Write("<br>Sent through this Title =" & AT_Title)
ParamMeta = dbCommand.Parameters.Add(New SqlParameter("@AT_Meta_ID", Data.SqlDbType.Int))
ParamMeta.Value = AT_Meta_ID
ParamMeta.Direction = Data.ParameterDirection.Input
Response.Write("<br>Sent through this Meta_id =" & AT_Meta_ID)
ParamAA_ID = dbCommand.Parameters.Add(New SqlParameter("@AT_AA_ID", Data.SqlDbType.Int))
ParamAA_ID.Value = AT_AA_ID
ParamAA_ID.Direction = Data.ParameterDirection.Input
Response.Write("<br>Sent through this AT_AA_ID =" & AT_AA_ID)
conn.Open()
dbCommand.ExecuteNonQuery()
conn.Close()
..................

Thanks in Advance

View Replies !

Procedure Or Function ImportLand Has Too Many Arguments Specified
Can anybody help me with this error? I am not even sure where to start looking.

i am looping through an arrayList that populates the SqlParameters. I open the database outside the loop, close it outside the loop and execute myCommand.ExecuteNonQuery(); inside the loop for every loop.

The error I am getting is:

System.Data.SqlClient.SqlException: Procedure or function ImportData has too many arguments specified.

Thanks!

View Replies !

Procedure Or Function Recoms Has Too Many Arguments Specified
my sql procedure is like below

select * from tbl where ID in (@IDs)

for example @IDs is "11,23,44,55,66,77,88,99,223,223,445,666"
So it has alot of arguments.sometimes it can be too long

that's the reason to get error message

What must I do ?

View Replies !

Procedure Or Function Login Has Too Many Arguments Specified

i wrote a simply code but i got error " Procedure or function Login has too many

arguments specified." i need help.......

(c# code- stored procedure is below c# code)

--------------

SqlConnection conn = new SqlConnection("data source=cafe06\sqlexpress;initial catalog=ferixxx;Integrated Security=True");

SqlCommand sqlcom = new SqlCommand("Login", conn);

sqlcom.CommandType = CommandType.StoredProcedure;

sqlcom.Parameters.Add("@user", SqlDbType.NVarChar,50 );

sqlcom.Parameters[0].Value = user.Text;--->>>(textbox)

sqlcom.Parameters.Add("@password", SqlDbType.NVarChar,50);

sqlcom.Parameters[1].Value = password.Text;--->>>(textbox)

SqlDataAdapter adap = new SqlDataAdapter(sqlcom);

DataTable table = new DataTable();

conn.Open();

adap.Fill(table);

datag.DataSource = table;
datag.DataBind();

conn.Close();

stored procedure

create procedure [Login]

@user nvarchar(50),
@password nvarchar(50)
AS

select *from members where user=@user and password=@password

GO

View Replies !

Procedure Or Function Sp_MSupdatesysmergearticles Has Too Many Arguments Specified.
Hi,

I've been on this one all day - and now tearing my hair out. I have a large SQL2005 database (migrated from SQL2000) which I'm trying to replicate using a VB6 front end.

The application and database concerned have been working with no problems using merge replication for the last 5 years - however, I now need to port to SQL 2005.

In the VB6 app, I'm using the SQLMerge9 control to handle the replication side of things. The code I'm using is exactly as per the code which works under SQL 2000, however, I'm getting an error message "Procedure or function sp_MSupdatesysmergearticles has too many arguments specified." when I try to initialize the subscription.

I've seen one other item on the web with this problem, and this was someone trying to replicate a 2005 client with a 2000 server. I'm using SQL2005 both ends with merge replication -the replication is set up for SQL2005 clients only, and the database (which incidentally is being created on the subscriber correctly) is in SQL2005 compatibility mode.

Any help would be gratefully appreciated - I haven't got much hair left now.

The code I'm using is as follows:

On Error GoTo Err_Handler

    Set SQLMergeCtl = New SQLMerge
    Dim strSQL As String
    Dim cnn As ADODB.Connection

      ' add subscriber
    strSQL = "EXEC sp_dropsubscriber '[subscriber name]'"
    Set cnn = New ADODB.Connection
    cnn.Open [connection string]

    strSQL = "EXEC sp_addsubscriber '[machine name]', 0 , '[user name]', '[password]', @security_mode = 0"
    On Error Resume Next
    cnn.Execute strSQL

    If Err <> 0 Then
        MsgBox Error
    End If

    strSQL = "sp_dropmergesubscription @publication = '[publication name], @subscriber = '[machine name]', @subscriber_db = '[subscriber database name]', @subscription_type = 'pull'"
    cnn.Execute strSQL
    If Err <> 0 Then
        MsgBox Error
    End If


    On Error GoTo Err_Handler
    cnn.Close
    Set cnn = Nothing

    SQLMergeCtl.Publisher = [publisher name]

    SQLMergeCtl.PublisherSecurityMode = DB_AUTHENTICATION
    SQLMergeCtl.PublisherDatabase = [database name]
    SQLMergeCtl.Publication = [publication name]
    SQLMergeCtl.PublisherLogin = [user name]
    SQLMergeCtl.PublisherPassword = [password]

    SQLMergeCtl.DistributorSecurityMode = DB_AUTHENTICATION
    SQLMergeCtl.Distributor = [distributor name - actually same as the publisher]
    SQLMergeCtl.DistributorLogin = [user name]
    SQLMergeCtl.DistributorPassword =[password]


    SQLMergeCtl.Subscriber = [local machine name]
    SQLMergeCtl.SubscriberSecurityMode = DB_AUTHENTICATION
    SQLMergeCtl.SubscriberLogin = [local user name]
    SQLMergeCtl.SubscriberPassword =[local password]
    SQLMergeCtl.SubscriberDatabase = [local database name]
    SQLMergeCtl.SubscriptionType = PULL
    SQLMergeCtl.ProfileName =[profile name]

    On Error Resume Next
    SQLMergeCtl.AddSubscription CREATE_DATABASE, NONE
    If Err <> 0 Then
        <--snip-->
    End If

    On Error GoTo Err_Handler
    SQLMergeCtl.Initialize
    'Run
    SQLMergeCtl.Run
    'Terminate
    SQLMergeCtl.Terminate

   <--snip-->
          code here to add merge agent removed for brevity - it's not getting this far anyway
   <--snip>

Exit_Handler:
     Exit Sub
Err_Handler:
    MsgBox Error
      Resume Exit_Handler

View Replies !

'Query Failed For The Datatset Reportsource.Procedure Of Function Has Too Many Arguments Specified'

I get an error like 'Query failed for the datatset Reportsource.Procedure of function has too many arguments specified.'
What could be the reason for this error??
please help me

View Replies !

Using Stored Procedure Arguments
Hello. I am pretty new to SQL Stored Procedure, and ran into a problem. I am guessing there is a simple solution to this, as I am self-teaching myself this stuff.

I currently have a procedure that creates a new table, by reading in columns from a variety of Linked Servers (ODBC connection to to Sybase databases)

I will want to generalize a procedure by setting as arguments the ODBC connection name and the name of the new table that will be created ("CREATE TABLE") so I can pass these in.

As a test of this idea, I created this as a simple procedure, but I get a syntax error when I try to Check Syntax this. Do I have to do something else when I reference the string "argu1" to specify a new table name, or an OPEN QUERY Linked table name? Thanks and Happy New Year!

CREATE PROCEDURE gis.pr_PARCEL_TEST( @argu1 char(25)) AS
CREATE TABLE @argu1
GO

View Replies !

Too Many Arguments In Stored Procedure?

Hello,

When I try to call a stored procedure I get an SQL-exception reading "Procedure or function insert_member has too many arguments specified."

As far as I can see the number of parameters in the application match the number of arguments in the stored procedure. I supply 10 parameters in the application and 10 in the procedure. Is the location of the declaration of the argument cgpID a problem?

ALTER PROCEDURE [dbo].[insert_member]

(

@mbrFirstName nvarchar(15),

@mbrLastName nvarchar(15),

@mbrStreetAddress nvarchar(15),

@mbrPostalAddress nvarchar(15),

@mbrTelephoneHome nvarchar(15),

@mbrTelephoneJob nvarchar(15),

@mbrEmail nvarchar(15),

@mbrActivityGroupID int,

@mbrPaymentMethod int

)

AS

INSERT INTO dbo.member(mbrFirstName, mbrLastName, mbrStreetAddress, mbrPostalAddress, mbrTelephoneHome, mbrTelephoneJob, mbrEmail)

VALUES (@mbrFirstName, @mbrLastName, @mbrStreetAddress, @mbrPostalAddress, @mbrTelephoneHome, @mbrTelephoneJob, @mbrEmail)

declare @cgpID int

set @cgpID = (select cgpID from currentgroup where cgpActivityGroupID = @cgpActivityGroupID)

INSERT INTO member_currentgroup

(mbrID, cgpID, mcgPaymentMethod)

values

(@@identity, @cgpID, @mcgPaymentMethod)

View Replies !

Stored Procedure- Passing Arguments
I have the following stored procedure
ALTER PROCEDURE dbo.TextEntered
@searchString varchar(30)
/*
(
@parameter1 datatype = default value,
@parameter2 datatype OUTPUT
)
*/
AS
Select GAVPrimaryKey, NAME from towns where NAME like @searchString order by NAME

RETURN
doesn't work!!!!
I would like to produce the following where s is @searchString:
Select GAVPrimaryKey, NAME from towns where NAME like 's%' order by NAME
Any ideas how I might acomplish this I have tried almost everything !

View Replies !

ASP/SQL Stored Procedure/ASP Function Error
Hey I have the following Stored Procedure

CREATE PROCEDURE spGetOrderCount
(
@search varchar(1000) = default
)

AS

SET NOCOUNT ON

/* Setup search string */
IF (@search <> '')
BEGIN
SET @search = 'WHERE' + @search
END

/* Create a temporary table */
CREATE TABLE #TempTable
(
row int IDENTITY,
totalCount int
)

/* Insert the search results into query */
EXEC
(
'INSERT INTO #TempTable([totalCount])' +
'SELECT COUNT(*) AS totalCount ' +
'FROM tblOrders' + @search
)

/* Extract the wanted records from the temporary table */
SELECT[totalCount],
RecordsLeft =
(
SELECT COUNT(*)
FROM #TempTable TI
)
FROM#TempTable

SET NOCOUNT OFF

RETURN
;
GO

And then the following function which specifies the where clause of the statement

function getOrderCount(strDate, strStatusList)
getOrderCount = 0
dim objRS, objSP, strWhereClause

if isDate(strDate) and len(strStatusList) > 0 then
'# Filter on order status

'# Filter on date clause
strWhereClause = "(tblOrders.orderDate >= " & sqlServerDate(strDate) & ")"

'#GET order count
Set objSP = SQLGetProcedure("spGetOrderCount")
SQLSetProcedureParam objSP, "search", strWhereClause

Set objRS = SQLExecuteProcedure(objSP)

if not objRS.eof then
getOrderCount = objRS("totalCount")
end if

'# Free resources
deleteRecordset(objRS)
deleteObject(objSP)
end if

end function

When I do this together I get the following error on my ASP Page

Microsoft OLE DB Provider for SQL Server error '80040e14'

Line 1: Incorrect syntax near '.'.

/sigma_eircommobdispatch/server/database.asp, line 235

And the print out of the resulting string from the function is

(tblOrders.orderDate >= CONVERT(DATETIME, '2007-7-13', 102))

If i remove the Where clause the statement works fine..

Any ideas

View Replies !

Variable Number Of Arguments In A Stored Procedure
Can a Sql Server SP have variable number of arguments??? If yes, can somebody point me to a resource demonstrating that??? I need to send variable number of arguments to some of my SPs & iterate them with either foreach or traditional for loop. Any support would be greatly appreciated.

If variable number of arguments are not feasible, then can I pass them as an array to the SP (again a Sample code would be desirable)???

View Replies !

Stored Procedure Into GridView
Info: (vs 2005, sql server 2005, asp 2.0, C# project)I need to pass a variable from my web form to a stored procedure which should return a dataset to a gridview.My stored proc works fine but it’s not returning properly (or at all). Here is my stored proc:set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[HrsUsed]
-- Add the parameters for the stored procedure here
@idUser INT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here

SELECT DATENAME(mm, leaveDate) + ' ' + DATENAME(yyyy, leaveDate) AS 'Leave Date', totalV, totalS
FROM tblLeave
WHERE idUser = @idUser
ORDER BY leaveDate DESC

RETURN

END
Here is my code: try
{
SqlConnection cxnHrsUsed = new SqlConnection(ConfigurationManager.ConnectionStrings["cxnLeaveRecords"].ConnectionString);

SqlCommand cmdHrsUsed = new SqlCommand("HrsUsed", cxnHrsUsed);
cmdHrsUsed.CommandType = CommandType.StoredProcedure;

cmdHrsUsed.Parameters.Add("@idUser", SqlDbType.Int).Direction = ParameterDirection.Input;
cmdHoursUsed.Parameters["@idUser"].Value = Session["sessionUserID"];

cmdHrsUsed.Connection.Open();

gvHrsUsed.DataSource = cmdHrsUsed.ExecuteReader();
gvHrsUsed.DataBind();
cmdHrsUsed.Connection.Close();

}
catch (Exception ex)
{
lblStatus.Text = ex.Message;
} I can see the caption of the gridview, but no data below it. Any ideas?

View Replies !

Procedure Or Function 'stored Procedure Name' Expects Parameter Which Was Not Supplied
Has anyone encountered this before?
Procedure or Function 'stored procedure name' expects parameter '@parameter', which was not supplied.
It seems that my code is not passing the parameter to the stored procedure.
When I click this hyperlink:
<asp:HyperLink
ID="HyperLink1"
Runat="server"
NavigateUrl='<%# "../Division.aspx?CountryID=" + Eval("CountryID")%>'
Text='<%# Eval("Name") %>'
ToolTip='<%# Eval("Description") %>'
CssClass='<%# Eval("CountryID").ToString() == Request.QueryString["CountryID"] ? "CountrySelected" : "CountryUnselected" %>'>
</asp:HyperLink>
it is suppose to get the country name and description, based on the country id.
I am passing the country id like this.
protected void Page_Load(object sender, EventArgs e)
{
PopulateControls();
}
private void PopulateControls()
{
string countryId = Request.QueryString["CountryID"];
if (countryId != null)
{
CountryDetails cd = DivisionAccess.GetCountryDetails(countryId);
divisionNameLabel.Text = cd.Name;
divisionDescriptionLabel.Text = cd.Description;
}
}
To my app code like this:
public struct CountryDetails
{
public string Name;
public string Description;
}
public static class DivisionAccess
{
static DivisionAccess()
public static DataTable GetCountry()
{
DbCommand comm = GenericDataAccess.CreateCommand();
comm.CommandText = "GetCountry";
return GenericDataAccess.ExecuteSelectCommand(comm);
}
public static CountryDetails GetCountryDetails(string cId)
{
DbCommand comm = GenericDataAccess.CreateCommand();
comm.CommandText = "GetCountryDetails";
DbParameter param = comm.CreateParameter();
param.ParameterName = "@CountryID";
param.Value = 2;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
DataTable table = GenericDataAccess.ExecuteSelectCommand(comm);
CountryDetails details = new CountryDetails();
if (table.Rows.Count > 0)
{
details.Name = table.Rows[0]["Name"].ToString();
details.Description = table.Rows[0]["Description"].ToString();
}
return details;
}

As you can see I have two stored procedures I am calling, one does not have a parameter and the other does. The getcountry stored procedure returns the list of countries in a menu that I can click to see the details of that country. That is where my problem is when I click the country name I get
Procedure or Function 'GetCountryDetails' expects parameter '@CountryID', which was not supplied
Someone please help!

Thanks Nickdel68

View Replies !

Argument Not Specified For Parameter 'arguments' Of Public Function Select(arguments As System.Web.DatasourceSelect Arguments As Collections Ienumerable
I have an SqlDataSource control on my aspx page, this is connected to database by a built in procedure that returns a string dependent upon and ID passed in.
I have the followinbg codewhich is not complet, I woiuld appriciate any help to produce the correct code for the code file
Function GetCategoryName(ByVal ID As Integer) As String sdsCategoriesByID.SelectParameters("ID").Direction = Data.ParameterDirection.Input sdsCategoriesByID.SelectParameters.Item("ID").DefaultValue = 3 sdsCategoriesByID.Select() <<<< THIS LINE COMES UP WITH ERROR 1End Function
ERROR AS FOLLOWS
argument not specified for parameter 'arguments' of public function Select(arguments as System.Web.DatasourceSelect Arguments as Collections ienumerable

Help I have not got much more hair to loose
Thanks Steve

View Replies !

Deleting A Row Using A Stored Procedure From A GridView
I am trying to do something that I would think is simple. I have a stored procedure used for deleting a record, and I want to call it from the "Delete" command of a Delete button on a GridView. This incredible simple SP accepts one value, the unique record ID to delete the record like this:CREATE PROCEDURE usp_DeleteBox
/* *******************************************
Delete a record using the Passed ID.
********************************************** */
(
@pID as int = Null
)
AS

DELETE FROM [Boxes]
WHERE ID = @pID
When I configured the data source for the GridView, I selected the "Delete" tab and selected my Stored Procedure from the list. As mentioned on another post I saw here, I set the "DataKeyNames" property of the GridView to my id field (called "ID", naturally).
When I click the Delete button on a row, I get this error message: "Procedure or function usp_DeleteBox has too many arguments specified." If I leave the "DataKeyNames" property empty, it does nothing when I click delete.
Can someone tell me the correct way to configure this? I am sure I am missing something obvious, and I would appreciate any suggestions. Thank you!

View Replies !

Insert Stored Procedure With Error Check And Transaction Function
Hi, guys
I try to add some error check and transaction and rollback function on my insert stored procedure but I have an error "Error converting data type varchar to smalldatatime" if i don't use /*error check*/ code, everything went well and insert a row into contract table.
could you correct my code, if you know what is the problem?

thanks

My contract table DDL:
************************************************** ***

create table contract(
contractNum int identity(1,1) primary key,
contractDate smalldatetime not null,
tuition money not null,
studentId char(4) not null foreign key references student (studentId),
contactId int not null foreign key references contact (contactId)
);

My insert stored procedure is:
************************************************** *****

create proc sp_insert_new_contract
( @contractDate[smalldatetime],
@tuition [money],
@studentId[char](4),
@contactId[int])
as

if not exists (select studentid
from student
where studentid = @studentId)
begin
print 'studentid is not a valid id'
return -1
end

if not exists (select contactId
from contact
where contactId = @contactId)
begin
print 'contactid is not a valid id'
return -1
end
begin transaction

insert into contract
([contractDate],
[tuition],
[studentId],
[contactId])
values
(@contractDate,
@tuition,
@studentId,
@contactId)

/*Error Check */
if @@error !=0 or @@rowcount !=1
begin
rollback transaction
print ‘Insert is failed’
return -1
end
print ’New contract has been added’

commit transaction
return 0
go

View Replies !

Passing Values From A Gridview To A Stored Procedure
Hello. im tryinng to build an application that has a girdview with values from 2 different tables. The select query i have used in a stored procedure works great but when i try to write something to update into 2 different tables I cant figure out how to do it.
This is the first time im writing stored procedures but from what i can tell i need to do 2 seperate updates to insert mu values.
im using the AdventureWorksLT database provided by microsoft to experiment with and my gridview consists of 2 tables populated by the following stored procedure:ALTER PROCEDURE dbo.GetSomething AS
SELECT Customer.CustomerID, Customer.LastName, Customer.FirstName, CustomerAddress.AddressID, CustomerAddress.AddressType FROM SalesLT.Customer, SalesLT.CustomerAddress
WHERE Customer.CustomerID = CustomerAddress.CustomerID

RETURN
What id like to do is to make the GridView editable and then send the all thee values back so the changes are saved in both tables. Could anyone help me write a stored procedure that gets the values from the fields in the gridview that is beeing changed and send them back to the tables?

View Replies !

Sorting GridView With ASC/DESC When Using Stored Procedure???
I have a stored procedure in my SQL 2005 Server database named Foo that accepts two parameters, @paramA and @paramB.In my ASP.NET page, I have these:<asp:GridView id="gv" runat="server" AutoGenerateColumns="true" DataSourceID="DS" AllowSorting="true" DataKeyNames="ID"/><asp:SqlDataSource ID="DS" runat="server" ConnectionString="<%$ ConnectionStrings:CS1 %>" SelectCommand="Foo" SelectCommandType="StoredProcedure" OnSelecting="DS_Selecting"> <asp:Parameter Name="paramA" Type="String" /> <asp:Parameter Name="paramB" Type="String" /></asp:SqlDataSource>In my setup, paramA and paramB are set in DS_Selecting(), where I can access the Command.Parameters[] of DS.Now, here's the problem. As you can see, the GridView allows for sorting. When you click on a header title to sort, however, the GridView becomes empty. My question is, how can I get the GV sorted and in the correct direction (i.e. asc/desc)? My first step in my attempt was to add another parameter to the SqlDataSource and sotred procedure Foo (e.g. @SortByColumn), then changed Foo appropriately: ALTER PROCEDURE Foo @paramA nvarchar(64), @paramB nvarchar(64), @SortColumn nvarchar(16) = 'SearchCount' AS SELECT * FROM Searches ORDER BY CASE WHEN @SortColumn='SearchCount' THEN SearchCount WHEN @SortColumn='PartnerName' THEN PartnerName ELSE ID ENDThat works find and dandy. But wait--I want to get the correct ORDER BY direction too! So I add another parameter to the SqlDataSource and Foo (@SortDirection), then alter Foo: ... SELECT * From Searchces ORDER BY CASE /* Keep in mind that CASE short-circuits */ WHEN @SortColumn='SearchCount' AND @SortDirection='desc' SearchCount DESC WHEN @SortColumn='SearchCount' SearchCount WHEN @SortColumn='PartnerName' AND @SortDirection='desc' PartnerName DESC WHEN @SortColumn='PartnerName' PartnerName WHEN @SortColumn='ID' AND @SortDirection='desc' ID DESC ELSE ID END ...But including DESC or ASC after the column name to sort by causes SQL to error. What the heck can I do, besides convert all my stored procedures into in-line statements inside the ASP page, where I could then dynamically construct the appropriate SQL statement? I'm really at a loss on this one! Any help would be much appreciated!Am I missing a much simpler solution? I am making this too complicated?

View Replies !

Stored Procedure To Display The Relevant Data Of The IDs In The Database To A Gridview
Here is the Stored procedure
ALTER procedure [dbo].[ActAuditInfo](@IndustryName nvarchar(50) output,@CompanyName nvarchar(50) output,@PlantName nvarchar(50) output,@GroupName nvarchar(50) output,@UserName nvarchar(50) output
)asbegindeclare @AuidtID as varchar(30)Select @IndustryName=Industry_Name from Industry whereIndustry.Ind_Id_PK =(Select Audit_Industry from Audits whereAd_ID_PK=@AuidtID)Select @CompanyName=Company_Name from Company whereCompany.Cmp_ID_PK =(Select Audit_Company from Audits whereAd_ID_PK=@AuidtID)Select @PlantName=Plant_Name from Plant where Plant.Pl_ID_PK=(Select Audit_Plant from Audits where Ad_ID_PK=@AuidtID)Select @GroupName=Groups_Name from Groups whereGroups.G_ID_PK =(Select Audit_Group from Audits whereAd_ID_PK=@AuidtID)Select @UserName=Login_Uname from RegistrationDetails whereRegistrationDetails.UID_PK =(Select Audit_Created_By fromAudits where Ad_ID_PK=@AuidtID)SELECT Ad_ID_PK, Audit_Name, @IndustryName, @CompanyName, @PlantName,@GroupName, Audit_Started_On, Audit_Scheduledto, @UserName FROMAudits where Audit_Status='Active'end
U can see here different parameters,my requirement is that iam havingID's of Industry,company,plant,group,username stored in a table calledPcra_Audits and i must display their related names in the front end.so this is the query iam using for that.
Data in the database:Commercial83312 2 2 2 1 1 InactiveHere u can see 2,2,2,1,1 these are the IDs ofindustry,company,plant,group and username and Commercial83312 is tehaudit ID.now i want to display this data in teh front end as i cannot displaythe IDs i am retrieving the names of the particular IDs from therelated tables.Like iam getting name of the IndustryID from Industry Table,in thesame way others too.when iam running this procedure iam getting the gridview blank.iam passing the output parameters:@IndustryName nvarchar(50) output,@CompanyName nvarchar(50) output,@PlantName nvarchar(50) output,@GroupName nvarchar(50) output,@UserName nvarchar(50) outputinto the function in the frontend and iam calling that into the pageload method.please help me with this.

View Replies !

Stored Procedure Passes Test In Gridview, But Nothing Shows Up On The Page
Like the subject says I have tested the SP in Gridview. Everything looks fine. But when run nothing shows up on the page.
I have tried using QueryStrings to pass the data and Controls.
Here is the Gridview Code:<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px"
CellPadding="4" DataSourceID="SqlDataSource1">
<FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
<RowStyle BackColor="White" ForeColor="#003399" />
<Columns><asp:BoundField DataField="FirstName" HeaderText="FirstName"
SortExpression="FirstName" /><asp:BoundField DataField="LastName" HeaderText="LastName"
SortExpression="LastName" /><asp:BoundField DataField="EthnicID" HeaderText="EthnicID"
SortExpression="EthnicID" /><asp:BoundField DataField="Gender" HeaderText="Gender"
SortExpression="Gender" /><asp:BoundField DataField="Height" HeaderText="Height"
SortExpression="Height" /><asp:BoundField DataField="Weight" HeaderText="Weight"
SortExpression="Weight" />
<asp:BoundField DataField="Hair" HeaderText="Hair" SortExpression="Hair" />
<asp:BoundField DataField="Eyes" HeaderText="Eyes" SortExpression="Eyes" />
<asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
<asp:BoundField DataField="State" HeaderText="State" SortExpression="State" />
</Columns>
<PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
<SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
<HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
</asp:GridView>

Here is the Datasource:<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:SQL2005_311004_modelsystemConnectionString %>"
SelectCommand="spSearch" SelectCommandType="StoredProcedure">
<SelectParameters><asp:QueryStringParameter DefaultValue="" Name="FirstName"
QueryStringField="fn" Type="String" />
<asp:QueryStringParameter Name="LastName" QueryStringField="ln" Type="String" />
<asp:Parameter Name="EthnicID" Type="String" />
<asp:Parameter Name="Gender" Type="String" />
<asp:Parameter Name="Height" Type="String" />
<asp:Parameter Name="weight" Type="String" />
<asp:Parameter Name="Hair" Type="String" />
<asp:Parameter Name="Eyes" Type="String" />
<asp:Parameter Name="City" Type="String" />
<asp:Parameter Name="State" Type="String" />
</SelectParameters>
</asp:SqlDataSource>

I hope you can help me with this one!!!

View Replies !