Syntax near ','.

Umut çelik

Form1 frm = new Form1();

projeservices = new HProje();

projeservices.update("UPDATE ProjeEkle SET Yuklenici='" + txtyuklenicig.Text + "',IhaleBedeli='" + Convert.ToDecimal(ntxtihalebedelig.Text.Replace(",", ".")) + "',IhaleTarihi='" + Convert.ToDateTime(dtpihaletarihig.Text) + "',SozlesmeTarihi='" + Convert.ToDateTime(dtpsozlesmetarihig.Text) + "',IsinSuresi='" + ntxtisinsuresig.Text + "',TeslimTarihi='" + Convert.ToDateTime(dtptxtteslimg.Text) + "',BaslamaTarihi=,'" + Convert.ToDateTime(dtptxtbaslamag.Text) + "',BitisTarihi='" + Convert.ToDateTime(dtptxtbitisg.Text) + "' WHERE IsinAdi='" + txtisinadig.Text + "'");

I wonder where my error

8 Replies

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

Vipul Malhotra10y ago
Hi Umut, Please accept the answer if it helped. Thanks
0
Rajeesh Menoth10y ago
Hi,

Welcome :)

The answer is helpful , Please accept it!!!
0
Umut çelik10y ago
thanks everyone As you can also issue "BaslamaTarihié"=, problem solved
0
Rajeesh Menoth10y ago
Hi,

Remove the "," near BaslamaTarihi=, ur code.
("UPDATE ProjeEkle SET Yuklenici='" + txtyuklenicig.Text + "',
IhaleBedeli='" + Convert.ToDecimal(ntxtihalebedelig.Text.Replace(",", ".")) + "',
IhaleTarihi='" + Convert.ToDateTime(dtpihaletarihig.Text) + "',
SozlesmeTarihi='" + Convert.ToDateTime(dtpsozlesmetarihig.Text) + "',
IsinSuresi='" + ntxtisinsuresig.Text + "',
TeslimTarihi='" + Convert.ToDateTime(dtptxtteslimg.Text) + "',
BaslamaTarihi=,'" + Convert.ToDateTime(dtptxtbaslamag.Text) + "',
BitisTarihi='" + Convert.ToDateTime(dtptxtbitisg.Text) + "' WHERE IsinAdi='" + txtisinadig.Text + "'"

Correct Code :
projeservices.update("UPDATE ProjeEkle SET Yuklenici='" + txtyuklenicig.Text + "',IhaleBedeli='" + Convert.ToDecimal(ntxtihalebedelig.Text.Replace(",", ".")) + "',IhaleTarihi='" + Convert.ToDateTime(dtpihaletarihig.Text) + "',SozlesmeTarihi='" + Convert.ToDateTime(dtpsozlesmetarihig.Text) + "',IsinSuresi='" + ntxtisinsuresig.Text + "',TeslimTarihi='" + Convert.ToDateTime(dtptxtteslimg.Text) + "',BaslamaTarihi='" + Convert.ToDateTime(dtptxtbaslamag.Text) + "',BitisTarihi='" + Convert.ToDateTime(dtptxtbitisg.Text) + "' WHERE IsinAdi='" + txtisinadig.Text + "'");
+1
Ankur Mistry10y ago
Hello,

Put a break point and check your string, might be there is extra ',' in string.
0
Vipul Malhotra10y ago
Hi,

There is an "," in your query after "BaslamaTarihi="

Remove that and it would work.

Hope it helped.

Please accept it as answer.
0
Umut çelik10y ago
incorrect syntax near ','.
0
Saillesh Pawar10y ago
PLZ SPECIFY THE ERROR DETAILS
0