c# Error converting data type varchar to numeric.

Umut çelik

my code

projeservices = new HProje();

projeservices.insert("INSERT INTO ProjeEkle(IsinAdi,Yuklenici,IhaleBedeli,IhaleTarihi,SozlesmeTarihi,IsinSuresi,TeslimTarihi,BaslamaTarihi,BitisTarihi)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

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Umut çelik10y ago
I found an error

right answer:

projeservices = new HProje(); projeservices.insert("INSERT INTO ProjeEkle(IsinAdi,Yuklenici,IhaleBedeli,IhaleTarihi,SozlesmeTarihi,IsinSuresi,TeslimTarihi,BaslamaTarihi,BitisTarihi)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 tuncer10y ago
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 Ansari10y ago
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 Mohapatra10y ago
Debug and provide what is the complete text of SQL insert query.
Umut çelik10y ago
hocam decimal diye tanimli.numericupdown text box oluyor formda
Umut çelik10y ago
Error converting data type varchar to numeric
Manas Mohapatra10y ago
What is the error saying?
ali tuncer10y ago
what is the value of ntxtisinsuresi.Text? is it integer?
Umut çelik10y ago
thanks i try but not working
Manas Mohapatra10y ago
Remove single quote from ntxtihalebedeli.Text in your query:

projeservices.insert("INSERT INTO ProjeEkle(IsinAdi,Yuklenici,IhaleBedeli,IhaleTarihi,SozlesmeTarihi,
IsinSuresi,TeslimTarihi,BaslamaTarihi,BitisTarihi)values('" + txtisinadi.Text + "',
'" + txtyuklenici.Text + "'," +ntxtihalebedeli.Text + ",'" +dtpihaletarihi.Text + "',
'" + dtpsozlesmetarihi.Text + "','" +ntxtisinsuresi.Text + "',
'" + dtptxtteslim.Text + "','" + dtptxtbaslama.Text + "','" + dtptxtbitis.Text + "')");