azitaj
سه شنبه 20 مرداد 1394, 01:30 صبح
سلام دوستان
جرا ازاین برنامه ارور میگیره لطفا راهنمایی کنید
این کد
SqlCommand cmd = new SqlCommand("delete from tbl_student where name_stu=N'" + txtn.Text + "',fname=N'" + txtfn.Text + "',ish_sh='" + txtshsh.Text + "',d_student='" + txtid.Text + "',field=N'"+radf.Text+"',input=N'"+txtin.Text+"',year='"+txty.Text+"',average='"+txtav.Text+"',tel_number='"+txttel.Text+"',address=N'"+txtadd.Text+"',email='"+txtemail+"'",cn);
cn.Open();
if (cmd.ExecuteNonQuery() > 0)
lblMsg.Text = "اطلاعات حذف شد!";
else lblMsg.Text = "اطلاعات حذف نشد";
cn.Close();
txtn.Text = "";
txtfn.Text = "";
txtid.Text = "";
txtshsh.Text = "";
radf.Text = "";
txtin.Text = "";
txty.Text = "";
txtav.Text = "";
txttel.Text = "";
txtadd.Text = "";
txtemail.Text = "";
Bindgridview();
واین هم ارور
Incorrect syntax near ','.
جرا ازاین برنامه ارور میگیره لطفا راهنمایی کنید
این کد
SqlCommand cmd = new SqlCommand("delete from tbl_student where name_stu=N'" + txtn.Text + "',fname=N'" + txtfn.Text + "',ish_sh='" + txtshsh.Text + "',d_student='" + txtid.Text + "',field=N'"+radf.Text+"',input=N'"+txtin.Text+"',year='"+txty.Text+"',average='"+txtav.Text+"',tel_number='"+txttel.Text+"',address=N'"+txtadd.Text+"',email='"+txtemail+"'",cn);
cn.Open();
if (cmd.ExecuteNonQuery() > 0)
lblMsg.Text = "اطلاعات حذف شد!";
else lblMsg.Text = "اطلاعات حذف نشد";
cn.Close();
txtn.Text = "";
txtfn.Text = "";
txtid.Text = "";
txtshsh.Text = "";
radf.Text = "";
txtin.Text = "";
txty.Text = "";
txtav.Text = "";
txttel.Text = "";
txtadd.Text = "";
txtemail.Text = "";
Bindgridview();
واین هم ارور
Incorrect syntax near ','.