SqlCommand cmd=new SqlCommand("update AT_UserInformation1 set DutyName='"+changedDutyName+"',DeptId='"+changedDeptId+"' where EmployeeId='"+EmployeeId+"'";"update AT_Duty set Popedom='"+changedPopedom+"'where EmployeeId='"+EmployeeId+"'",sqlcon); 有问题
可以的,你看看你的语句 SqlCommand cmd=new SqlCommand("update AT_UserInformation1 set DutyName='"+changedDutyName+"',DeptId='"+changedDeptId+"' where EmployeeId='"+EmployeeId+"'";"update AT_Duty set Popedom='"+changedPopedom+"'where EmployeeId='"+EmployeeId+"'",sqlcon); 第二个where前面少空格
有问题
SqlCommand cmd=new SqlCommand("update AT_UserInformation1 set DutyName='"+changedDutyName+"',DeptId='"+changedDeptId+"' where EmployeeId='"+EmployeeId+"'";"update AT_Duty set Popedom='"+changedPopedom+"'where EmployeeId='"+EmployeeId+"'",sqlcon);
第二个where前面少空格
应该可以