Error converting nvarchar to numeric

I am attempting a save to a web form containing a few text box, radio list, and drop-down values, and am using a SQL stored procedure to do this. In the SP, I am indicating the data types for the variables from the web form, and have verified these are correct. However, when I execute the save button function, it appears to have all the proper values from the form, but throws an error converting nvarchar to numeric. In Visual Studio debug mode, it does not indicate which of the form fields is causing the issue, so I am wondering if anyone can assist in tracking this down. While debugging, it simply throws the error on the executenonquery command at the end of the parameters, with no further info.
Any help in narrowing this down would be appreciated...I can post code if anyone needs it, but I am hoping there is something in Visual Studio that can tell me exactly which parameter is causing this.

The error message will generally show you a pretty good hint as to which field it is. I have ran into this same error recently. While the error message did not state the field it did show the value that it was trying to convert.

Most likely you gave a field that is defined as one of the numeric types and the data you are trying to put into that field is either not numeric or in the wrong format. Look at the error message closely to see if it gives a value and if so look at your data and see which field that value is being inserted into.

If that does not solve the issue then post your code related to the update/insert and also tell us what field types are being used and what data you are attempting to place in each of those fields during the failed update/insert.

In examining the exception in Visual Studio, all I can get is the following:
System.Data.SqlClient.SqlException was unhandled by user code
Class=16
ErrorCode=-2146232060
HResult=-2146232060
LineNumber=0
Message=Error converting data type nvarchar to numeric.
Number=8114
Procedure=saverpt
Server=azda-sql0
Source=.Net SqlClient Data Provider
State=5
StackTrace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at forma.saverpt() in C:\Users\dhall\Documents\Visual Studio 2012\WebSites\ESDForms\forma.aspx.vb:line 473
at forma.Button1_Click(Object sender, EventArgs e) in C:\Users\dhall\Documents\Visual Studio 2012\WebSites\ESDForms\forma.aspx.vb:line 350
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
InnerException:

At line 473is the cmd.ExecuteNonQuery() command, and at line 350 is the command saverpt(), which calls the following code:

Code:

---

Private Sub saverpt()
        Dim conn As New SqlConnection("Data Source=servername;Initial Catalog=esdforms;User ID=user;Password=password")
        Dim cmd As New SqlCommand
        cmd.CommandText = "saverpt"
        cmd.CommandType = CommandType.StoredProcedure
        cmd.Connection = conn
        conn.Open()
        cmd.Parameters.Clear()
        cmd.Parameters.AddWithValue("@rptnum", rptnum.Text)
        cmd.Parameters.AddWithValue("@increment", maxrptnum)
        cmd.Parameters.AddWithValue("@date", dt.Text)
        cmd.Parameters.AddWithValue("@name", DropDownList1.SelectedValue)
        cmd.Parameters.AddWithValue("@inspphone", inspphone.Text)
        cmd.Parameters.AddWithValue("@inspmail", inspmail.Text)
        cmd.Parameters.AddWithValue("@insptype", insptype.SelectedValue)
        cmd.Parameters.AddWithValue("@tier", RBL1.SelectedValue)
        cmd.Parameters.AddWithValue("@grade", RBL7.SelectedValue)
        cmd.Parameters.AddWithValue("@enddate", enddt.Text)
        cmd.Parameters.AddWithValue("@starttime", sttime.Text)
        cmd.Parameters.AddWithValue("@endtime", endtime.Text)
        cmd.Parameters.AddWithValue("@nextinspdate", nextdt.Text)
        cmd.Parameters.AddWithValue("@lastinspdate", lastinsp.Text)
        cmd.Parameters.AddWithValue("@pgp", DDL2.SelectedValue)
        cmd.Parameters.AddWithValue("@aap", DDL3.SelectedValue)
        cmd.Parameters.AddWithValue("@golf", RBL3.SelectedValue)
        cmd.Parameters.AddWithValue("@ca", DropDownList2.SelectedValue)
        cmd.Parameters.AddWithValue("@catype", DDL4.SelectedValue)
        cmd.Parameters.AddWithValue("pu", DDL6.SelectedValue)
        cmd.Parameters.AddWithValue("@putype", DDL5.SelectedValue)
        cmd.Parameters.AddWithValue("@drift", RBL2.SelectedValue)
        cmd.Parameters.AddWithValue("@caseno", caseno.Text)
        cmd.Parameters.AddWithValue("@tanksamp", Tank.Text)
        cmd.Parameters.AddWithValue("@driftcard", drift.Text)
        cmd.Parameters.AddWithValue("@other", other.Text)
        cmd.Parameters.AddWithValue("@gwpl", txt1080.Text)
        cmd.Parameters.AddWithValue("@photo", photos.Text)
        cmd.Parameters.AddWithValue("@docs", docs.Text)
        cmd.Parameters.AddWithValue("@appprog", RBL4.SelectedValue)
        cmd.Parameters.AddWithValue("@equipinfo", RBL5.SelectedValue)
        cmd.Parameters.AddWithValue("@caname", TextBox27.Text)
        cmd.Parameters.AddWithValue("@employer", TextBox1.Text)
        cmd.Parameters.AddWithValue("@equiptype", RBL6.SelectedValue)
        cmd.Parameters.AddWithValue("@handname", TextBox26.Text)
        cmd.Parameters.AddWithValue("@cardno", cardno.Text)
        cmd.Parameters.AddWithValue("@noatsite", TextBox2.Text)
        cmd.Parameters.AddWithValue("@equiptag", DropDownList3.SelectedValue)
        cmd.Parameters.AddWithValue("@puname", TextBox25.Text)
        cmd.Parameters.AddWithValue("@interviewee", TextBox3.Text)
        cmd.Parameters.AddWithValue("@inttitle", TextBox4.Text)
        cmd.Parameters.AddWithValue("@coAddress", TextBox5.Text)
        cmd.Parameters.AddWithValue("@city", TextBox6.Text)
        cmd.Parameters.AddWithValue("@state", TextBox7.Text)
        cmd.Parameters.AddWithValue("@zip", TextBox8.Text)
        cmd.Parameters.AddWithValue("@phone", TextBox10.Text)
        cmd.Parameters.AddWithValue("@pgpname", TextBox24.Text)
        cmd.Parameters.AddWithValue("@commodity", DropDownList4.SelectedValue)
        cmd.Parameters.AddWithValue("@pest", DropDownList5.SelectedValue)
        cmd.Parameters.AddWithValue("@acres", TextBox15.Text)
        cmd.Parameters.AddWithValue("@volume", TextBox9.Text)
        cmd.Parameters.AddWithValue("@windspeed", TextBox1.Text)
        cmd.Parameters.AddWithValue("@winddir", TextBox12.Text)
        cmd.Parameters.AddWithValue("@applocation", TextBox16.Text)
        cmd.Parameters.AddWithValue("@appcity", TextBox17.Text)
        cmd.Parameters.AddWithValue("@appzip", TextBox18.Text)
        cmd.Parameters.AddWithValue("@county", TextBox19.Text)
        cmd.Parameters.AddWithValue("@adjacentn", TextBox20.Text)
        cmd.Parameters.AddWithValue("@adjacente", TextBox22.Text)
        cmd.Parameters.AddWithValue("@adjacentw", TextBox23.Text)
        cmd.Parameters.AddWithValue("@adjacents", TextBox21.Text)
        cmd.Parameters.AddWithValue("@pestreg", YN1.SelectedValue)
        cmd.Parameters.AddWithValue("@aguse", YN2.SelectedValue)
        cmd.Parameters.AddWithValue("@peststored", YN4.SelectedValue)
        cmd.Parameters.AddWithValue("@commtreated", YN6.SelectedValue)
        cmd.Parameters.AddWithValue("@appmethod", YN8.SelectedValue)
        cmd.Parameters.AddWithValue("@chemdilut", YN10.SelectedValue)
        cmd.Parameters.AddWithValue("@apprate", YN12.SelectedValue)
        cmd.Parameters.AddWithValue("@cautionlabel", YN14.SelectedValue)
        cmd.Parameters.AddWithValue("@warnsign", YN16.SelectedValue)
        cmd.Parameters.AddWithValue("@labelsreadable", YN18.SelectedValue)
        cmd.Parameters.AddWithValue("@appexclusion", YN20.SelectedValue)
        cmd.Parameters.AddWithValue("@avoiddrift", YN23.SelectedValue)
        cmd.Parameters.AddWithValue("@appcertif", YN25.SelectedValue)
        cmd.Parameters.AddWithValue("@ruphandler", YN27.SelectedValue)
        cmd.Parameters.AddWithValue("@clearapparea", YN29.SelectedValue)
        cmd.Parameters.AddWithValue("@appsuspend", YN31.SelectedValue)
        cmd.Parameters.AddWithValue("@contamination", YN34.SelectedValue)
        cmd.Parameters.AddWithValue("@rinsed", YN36.SelectedValue)
        cmd.Parameters.AddWithValue("@disposed", YN38.SelectedValue)
        cmd.Parameters.AddWithValue("@decontamination", YN40.SelectedValue)
        cmd.Parameters.AddWithValue("@handlertrained", YN43.SelectedValue)
        cmd.Parameters.AddWithValue("@trainrecords", YN45.SelectedValue)
        cmd.Parameters.AddWithValue("@handlerage", YN47.SelectedValue)
        cmd.Parameters.AddWithValue("@handlersppe", YN1.SelectedValue)
        cmd.Parameters.AddWithValue("@handlercompetant", YN3.SelectedValue)
        cmd.Parameters.AddWithValue("@decontaminationsite", YN5.SelectedValue)
        cmd.Parameters.AddWithValue("@illness", YN7.SelectedValue)
        cmd.Parameters.AddWithValue("@changearea", YN9.SelectedValue)
        cmd.Parameters.AddWithValue("@waterreq", YN11.SelectedValue)
        cmd.Parameters.AddWithValue("@eyewash", YN13.SelectedValue)
        cmd.Parameters.AddWithValue("@handwash", YN15.SelectedValue)
        cmd.Parameters.AddWithValue("@towels", YN17.SelectedValue)
        cmd.Parameters.AddWithValue("@equipavail", YN19.SelectedValue)
        cmd.Parameters.AddWithValue("@equipused", YN21.SelectedValue)
        cmd.Parameters.AddWithValue("@clothing", YN22.SelectedValue)
        cmd.Parameters.AddWithValue("@respirator", YN24.SelectedValue)
        cmd.Parameters.AddWithValue("@piloteyes", YN26.SelectedValue)
        cmd.Parameters.AddWithValue("@resptraining", YN28.SelectedValue)
        cmd.Parameters.AddWithValue("@resprecords", YN30.SelectedValue)
        cmd.Parameters.AddWithValue("@transportation", YN32.SelectedValue)
        cmd.Parameters.AddWithValue("@hazardcomm", YN33.SelectedValue)
        cmd.Parameters.AddWithValue("@hazardposted", YN35.SelectedValue)
        cmd.Parameters.AddWithValue("@notificationareas", YN37.SelectedValue)
        cmd.Parameters.AddWithValue("@sds", YN39.SelectedValue)
        cmd.Parameters.AddWithValue("@warnprov", YN41.SelectedValue)
        cmd.Parameters.AddWithValue("@warnfollow", YN42.SelectedValue)
        cmd.Parameters.AddWithValue("@pestsafety", YN44.SelectedValue)
        cmd.Parameters.AddWithValue("@hotline", YN46.SelectedValue)
        cmd.Parameters.AddWithValue("@medno", YN48.SelectedValue)
        cmd.Parameters.AddWithValue("@comments", Comments.Text)
        cmd.Parameters.AddWithValue("@correction", TextBox13.Text)
        cmd.Parameters.AddWithValue("@reinsp", nextdt.Text)
        cmd.ExecuteNonQuery()
        conn.Close()
    End Sub

---

The stored procedure that this calls (saverpt, above) is

Code:

---

USE [ESDForms]
GO
/****** Object:  StoredProcedure [dbo].[saverpt]    Script Date: 01/27/2016 12:05:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:                <Author,,Name>
-- Create date: <Create Date,,>
-- Description:        <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[saverpt]
        -- Add the parameters for the stored procedure here
(@rptnum as nvarchar(50),
@increment as int,
@date as date,
@name as nvarchar(50),
@inspphone as nvarchar(12),
@inspmail as nvarchar(50),
@insptype as nvarchar(1),
@tier as nvarchar(1),
@grade as nvarchar(1),
@enddate as date,
@starttime as varchar(4),
@endtime as varchar(4),
@nextinspdate as date,
@lastinspdate as date,
@pgp as nvarchar(5),
@aap as nvarchar(5),
@golf as nvarchar(1),
@ca as nvarchar(5),
@catype as nvarchar(3),
@pu as nvarchar(5),
@putype as nvarchar(3),
@drift as nvarchar(1),
@caseno as nvarchar(20),
@tanksamp as nvarchar(2),
@driftcard as nvarchar(2),
@other as nvarchar(2),
@gwpl as nvarchar(2),
@photo as nvarchar(2),
@docs as nvarchar(2),
@appprog as nvarchar(1),
@equipinfo as nvarchar(1),
@caname as nvarchar(50),
@employer as nvarchar(50),
@equiptype as nvarchar(1),
@handname as nvarchar(50),
@cardno as nvarchar(10),
@noatsite as numeric(18,0),
@equiptag as nvarchar(50),
@puname as nvarchar(50),
@interviewee as nvarchar(50),
@inttitle as nvarchar(50),
@coaddress as nvarchar(50),
@city as nvarchar(50),
@state as nvarchar(2),
@zip as nvarchar(12),
@phone as nvarchar(12),
@pgpname as nvarchar(50),
@commodity as nvarchar(50),
@pest as nvarchar(50),
@acres as numeric(18,2),
@volume as numeric(18,0),
@windspeed as numeric(18,0),
@winddir as nvarchar(3),
@applocation as nvarchar(50),
@appcity as nvarchar(50),
@county as nvarchar(50),
@appzip as nvarchar(12),
@adjacentn as nvarchar(50),
@adjacente as nvarchar(50),
@adjacentw as nvarchar(50),
@adjacents as nvarchar(50),
@chemapplied1 as nvarchar(50),
@ai1 as nvarchar(50),
@epa1 as nvarchar(50),
@rei1 as nvarchar(10),
@tlchem1 as nvarchar(50),
@rup1 as nvarchar(1),
@chemapplied2 as nvarchar(50),
@ai2 as nvarchar(50),
@epa2 as nvarchar(50),
@rei2 as nvarchar(10),
@tlchem2 as nvarchar(50),
@rup2 as nvarchar(1),
@chemapplied3 as nvarchar(50),
@ai3 as nvarchar(50),
@epa3 as nvarchar(50),
@rei3 as nvarchar(10),
@tlchem3 as nvarchar(50),
@rup3 as nvarchar(1),
@chemapplied4 as nvarchar(50),
@ai4 as nvarchar(50),
@epa4 as nvarchar(50),
@rei4 as nvarchar(10),
@tlchem4 as nvarchar(50),
@rup4 as nvarchar(1),
@pestreg as nvarchar(3),
@aguse as nvarchar(3),
@peststored as nvarchar(3),
@commtreated as nvarchar(3),
@appmethod as nvarchar(3),
@chemdilut as nvarchar(3),
@apprate as nvarchar(3),
@cautionlabel as nvarchar(3),
@warnsign as nvarchar(3),
@labelsreadable as nvarchar(3),
@appexclusion as nvarchar(3),
@avoiddrift as nvarchar(3),
@appcertif as nvarchar(3),
@ruphandler as nvarchar(3),
@clearapparea as nvarchar(3),
@appsuspend as nvarchar(3),
@contamination as nvarchar(3),
@rinsed as nvarchar(3),
@disposed as nvarchar(3),
@decontamination as nvarchar(3),
@handlertrained as nvarchar(3),
@trainrecords as nvarchar(3),
@handlerage as nvarchar(3),
@handlersppe as nvarchar(3),
@handlercompetant as nvarchar(3),
@decontaminationsite as nvarchar(3),
@illness as nvarchar(3),
@changearea as nvarchar(3),
@waterreq as nvarchar(3),
@eyewash as nvarchar(3),
@handwash as nvarchar(3),
@towels as nvarchar(3),
@equipavail as nvarchar(3),
@equipused as nvarchar(3),
@clothing as nvarchar(3),
@respirator as nvarchar(3),
@piloteyes as nvarchar(3),
@resptraining as nvarchar(3),
@resprecords as nvarchar(3),
@transportation as nvarchar(3),
@hazardcomm as nvarchar(3),
@hazardposted as nvarchar(3),
@notificationareas as nvarchar(3),
@sds as nvarchar(3),
@warnprov as nvarchar(3),
@warnfollow as nvarchar(3),
@pestsafety as nvarchar(3),
@hotline as nvarchar(3),
@medno as nvarchar(3),
@comments as ntext,
@correction as numeric(18,0),
@reinsp as date,
@forme as nvarchar(50))




AS
BEGIN
        -- SET NOCOUNT ON added to prevent extra result sets from
        -- interfering with SELECT statements.
        SET NOCOUNT ON;

insert into forma
(rptnum,[date],increment,inspname, insptype, tier, grade, enddate, starttime, endtime, nextinspdate, lastinspdate, pgp, aap, golf, ca, catype, pu, putype, drift, caseno, tanksamp, driftcard, other, gwpl, photo, docs, appprog, equipinfo, caname, employer, equiptype, handname, cardno, noatsite, equiptag, puname, interviewee, inttitle, coaddress, city, [state], zip, phone, pgpname, commodity, pest, acres, volume, windspeed, winddir, applocation, appcity, appzip, county, adjacentN, adjacente, adjacentw, adjacents, chemapplied1, ai1, epa1, rei1, tlchem1, rup1, chemapplied2, ai2, epa2, rei2, tlchem2, rup2, chemapplied3, ai3, rei3, tlchem3, rup3, chemapplied4, ai4, epa4, rei4, tlchem4, rup4, pestreg, aguse, peststored, commtreated, appmethod, chemdilut, apprate, cautionlabel, warnsign, labelsreadable, appexclusion, avoiddrift, appcertif, ruphandler, clearapparea, appsuspend, contamination, rinsed, disposed, decontamination, handlertrained, trainrecords, handlerage, handlersppe, handlercompetant, decontaminationsite, illness, changearea, waterreq, eyewash, handwash, towels, equipavail, equipused, clothing, respirator, piloteyes, resptraining, resprecords, transportation, hazardcomm, hazardposted, notificationareas, sds, warnprov, warnfollow, pestsafety, hotline, medno, comments, correction, reinsp) values (@rptnum, @date, @increment, @name, @insptype, @tier, @grade, @enddate, @starttime, @endtime, @nextinspdate, @lastinspdate, @pgp, @aap, @golf, @ca, @catype, @pu, @putype,@drift, @caseno, @tanksamp, @driftcard, @other, @gwpl, @photo, @docs, @appprog, @equipinfo, @caname, @employer, @equiptype, @handname, @cardno, @noatsite, @equiptag, @puname, @interviewee, @inttitle, @coaddress, @city, @state, @zip, @phone, @pgpname, @commodity, @pest, @acres, @volume, @windspeed, @winddir, @applocation, @appcity, @appzip, @county, @adjacentN, @adjacente, @adjacentw, @adjacents, @chemapplied1, @ai1, @epa1, @rei1, @tlchem1, @rup1, @chemapplied2, @ai2, @epa2, @rei2, @tlchem2, @rup2, @chemapplied3, @ai3, @rei3, @tlchem3, @rup3, @chemapplied4, @ai4, @epa4, @rei4, @tlchem4, @rup4, @pestreg, @aguse, @peststored, @commtreated, @appmethod, @chemdilut, @apprate, @cautionlabel, @warnsign, @labelsreadable, @appexclusion, @avoiddrift, @appcertif, @ruphandler, @clearapparea, @appsuspend, @contamination, @rinsed, @disposed, @decontamination, @handlertrained, @trainrecords, @handlerage, @handlersppe, @handlercompetant, @decontaminationsite, @illness, @changearea, @waterreq, @eyewash, @handwash, @towels, @equipavail, @equipused, @clothing, @respirator, @piloteyes, @resptraining, @resprecords, @transportation, @hazardcomm, @hazardposted, @notificationareas, @sds, @warnprov, @warnfollow, @pestsafety, @hotline, @medno, @comments, @correction, @reinsp)
END

---

So, I am really not finding why the error is occurring.

Well I do see a few places where you are assigning a string to a numeric field there so one of those could be causing the issue. I have saw this happen using a money field where the value was a string even though the string held a valid numeric value. I would double check the value of each of those would be numeric field assignments to insure that they all are in fact getting numbers and if that be the case I would try converting those strings into the proper numeric type prior to the assignment in the parameters

Thanks for the assist. I did find where I had mis-assigned a textbox control. I was just hoping that VS would tell me where the mistake was..
On another note - in this same application I need to save a data table to SQL that I have created from user input. Are you aware of anyplace I can go to find out more about how this is accomplished?

I have not really did much with data tables in VB.Net but I would think searching for something like working with data tables in VB.Net would return some useful results.