Browski
asked on
database insert using MS Application block ExecuteNonQuery method
Hi all, I'm new to c# and am trying to do a basic insert into a sql database. I keep getting the following error -
System.Data.SqlClient.SqlE xception: Error converting data type char to int. at System.Data.SqlClient.SqlC ommand.Exe cuteReader (CommandBe havior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlC ommand.Exe cuteNonQue ry() at Microsoft.ApplicationBlock s.Data.Sql Helper.Exe cuteNonQue ry(SqlConn ection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) in C:\Program Files\Microsoft Application Blocks for .NET\Data Access v2\Code\CS\Microsoft.Appli cationBloc ks.Data\SQ LHelper.cs :line 335 at CZRDP.RDCPages.NewRecord.b utSubmitDe tails_Clic k(Object sender, EventArgs e) in e:\rmds\czrdp\rdcpages\new record.asp x.cs:line 385
This is the code that I'm using any help would be much appreciated
SqlParameter paramSubscriber = new SqlParameter("@SubscriberN o", SqlDbType.Char, 20,"SubscriberNo");
paramSubscriber.Value = txtSubscriberNumber.Text;
SqlParameter paramAccType = new SqlParameter("@AccountType ID", SqlDbType.Int, 4,"AccountTypeID");
paramAccType.Value = drpAccType.SelectedValue;
SqlParameter paramComp = new SqlParameter("@Competitor" ,SqlDbType .Bit,1,"Co mpetitor") ;
paramComp.Value = chkCompetitor.Checked;
SqlParameter paramCompName = new SqlParameter("@CompanyName ",SqlDbTyp e.Char,80, "CompanyNa me");
paramCompName.Value = txtCompanyName.Text;
SqlParameter paramSalutation = new SqlParameter("@SalutationI D",SqlDbTy pe.Int,4," Salutation ID");
paramSalutation.Value = drpSupportSalutation.Selec tedValue;
SqlParameter paramFirstName = new SqlParameter("@FirstName", SqlDbType. Char,80,"F irstName") ;
paramFirstName.Value = txtFirstName.Text;
SqlParameter paramLastName = new SqlParameter("@LastName",S qlDbType.C har,80,"La stName");
paramLastName.Value = txtLastName.Text;
SqlParameter paramSupportLevel = new SqlParameter("@SupportLeve lID",SqlDb Type.Int,4 ,"SupportL evelID");
paramSupportLevel.Value = drpSupportLevel.SelectedVa lue;
SqlParameter paramProduct = new SqlParameter("@ProductID", SqlDbType. Int,4,"Pro ductID");
paramProduct.Value = drpSupportedProducts.Selec tedValue;
SqlParameter paramAddr1 = new SqlParameter("@Address1",S qlDbType.C har,80,"Ad dress1");
paramAddr1.Value = txtaddress1.Text;
SqlParameter paramAddr2 = new SqlParameter("@Address2",S qlDbType.C har,80,"Ad dress2");
paramAddr2.Value = txtaddress2.Text;
SqlParameter paramCity = new SqlParameter("@City",SqlDb Type.Char, 80,"City") ;
paramCity.Value = txtcity.Text;
SqlParameter paramCounty = new SqlParameter("@County",Sql DbType.Cha r,80,"Coun ty");
paramCounty.Value = txtcounty.Text;
SqlParameter paramPostcode = new SqlParameter("@Postcode",S qlDbType.C har,10,"Po stcode");
paramPostcode.Value = txtPostcode.Text;
SqlParameter paramCountry = new SqlParameter("@Country",Sq lDbType.Ch ar,80,"Cou ntry");
paramCountry.Value = txtCountry.Text;
SqlParameter paramPhone = new SqlParameter("@PhoneNo",Sq lDbType.Ch ar,40,"Pho neNo");
paramPhone.Value = txtPhoneNumber.Text;
SqlParameter paramCCSSalutation = new SqlParameter("@CCSSalutati onID",SqlD bType.Int, 4,"CCSSalu tationID") ;
paramCCSSalutation.Value = drpSupportSalutation.Selec tedValue;
SqlParameter paramCCSSFirstName = new SqlParameter("@CCSFirstNam e",SqlDbTy pe.Char,80 ,"CCSFirst Name");
paramCCSSFirstName.Value = txtSupportFirstName.Text;
SqlParameter paramCCSSLastName = new SqlParameter("@CCSLastName ",SqlDbTyp e.Char,80, "CCSLastNa me");
paramCCSSLastName.Value = txtSupportLastName.Text;
SqlParameter paramCCSRole = new SqlParameter("@CCSRole",Sq lDbType.Ch ar,80,"CCS Role");
paramCCSRole.Value = txtClientRole.Text;
SqlParameter paramMembershipStartDate = new SqlParameter("@MembershipS tartDate", SqlDbType. DateTime,8 ,"Membersh ipStartDat e");
paramMembershipStartDate.V alue = txtMembershipDate.Text;
SqlParameter paramAgreeDate = new SqlParameter("@RDCAgreemen tDate",Sql DbType.Dat eTime,8,"R DCAgreemen tDate");
paramAgreeDate.Value = txtSignedAgreeDate.Text;
SqlParameter paramContractType = new SqlParameter("@ContractTyp eID",SqlDb Type.Int,4 ,"Contract TypeID");
paramContractType.Value = drpContractType.SelectedVa lue;
SqlParameter paramContractTypeDate = new SqlParameter("@ContractTyp eSignedDat e",SqlDbTy pe.DateTim e,8,"Contr actTypeSig nedDate");
paramContractTypeDate.Valu e = txtSignedConType.Text;
SqlParameter paramAccManager = new SqlParameter("@AccountMana ger",SqlDb Type.Char, 80,"Accoun tManager") ;
paramAccManager.Value = txtAccManager.Text;
SqlParameter paramBusAdmin = new SqlParameter("@BusinessAdm in",SqlDbT ype.Char,8 0,"Busines sAdmin");
paramBusAdmin.Value = txtBusinessAdmin.Text;
SqlParameter paramNamedEmail = new SqlParameter("@NamedUserEm ailAddress ",SqlDbTyp e.Char,80, "NamedUser EmailAddre ss");
paramNamedEmail.Value = txtSupportEmailAddress.Tex t;
SqlParameter paramSupportEmail = new SqlParameter("@CCSEmailAdd ress",SqlD bType.Char ,80,"CCSEm ailAddress ");
paramSupportEmail.Value = txtEmailAddress.Text;
SqlParameter paramOldRevenue = new SqlParameter("@OldRevenue" ,SqlDbType .Int,4,"Ol dRevenue") ;
paramOldRevenue.Value = txtOldOldRevenue.Text;
SqlParameter paramOldNewRevenue = new SqlParameter("@OldNewReven ue",SqlDbT ype.Int,4, "OldNewRev enue");
paramOldNewRevenue.Value = txtOldNewRevenue.Text;
SqlParameter paramNewNewRevenue = new SqlParameter("@NewNewReven ue",SqlDbT ype.Int,4, "NewNewRev enue");
paramNewNewRevenue.Value = txtNewNewRevenue.Text;
SqlParameter paramCreditsBought = new SqlParameter("@TotalCredit sBought",S qlDbType.I nt,4,"Tota lCreditsBo ught");
paramCreditsBought.Value = txtCreditsBought.Text;
SqlParameter paramCreditsUsed = new SqlParameter("@TotalCredit sUsed",Sql DbType.Int ,4,"TotalC reditsUsed ");
paramCreditsUsed.Value = txtCreditsUsed.Text;
SqlParameter paramDateOpened = new SqlParameter("@DateOpened" ,SqlDbType .DateTime, 8,"DateOpe ned");
paramDateOpened.Value = txtDateOpened.Text;
SqlParameter paramDateClosed = new SqlParameter("@DateClosed" ,SqlDbType .DateTime, 8,"DateClo sed");
paramDateClosed.Value = txtDateClosed.Text;
SqlParameter paramSiebelSRNo = new SqlParameter("@SiebelSRNo" ,SqlDbType .Char,80," SiebelSRNo ");
paramSiebelSRNo.Value = txtSiebelNumber.Text;
SqlParameter paramBillable = new SqlParameter("@Billable",S qlDbType.B it,1,"Bill able");
paramBillable.Value = chkBillable.Checked;
SqlParameter paramRegion = new SqlParameter("@RegionID",S qlDbType.I nt,4,"Regi onID");
paramRegion.Value = drpRegionID.SelectedValue;
SqlParameter paramClientStatus = new SqlParameter("@ClientStatu sID",SqlDb Type.Int,4 ,"ClientSt atusID");
paramClientStatus.Value = drpSupportClientStatus.Sel ectedValue ;
try
{
int result;
result = SqlHelper.ExecuteNonQuery( SqlUtility .Connectio n,CommandT ype.Stored Procedure, "itblSubsc riber",par amSubscrib er,paramAc cType,
paramComp,paramCompName,
paramSalutation,paramFirst Name,
paramLastName,paramSupport Level,
paramProduct,paramAddr1,
paramAddr2,paramCity,
paramCounty,paramPostcode,
paramCountry,paramPhone,
paramCCSSalutation,paramCC SSFirstNam e,
paramCCSSLastName,paramCCS Role,
paramMembershipStartDate,
paramAgreeDate,
paramContractType,
paramContractTypeDate,
paramAccManager,paramBusAd min,
paramNamedEmail,paramSuppo rtEmail,
paramOldRevenue,paramOldNe wRevenue,
paramNewNewRevenue,paramCr editsBough t,
paramCreditsUsed,paramDate Opened,
paramDateClosed,paramSiebe lSRNo,
paramBillable,paramRegion,
paramClientStatus);
}
catch (Exception ex)
{
Response.Write(ex.ToString ());
}
Response.Redirect("SearchR ecord.aspx ",true);
}
System.Data.SqlClient.SqlE
This is the code that I'm using any help would be much appreciated
SqlParameter paramSubscriber = new SqlParameter("@SubscriberN
paramSubscriber.Value = txtSubscriberNumber.Text;
SqlParameter paramAccType = new SqlParameter("@AccountType
paramAccType.Value = drpAccType.SelectedValue;
SqlParameter paramComp = new SqlParameter("@Competitor"
paramComp.Value = chkCompetitor.Checked;
SqlParameter paramCompName = new SqlParameter("@CompanyName
paramCompName.Value = txtCompanyName.Text;
SqlParameter paramSalutation = new SqlParameter("@SalutationI
paramSalutation.Value = drpSupportSalutation.Selec
SqlParameter paramFirstName = new SqlParameter("@FirstName",
paramFirstName.Value = txtFirstName.Text;
SqlParameter paramLastName = new SqlParameter("@LastName",S
paramLastName.Value = txtLastName.Text;
SqlParameter paramSupportLevel = new SqlParameter("@SupportLeve
paramSupportLevel.Value = drpSupportLevel.SelectedVa
SqlParameter paramProduct = new SqlParameter("@ProductID",
paramProduct.Value = drpSupportedProducts.Selec
SqlParameter paramAddr1 = new SqlParameter("@Address1",S
paramAddr1.Value = txtaddress1.Text;
SqlParameter paramAddr2 = new SqlParameter("@Address2",S
paramAddr2.Value = txtaddress2.Text;
SqlParameter paramCity = new SqlParameter("@City",SqlDb
paramCity.Value = txtcity.Text;
SqlParameter paramCounty = new SqlParameter("@County",Sql
paramCounty.Value = txtcounty.Text;
SqlParameter paramPostcode = new SqlParameter("@Postcode",S
paramPostcode.Value = txtPostcode.Text;
SqlParameter paramCountry = new SqlParameter("@Country",Sq
paramCountry.Value = txtCountry.Text;
SqlParameter paramPhone = new SqlParameter("@PhoneNo",Sq
paramPhone.Value = txtPhoneNumber.Text;
SqlParameter paramCCSSalutation = new SqlParameter("@CCSSalutati
paramCCSSalutation.Value = drpSupportSalutation.Selec
SqlParameter paramCCSSFirstName = new SqlParameter("@CCSFirstNam
paramCCSSFirstName.Value = txtSupportFirstName.Text;
SqlParameter paramCCSSLastName = new SqlParameter("@CCSLastName
paramCCSSLastName.Value = txtSupportLastName.Text;
SqlParameter paramCCSRole = new SqlParameter("@CCSRole",Sq
paramCCSRole.Value = txtClientRole.Text;
SqlParameter paramMembershipStartDate = new SqlParameter("@MembershipS
paramMembershipStartDate.V
SqlParameter paramAgreeDate = new SqlParameter("@RDCAgreemen
paramAgreeDate.Value = txtSignedAgreeDate.Text;
SqlParameter paramContractType = new SqlParameter("@ContractTyp
paramContractType.Value = drpContractType.SelectedVa
SqlParameter paramContractTypeDate = new SqlParameter("@ContractTyp
paramContractTypeDate.Valu
SqlParameter paramAccManager = new SqlParameter("@AccountMana
paramAccManager.Value = txtAccManager.Text;
SqlParameter paramBusAdmin = new SqlParameter("@BusinessAdm
paramBusAdmin.Value = txtBusinessAdmin.Text;
SqlParameter paramNamedEmail = new SqlParameter("@NamedUserEm
paramNamedEmail.Value = txtSupportEmailAddress.Tex
SqlParameter paramSupportEmail = new SqlParameter("@CCSEmailAdd
paramSupportEmail.Value = txtEmailAddress.Text;
SqlParameter paramOldRevenue = new SqlParameter("@OldRevenue"
paramOldRevenue.Value = txtOldOldRevenue.Text;
SqlParameter paramOldNewRevenue = new SqlParameter("@OldNewReven
paramOldNewRevenue.Value = txtOldNewRevenue.Text;
SqlParameter paramNewNewRevenue = new SqlParameter("@NewNewReven
paramNewNewRevenue.Value = txtNewNewRevenue.Text;
SqlParameter paramCreditsBought = new SqlParameter("@TotalCredit
paramCreditsBought.Value = txtCreditsBought.Text;
SqlParameter paramCreditsUsed = new SqlParameter("@TotalCredit
paramCreditsUsed.Value = txtCreditsUsed.Text;
SqlParameter paramDateOpened = new SqlParameter("@DateOpened"
paramDateOpened.Value = txtDateOpened.Text;
SqlParameter paramDateClosed = new SqlParameter("@DateClosed"
paramDateClosed.Value = txtDateClosed.Text;
SqlParameter paramSiebelSRNo = new SqlParameter("@SiebelSRNo"
paramSiebelSRNo.Value = txtSiebelNumber.Text;
SqlParameter paramBillable = new SqlParameter("@Billable",S
paramBillable.Value = chkBillable.Checked;
SqlParameter paramRegion = new SqlParameter("@RegionID",S
paramRegion.Value = drpRegionID.SelectedValue;
SqlParameter paramClientStatus = new SqlParameter("@ClientStatu
paramClientStatus.Value = drpSupportClientStatus.Sel
try
{
int result;
result = SqlHelper.ExecuteNonQuery(
paramComp,paramCompName,
paramSalutation,paramFirst
paramLastName,paramSupport
paramProduct,paramAddr1,
paramAddr2,paramCity,
paramCounty,paramPostcode,
paramCountry,paramPhone,
paramCCSSalutation,paramCC
paramCCSSLastName,paramCCS
paramMembershipStartDate,
paramAgreeDate,
paramContractType,
paramContractTypeDate,
paramAccManager,paramBusAd
paramNamedEmail,paramSuppo
paramOldRevenue,paramOldNe
paramNewNewRevenue,paramCr
paramCreditsUsed,paramDate
paramDateClosed,paramSiebe
paramBillable,paramRegion,
paramClientStatus);
}
catch (Exception ex)
{
Response.Write(ex.ToString
}
Response.Redirect("SearchR
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER