过程或函数AddTempMember指定的参数过多. [英] Procedure or function AddTempMember has too many arguments specified.

查看：97
本文介绍了过程或函数AddTempMember指定的参数过多.的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

 strQuery = " ;
            strQuery = "  + txtFirstName.Text.Trim()的成员中"  + txtLastName.Text.Trim()+  '和FathersName ='" + txtFathersName.Text.Trim()+  '";
            DataTable dtabCheckExistence = 新 DataTable();
            dtabCheckExistence = AC.GetValuesInDataTable(strQuery);
            如果(dtabCheckExistence.Rows.Count <   3  || dtabCheckExistence.Rows.Count ==  0 )
            {
                con = 新 SqlConnection(ConfigurationManager.ConnectionStrings [" ].ConnectionString)；
                cmd = 新 SqlCommand();
                con.Open();
                cmd.Connection = con;

                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = " ;
                cmd.Parameters.AddWithValue(" ，txtPlaceUnderID.Text.Trim());
                cmd.Parameters.AddWithValue(" ，(txtSponsorID.Text.Trim()== " ?空:txtSponsorID.Text.修剪()));
                cmd.Parameters.AddWithValue(" ，rdolstNode.SelectedItem.Value.Trim());
                cmd.Parameters.AddWithValue(" ，ddlTitle.SelectedItem.Text.Trim());
                cmd.Parameters.AddWithValue(" ，txtFirstName.Text.Trim());
                cmd.Parameters.AddWithValue(" ，txtLastName.Text.Trim());
                cmd.Parameters.AddWithValue(" ，ddlFathersHusband.SelectedItem.Value.Trim());
                cmd.Parameters.AddWithValue(" ，txtFathersName.Text.Trim());
                cmd.Parameters.AddWithValue(" ，空)；
                cmd.Parameters.AddWithValue(" ，ddlMaritalStatus.SelectedItem.Text.Trim());
                cmd.Parameters.AddWithValue(" ，txtAddress.Text.Trim());
                cmd.Parameters.AddWithValue(" ，txtCity.Text.Trim());
                cmd.Parameters.AddWithValue(" ，ddlState.SelectedItem.Text.Trim());
                cmd.Parameters.AddWithValue(" ，txtCountry.Text.Trim());
                cmd.Parameters.AddWithValue(" ，txtPinCode.Text.Trim());
                cmd.Parameters.AddWithValue(" ，txtStdCode.Text.Trim());
                cmd.Parameters.AddWithValue(" ，txtPhone.Text.Trim());
                cmd.Parameters.AddWithValue(" ，txtMobile.Text.Trim());
                cmd.Parameters.AddWithValue("


程序是:

 创建 过程 [dbo].[AddTempMember]( @ ParentId   int ， @ ThroughOverId   @ Leg   50 )， varchar ( 50 )， @名字  varchar ( 50 )， @姓氏  varchar ( 50 )， @ Type   varchar ( 50 )， @ FathersName   varchar ( 50 )， @ MothersName   varchar ( 50 )， @ MaritalStatus   varchar  ( 50 )， @ Address   varchar (  50 )， @城市  varchar ( 50 )， @ State   varchar ( 50 )， @ Country   varchar ( 50 )， @ Pin   varchar ( 50 )， @ Std   varchar ( 50 )， @ Phone   varchar ( 50 )， @ Mobile   varchar ( 50 )， @电子邮件  varchar ( 50 )， @ LoginId   varchar ( @密码  50 )，日期， VARCHAR ( @性别  50 )， varchar ( @NomineeName   varchar ( 50 )， @NomineeRelation   varchar ( 50 )， @ NomineeDOB   varchar ( 50 )， @ ProductCode   varchar ( 50 )， @ PaymentOption   varchar ( 50 )， @ PaymentMode   varchar ( 50 )， @金额 金钱， @ AmountBalance  金钱， @ BankName   varchar ( 50 )， @ DDChequeNo   varchar ( 50 )， @ DDChequeDate  日期， @ Payable   varchar ( 50 )， @ MemberAccNo   varchar ( 50 )， varchar ( @ MemberBranch   50 )， varchar ( @ ReceiptNo   50 )， varchar ( @ CreatedBy   50 )， int ， @msg   varchar ( 50 ))

 AS   BEGIN 
插入  INTO 成员(ParentId，ThroughOverId，Leg，Title，FirstName，LastName，值( @ ParentId ， @ ThroughOverId ，  @腿， @标题， @名字 ， @姓氏， @ Type ， @ FathersName ， @ MothersName ， @ MaritalStatus ， @ Address ， @城市， @ State ， @ Country ， @ Pin ， @ Std ， @ Phone ， @ Mobile ， @电子邮件， @ LoginId ， @ Password ， @ DOB ， @ Age ， @@性别， @ PAN ， @ NomineeName ， @NomineeRelation ， @ NomineeDOB ， @ ProductCode ， @PaymentOption ， @ PaymentMode ， @ Amount ， @ BankName ， @ DDChequeDate ， @ MemberAccNo ， @ MemberBranch ， @ ReceiptNo ， @ CreatedBy ， @ msg )
 END

解决方案

以下是您添加PinNo 作为输入参数的代码. br/> 

 cmd.Parameters.AddWithValue(" ，为空);


检查以下内容:

 cmd.Parameters.AddWithValue(" ，txtPanCardNo.Text .修剪());
cmd.Parameters.AddWithValue(" ， null )； // 这是额外的参数
cmd.Parameters.AddWithValue(" ，txtNomineeName.Text.Trim());  pre> 

还有


 cmd.Parameters.AddWithValue(" ，txtCountry.Text .修剪());
cmd.Parameters.AddWithValue(" ，txtPinCode.Text.Trim());
cmd.Parameters.AddWithValue(" ，txtStdCode.Text.Trim());  pre> 



但是在您的SP中，没有@PinNo的定义.

如果需要，可以在SP中添加参数，否则从前端删除此输入参数.





--Amit 


strQuery = "";
            strQuery = "Select * From Members Where FirstName = '" + txtFirstName.Text.Trim() + "' and LastName = '" + txtLastName.Text.Trim() + "' and FathersName ='" + txtFathersName.Text.Trim() + "' ";
            DataTable dtabCheckExistence = new DataTable();
            dtabCheckExistence = AC.GetValuesInDataTable(strQuery);
            if (dtabCheckExistence.Rows.Count < 3 || dtabCheckExistence.Rows.Count == 0)
            {
                con = new SqlConnection(ConfigurationManager.ConnectionStrings["amms"].ConnectionString);
                cmd = new SqlCommand();
                con.Open();
                cmd.Connection = con;

                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = "AddTempMember";                
                cmd.Parameters.AddWithValue("@ParentId", txtPlaceUnderID.Text.Trim());
                cmd.Parameters.AddWithValue("@ThroughOverId", (txtSponsorID.Text.Trim() == "" ? null : txtSponsorID.Text.Trim()));
                cmd.Parameters.AddWithValue("@Leg", rdolstNode.SelectedItem.Value.Trim());
                cmd.Parameters.AddWithValue("@Title", ddlTitle.SelectedItem.Text.Trim());
                cmd.Parameters.AddWithValue("@FirstName", txtFirstName.Text.Trim());
                cmd.Parameters.AddWithValue("@LastName", txtLastName.Text.Trim());
                cmd.Parameters.AddWithValue("@Type", ddlFathersHusband.SelectedItem.Value.Trim());
                cmd.Parameters.AddWithValue("@FathersName", txtFathersName.Text.Trim());
                cmd.Parameters.AddWithValue("@MothersName", null);
                cmd.Parameters.AddWithValue("@MaritalStatus", ddlMaritalStatus.SelectedItem.Text.Trim());
                cmd.Parameters.AddWithValue("@Address", txtAddress.Text.Trim());
                cmd.Parameters.AddWithValue("@City", txtCity.Text.Trim());
                cmd.Parameters.AddWithValue("@State", ddlState.SelectedItem.Text.Trim());
                cmd.Parameters.AddWithValue("@Country", txtCountry.Text.Trim());
                cmd.Parameters.AddWithValue("@Pin", txtPinCode.Text.Trim());
                cmd.Parameters.AddWithValue("@Std", txtStdCode.Text.Trim());
                cmd.Parameters.AddWithValue("@Phone", txtPhone.Text.Trim());
                cmd.Parameters.AddWithValue("@Mobile", txtMobile.Text.Trim());
                cmd.Parameters.AddWithValue("@Email", txtEmail.Text.Trim());
                cmd.Parameters.AddWithValue("@LoginId", null);
                cmd.Parameters.AddWithValue("@Password", null);
                cmd.Parameters.AddWithValue("@DOB", (txtDOB.Text.Trim() == "" ? null : Convert.ToDateTime(txtDOB.Text.Trim()).ToString("MM/dd/yyyy")));
                cmd.Parameters.AddWithValue("@Age", lblAge.Text.Trim());
                cmd.Parameters.AddWithValue("@Sex", ddlGender.SelectedItem.Value.Trim());
                cmd.Parameters.AddWithValue("@PAN", txtPanCardNo.Text.Trim());
                cmd.Parameters.AddWithValue("@PinNo", null);
                cmd.Parameters.AddWithValue("@NomineeName", txtNomineeName.Text.Trim());
                cmd.Parameters.AddWithValue("@NomineeRelation", txtNomineeRelation.Text.Trim());
                cmd.Parameters.AddWithValue("@NomineeDOB", (txtNomineeDOB.Text.Trim() == "" ? null : Convert.ToDateTime(txtNomineeDOB.Text.Trim()).ToString("MM/dd/yyyy")));
                cmd.Parameters.AddWithValue("@ProductCode", ddlProduct.SelectedItem.Value.Trim());
                cmd.Parameters.AddWithValue("@PaymentOption", null);
                cmd.Parameters.AddWithValue("@PaymentMode", ddlPaymentMode.SelectedItem.Value.Trim());
                cmd.Parameters.AddWithValue("@Amount", txtAmount.Text.Trim());
                cmd.Parameters.AddWithValue("@AmountBalance", txtBalanceAmount.Text.Trim());
                cmd.Parameters.AddWithValue("@BankName", txtBankName.Text.Trim());
                cmd.Parameters.AddWithValue("@DDChequeNo", txtChequeDDNo.Text.Trim());
                cmd.Parameters.AddWithValue("@DDChequeDate", (txtChequeDDDate.Text.Trim() == "" ? null : Convert.ToDateTime(txtChequeDDDate.Text.Trim()).ToString("MM/dd/yyyy")));
                cmd.Parameters.AddWithValue("@Payable", txtPayble.Text.Trim());
                cmd.Parameters.AddWithValue("@MemberAccNo", txtCBSacNo.Text.Trim());
                cmd.Parameters.AddWithValue("@MemberBankName", txtMemberBankName.Text.Trim());
                cmd.Parameters.AddWithValue("@MemberBranch", txtBankBranch.Text.Trim());
                cmd.Parameters.AddWithValue("@DepotCode", (txtBranchCode.Text.Trim() == "" ? null : txtBranchCode.Text.Trim()));
                cmd.Parameters.AddWithValue("@ReceiptNo", null);
                cmd.Parameters.AddWithValue("@JoiningDate", (txtJoiningDate.Text.Trim() == "" ? null : Convert.ToDateTime(txtJoiningDate.Text.Trim()).ToString("MM/dd/yyyy")));
               cmd.Parameters.AddWithValue("@CreatedBy", Convert.ToString(Session["UserId"]));
                cmd.Parameters.AddWithValue("@MemId", 0).Direction = ParameterDirection.InputOutput;
                cmd.Parameters.AddWithValue("@msg", 0).Direction = ParameterDirection.InputOutput;
                cmd.ExecuteNonQuery();
                con.Close();


Procedure is :

CREATE PROCEDURE [dbo].[AddTempMember](@ParentId int,@ThroughOverId int, @Leg VARCHAR(50),@Title varchar(50),@FirstName varchar(50),@LastName varchar(50), @Type varchar(50),@FathersName varchar(50),@MothersName varchar(50), @MaritalStatus varchar(50), @Address varchar(50), @City varchar(50), @State varchar(50),@Country varchar(50),@Pin varchar(50),@Std varchar(50),@Phone varchar(50),@Mobile varchar(50),@Email varchar(50),@LoginId varchar(50),@Password varchar(50),@DOB date,@Age VARCHAR(50),@Sex varchar(50),@PAN varchar(50),@NomineeName varchar(50),@NomineeRelation varchar(50),@NomineeDOB varchar(50),@ProductCode varchar(50),@PaymentOption varchar(50),@PaymentMode varchar(50),@Amount money,@AmountBalance money,@BankName varchar(50),@DDChequeNo varchar(50),@DDChequeDate date,@Payable varchar(50),@MemberAccNo varchar(50),@MemberBankName varchar(50),@MemberBranch varchar(50),@DepotCode varchar(50),@ReceiptNo varchar(50),@JoiningDate varchar(50),@CreatedBy varchar(50),@MemId int,@msg varchar(50))

AS BEGIN
INSERT INTO Members(ParentId, ThroughOverId,Leg,Title,FirstName,LastName,Type,FathersName,MothersName,MaritalStatus,Address ,City,State,Country,Pin,Std,Phone,Mobile,Email,LoginId,Password,DOB,Age,Sex,PAN,NomineeName,NomineeRelation,NomineeDOB,ProductCode,PaymentOption,PaymentMode,Amount,AmountBalance,BankName,DDChequeNo,DDChequeDate,Payable,MemberAccNo,MemberBankName,MemberBranch,DepotCode,ReceiptNo,JoiningDate,CreatedBy,MemId,msg)
values (@ParentId,@ThroughOverId,@Leg,@Title,@FirstName,@LastName,@Type,@FathersName,@MothersName,@MaritalStatus,@Address ,@City,@State ,@Country,@Pin,@Std,@Phone,@Mobile,@Email,@LoginId,@Password,@DOB,@Age,@Sex,@PAN,@NomineeName,@NomineeRelation,@NomineeDOB,@ProductCode,@PaymentOption,@PaymentMode,@Amount,@AmountBalance,@BankName,@DDChequeNo,@DDChequeDate,@Payable,@MemberAccNo,@MemberBankName,@MemberBranch,@DepotCode,@ReceiptNo,@JoiningDate,@CreatedBy,@MemId,@msg)
END

解决方案

Here is your code for adding PinNo as Input Parameter.

cmd.Parameters.AddWithValue("@PinNo", null);


Check this:

cmd.Parameters.AddWithValue("@PAN", txtPanCardNo.Text.Trim());
cmd.Parameters.AddWithValue("@PinNo", null); //This is the extra parameter
cmd.Parameters.AddWithValue("@NomineeName", txtNomineeName.Text.Trim());


And

cmd.Parameters.AddWithValue("@Country", txtCountry.Text.Trim());
cmd.Parameters.AddWithValue("@Pin", txtPinCode.Text.Trim());
cmd.Parameters.AddWithValue("@Std", txtStdCode.Text.Trim());



But in your SP there is no definition for @PinNo.
Add the parameter in SP if required otherwise delete this input parameter from front-end.


--Amit


这篇关于过程或函数AddTempMember指定的参数过多.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
其他开发语言最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆