我如何克服此错误带有Parametername @Nameofschool的Sql参数已被另一个Sqlparametercollection包含 [英] How I Overcome With This Error The Sqlparameter With Parametername @Nameofschool Is Already Contained By Another Sqlparametercollection

问题描述

util.ClearParam()
       util.AddParam("@NameOfSchool", ddlSchName.SelectedItem.Text)
       util.AddParam("@FName", txtF_Name.Text)
       util.AddParam("@MName", txtM_Name.Text)
       util.AddParam("@LName", txtL_Name.Text)
       util.AddParam("@DOB", skdatefc(txtDob.Text))
       util.AddParam("@Gender", ddlGender.SelectedItem.Value)
       util.AddParam("@Catagory", ddlCategory.SelectedItem.Value)
       util.AddParam("@MaritalStatus", ddlMarriedStatus.SelectedItem.Value)
       util.AddParam("@FatherName", txtF_H_Name.Text)
       util.AddParam("@ResidentialAddress", txtC_Add1.Text)
       util.AddParam("@CityR", txtC_City.Text)
       util.AddParam("@StateR", txtC_State.Text)
       util.AddParam("@PhoneR", txtCPhone.Text)
       util.AddParam("@PermanentAddress", txtP_Add1.Text)
       util.AddParam("@CityP", txtP_City.Text)
       util.AddParam("@StateP", txtP_State.Text)
       util.AddParam("@PhoneP", txtPPhone.Text)
       util.AddParam("@EmailID", txtC_Email.Text)
       util.AddParam("@Currentpost", ddlInitialPost.SelectedItem.Value)
       util.AddParam("@CurrentpostingTrade", ddlSubjectToTeach.SelectedItem.Value)
       util.AddParam("@StreamNameAppointment", txtInitialSelOrderNo.Text)
       util.AddParam("@InitialAppointmentNo", txtInitialAppOrderNo.Text)
       util.AddParam("@DateofAppointment", txtInitialAppDate.Text)
       util.AddParam("@QualificationGraduation", ddlH_Qualif.SelectedItem.Value)
       util.AddParam("@GraduationSubject1", ddlSub1.SelectedItem.Value)
       util.AddParam("@GraduationSubject2", ddlSub2.SelectedItem.Value)
       util.AddParam("@GraduationSubject3", ddlSub3.SelectedItem.Value)
       util.AddParam("@OtherSubjectG", txtothersubjectG.Text)
       util.AddParam("@SpecializationG", txtspecial.Text)
       util.AddParam("@QualificationPostGraduation", ddlPG_Qualif.SelectedItem.Value)
       util.AddParam("@PostGraduationSubject1", ddlps1.SelectedItem.Value)
       util.AddParam("@PostGraduationSubject2", ddlps2.SelectedItem.Value)
       util.AddParam("@PostGraduationSubject3", ddlps3.SelectedItem.Value)
       util.AddParam("@OtherSubjectP", txtothersubp.Text)
       util.AddParam("@SpecializationP", txtspp.Text)
       util.AddParam("@Certificatecourse", txtcc.Text)
       util.AddParam("@Diploma", dpldiploma.SelectedItem.Value)
       util.AddParam("@BachlorDgree", dplbachlor.SelectedItem.Value)
       util.AddParam("@ProfessionalQualification", ddlProff_Qualif.SelectedItem.Value)
       util.AddParam("@OtherQualification", txtOthers.Text)
       util.AddParam("@Achievement", txtAchieve.Text)
       util.AddParam("@CurrentSchoolID", txtCurrentSchool.Text)
       util.AddParam("@DOJCurrentSchool", txtCurrentSchoolDate.Text)
       util.AddParam("@Renumeration", txtrenumeration.Text)
       util.AddParam("@IsEmployeeQualified", ddlEmployeeQualified.SelectedItem.Value)
       util.AddParam("@QualificationAcquiredthroughFragmentalcourse", ddlqafragmental.SelectedItem.Value)
       util.AddParam("@FragmentalCourse", txtfragmentalcourse.Text)
       util.AddParam("@PeriodFrom", skdatefc(txtfrom.Text))
       util.AddParam("@PeriodTo", skdatefc(txtto.Text))
       util.AddParam("@SignatoryName", txtSignatoryName.Text)
       util.AddParam("@SignatoryDesignation", txtSignatoryDesignation.Text)
       util.AddOutputParam("@VCID", SqlDbType.Int)

       k = util.executeStoredProc("usptblVocationalTeacher1415")

       If k > 0 Then
           Response.Write("<font color=blue>Record Submitted</font>")

       Else
           Response.Write("<font color=red>Record not Submitted</font>")
       End If

       'Response.Write("<script language=javascript>alert('Record Submitted Successfully');</script>")

   End Sub

推荐答案

util类可能是您创建的，而不是SqlCommand或任何其他.Net类。



所以最喜欢ely util.ClearParam（）没有做出顾名思义或该方法存在问题。

The util class is probably something that you have created, not a SqlCommand or any other .Net class.

So most likely the util.ClearParam() is not doing what the name suggests or there is some problem in that method.

1.I没有你的代码，但从错误messgaee结果，你的 ClearParam（）方法不会从SqlParamterCollection中删除SQL参数。



2.一个快速的解决方案应该修改 util 类的 ClearParam（）方法建立它将使用 SqlParameterCollection.Clear（）方法。



3.其他解决方案是创建SLQ参数集合，使用AddParam，仅用于第一次迭代，然后重用它并仅更改参数的值（ SqlParameter.Value 属性）。

1.I do not have your code, but from the error messgaee results that your ClearParam() method does not remove the SQL parameters from the SqlParamterCollection.

2.One quick solution should modify the ClearParam() method of your util class and make shore that it will use SqlParameterCollection.Clear() method.

3.Other solution is to create the SLQ parameter collectio, with AddParam, only for the first iteration, then to reuse it and to change only the values of the parameters (SqlParameter.Value property).

这篇关于我如何克服此错误带有Parametername @Nameofschool的Sql参数已被另一个Sqlparametercollection包含的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！