PDA

View Full Version : سوال: اشکال در کوئری Update برای Oracle‎



arashavir
پنج شنبه 03 مهر 1393, 14:54 عصر
دوستان ایراد این متد کجاست


private int changeBM(string altesBaumuster, string neuesBaumuster)
{
string commandSQL = string.Empty;
commandSQL = "Update DPPLAUSIS SET DPPLAUSIS.BM = '" + fixBM(neuesBaumuster) + "' WHERE DPPLAUSIS.ACode = '700' AND DPPLAUSIS.BM LIKE '" + altesBaumuster + "%'";
try
{
cmd = new OracleCommand();
cmd.Connection = con;
cmd.CommandText = commandSQL;
return cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return -2;
}
finally
{
getTableforBM(altesBaumuster);
}
}

arashavir
پنج شنبه 03 مهر 1393, 15:18 عصر
sharmandehye hame doostan,man too iran zendegi nemikonam va keyboard am lable farsi nadare,khodam ham chandan dar type farsi ravoon nistam!!
in methode bayad too oracle ye sotoono ke Baumuster naam dare be meghdare jadidi tabdil kone be sharti ke Acode = 700 bashe.alteBaumuster va NeueBaumuster too in methode ham to ta textbox hastan,mamnoonam az lotfe doostan

fakhravari
پنج شنبه 03 مهر 1393, 23:29 عصر
متن خطا بزارید

arashavir
جمعه 04 مهر 1393, 10:32 صبح
mamnoon az lotfet dooste aziz,eshkaalesho bartaraf kardam,zendeh bashin