c# Error converting data type varchar to numeric.

Question

my code projeservices = new HProje(); projeservices.insert(INSERT INTO ProjeEkle(IsinAdiYukleniciIhaleBedeliIhaleTarihiSozlesmeTarihiIsinSuresiTeslimTarihiBaslamaTarihiBitisTarihi)values(' + txtisinadi.Text + '' + txtyuklenici.Text + '' +ntxtihalebedeli.Text + '' +dtpihaletarihi.Text + '' + dtpsozlesmetarihi.Text + '' +ntxtisinsuresi.Text + '' + dtptxtteslim.Text + '' + dtptxtbaslama.Text + '' + dtptxtbitis.Text + ')); my ProjeEkle table Id int Unchecked IsinAdi nvarchar(200) Unchecked Yuklenici nvarchar(200) Unchecked IhaleBedeli decimal(18 3) Unchecked IhaleTarihi datetime Unchecked SozlesmeTarihi datetime Unchecked IsinSuresi int Unchecked TeslimTarihi datetime Unchecked BaslamaTarihi datetime Unchecked BitisTarihi datetime Unchecked Unchecked Can you help title also is the reason I get the error

Umut çelik · Answer

I found an error right answer: projeservices = new HProje(); projeservices.insert(INSERT INTO ProjeEkle(IsinAdiYukleniciIhaleBedeliIhaleTarihiSozlesmeTarihiIsinSuresiTeslimTarihiBaslamaTarihiBitisTarihi)values(' + txtisinadi.Text + '' + txtyuklenici.Text + '' +Convert.ToDecimal( ntxtihalebedeli.Text.Replace( .)) + '' +Convert.ToDateTime( dtpihaletarihi.Text )+ '' + Convert.ToDateTime( dtpsozlesmetarihi.Text) + '' +ntxtisinsuresi.Text + '' + Convert.ToDateTime(dtptxtteslim.Text) + '' + Convert.ToDateTime(dtptxtbaslama.Text) + '' + Convert.ToDateTime(dtptxtbitis.Text) + ')); thanks everyone......

ali tuncer · Answer

I think you need to remove single quote from ntxtisinsuresi.Text as well in your query.. It is Int you are probably sending a value like '12.0' that's why you are getting error..

Imtiyaz Ansari · Answer

Hello First of all you make sure ntxtihalebedeli textbox dataType are decimal type or not because your field datatype is decimal and you passing string(varchar ) datatype .. so throwing exception  converting data type varchar to numeric Note:- passing string datatype :- '  + textbox.Text +  ' //(single doubble quote ) Passing Numeric datatype :-  + Convert.Decimal( textbox.Text) +

Manas Mohapatra · Answer

Debug and provide what is the complete text of SQL insert query.

Umut çelik · Answer

hocam decimal diye tanimli.numericupdown text box oluyor formda

Umut çelik · Answer

Error converting data type varchar to numeric

Manas Mohapatra · Answer

What is the error saying?

ali tuncer · Answer

what is the value of ntxtisinsuresi.Text? is it integer?

Umut çelik · Answer

thanks i try but not working

Manas Mohapatra · Answer

Remove single quote from ntxtihalebedeli.Text in your query: projeservices.insert(INSERT INTO ProjeEkle(IsinAdiYukleniciIhaleBedeliIhaleTarihiSozlesmeTarihi IsinSuresiTeslimTarihiBaslamaTarihiBitisTarihi)values(' + txtisinadi.Text + ' ' + txtyuklenici.Text + ' +ntxtihalebedeli.Text + ' +dtpihaletarihi.Text + ' ' + dtpsozlesmetarihi.Text + '' +ntxtisinsuresi.Text + ' ' + dtptxtteslim.Text + '' + dtptxtbaslama.Text + '' + dtptxtbitis.Text + '));