مشاهده نسخه کامل
: ghaderif
12-06-2011, 16:05
برای update یک فرم از کد زیر استفاده کردم. محتویات combobox از بانک خوانده می شود در هنگام update با پیغام زیر روبرو می شوم:
کد:
con.Open()
Dim cmdup As SqlCommand = New SqlCommand("update regedu set namecourse='" + Cstandard.SelectedItem + "',courseno='" + tcodest.Text + "',term='" +
uterm.Text + "',fname='" + Cnameteacher.SelectedItem + "',teachercode='" + Tcartno.Text +
"',cost='" + Tcost.Text +
"',datestart='" + datestu.Text + "',dateend='" + dateenu.Text +
"',day='" + Cdayu.SelectedItem + "',time='" + Ctimeu.SelectedItem +
"',stno='" + stnou.Text + "',fnamest='" + namestu.Text +
"',lnamest='" + familstu.Text + "',fishno='" + Tfishnou.Text + "',fishprice='" +
Tpricefishu.Text + "',bedehkar='" + Tbedehu.Text + "',bestankar=" + Tbestu.Text + ",rest=" + Trestu.Text + "where groupcode='" + Tsearch.Text + "'", con)
cmdup.ExecuteNonQuery()
con.Close()
MsgBox("اطلاعات فوق ویرایش شد")
پیغام خطا:
Operator '+' is not defined for string "update regedu set namecourse='" and type 'DataRowView'.
کد:
con.Open()
Dim cmdup As SqlCommand = New SqlCommand("update regedu set namecourse='" + Cstandard.SelectedItem + "',courseno='" + tcodest.Text + "',term='" +
uterm.Text + "',fname='" + Cnameteacher.SelectedItem + "',teachercode='" + Tcartno.Text +
"',cost='" + Tcost.Text +
"',datestart='" + datestu.Text + "',dateend='" + dateenu.Text +
"',day='" + Cdayu.SelectedItem + "',time='" + Ctimeu.SelectedItem +
"',stno='" + stnou.Text + "',fnamest='" + namestu.Text +
"',lnamest='" + familstu.Text + "',fishno='" + Tfishnou.Text + "',fishprice='" +
Tpricefishu.Text + "',bedehkar='" + Tbedehu.Text + "',bestankar=" + Tbestu.Text + ",rest=" + Trestu.Text + "where groupcode='" + Tsearch.Text + "'", con)
cmdup.ExecuteNonQuery()
con.Close()
MsgBox("اطلاعات فوق ویرایش شد")
پیغام خطا:
Operator '+' is not defined for string "update regedu set namecourse='" and type 'DataRowView'.