过程或函数AddTempMember指定的参数过多. [英] Procedure or function AddTempMember has too many arguments specified.
本文介绍了过程或函数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(" ,txtEmail.Text.Trim());
cmd.Parameters.AddWithValue(" ,空);
cmd.Parameters.AddWithValue(" , null );
cmd.Parameters.AddWithValue(" ,(txtDOB.Text.Trim()== " ?空:Convert.ToDateTime( txtDOB.Text.Trim()).ToString(" )))));
cmd.Parameters.AddWithValue(" ,lblAge.Text.Trim());
cmd.Parameters.AddWithValue(" ,ddlGender.SelectedItem.Value.Trim());
cmd.Parameters.AddWithValue(" ,txtPanCardNo.Text.Trim());
cmd.Parameters.AddWithValue(" ,空);
cmd.Parameters.AddWithValue(" ,txtNomineeName.Text.Trim());
cmd.Parameters.AddWithValue(" ,txtNomineeRelation.Text.Trim());
cmd.Parameters.AddWithValue(" ,(txtNomineeDOB.Text.Trim()== " ?空:Convert.ToDateTime( txtNomineeDOB.Text.Trim()).ToString(" ))));
cmd.Parameters.AddWithValue(" ,ddlProduct.SelectedItem.Value.Trim());
cmd.Parameters.AddWithValue(" ,空);
cmd.Parameters.AddWithValue(" ,ddlPaymentMode.SelectedItem.Value.Trim());
cmd.Parameters.AddWithValue(" ,txtAmount.Text.Trim());
cmd.Parameters.AddWithValue(" ,txtBalanceAmount.Text.Trim());
cmd.Parameters.AddWithValue(" ,txtBankName.Text.Trim());
cmd.Parameters.AddWithValue(" ,txtChequeDDNo.Text.Trim());
cmd.Parameters.AddWithValue(" ,(txtChequeDDDate.Text.Trim()== " ?空:Convert.ToDateTime( txtChequeDDDate.Text.Trim()).ToString(" ))));
cmd.Parameters.AddWithValue(" ,txtPayble.Text.Trim());
cmd.Parameters.AddWithValue(" ,txtCBSacNo.Text.Trim());
cmd.Parameters.AddWithValue(" ,txtMemberBankName.Text.Trim());
cmd.Parameters.AddWithValue(" ,txtBankBranch.Text.Trim());
cmd.Parameters.AddWithValue(" ,(txtBranchCode.Text.Trim()== " ?空:txtBranchCode.Text.修剪()));
cmd.Parameters.AddWithValue(" ,空);
cmd.Parameters.AddWithValue(" ,(txtJoiningDate.Text.Trim()== " ?空:Convert.ToDateTime( txtJoiningDate.Text.Trim()).ToString(" ))));
cmd.Parameters.AddWithValue(" ,Convert.ToString(Session [ UserId"])));
cmd.Parameters.AddWithValue(" , 0 ).Direction = ParameterDirection.InputOutput;
cmd.Parameters.AddWithValue(" , 0 ).Direction = ParameterDirection.InputOutput;
cmd.ExecuteNonQuery();
con.Close();
程序是:
创建 过程 [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 addingPinNo
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屋!
查看全文