str = "update RoomInfo set Status = '" + cmbStatus.Text.ToString() + "', AssignedTo = '" + txtAssigned.Text.ToString() + "'where RoomNo ='" + objDataGridView.CurrentRow.Cells["RoomNo"].Value"'";
错误如下,请帮忙改一下呀!错误 1 应输入 ; E:\javawork\所有课件\课程设计\01_.NET CODE\RoyalHouseKeeping\RoyalHouseKeeping\RoyalHouseKeeping\RoyalHouseKeeping\RoyalHouseKeeping\frmHouseKeeping.cs 722 207 RoaylHouseKeeping
错误如下,请帮忙改一下呀!错误 1 应输入 ; E:\javawork\所有课件\课程设计\01_.NET CODE\RoyalHouseKeeping\RoyalHouseKeeping\RoyalHouseKeeping\RoyalHouseKeeping\RoyalHouseKeeping\frmHouseKeeping.cs 722 207 RoaylHouseKeeping
少了一个“+” 号?
string sql=string.Format("update RoomInfo set Status = '{0}',AssignedTo = '{1}' where RoomNo ='{2}'",cmbStatus.Text,txtAssigned.Text,objDataGridView.CurrentRow.Cells["RoomNo"].Value);
str = "update RoomInfo set Status = '" + cmbStatus.Text.ToString() + "', AssignedTo = '" + txtAssigned.Text.ToString() + "' where RoomNo ='" + objDataGridView.CurrentRow.Cells["RoomNo"].Value+"'";