看到這個問題，首先檢查SQL陳述句是否缺少 “ ‘ ”號，，如何SQL陳述句沒有錯誤，就檢查得到的資料中是否有單引號（“ ‘ ”）、雙引號（“ “ ”）等
如何得到的資料有單雙引號，就用 SQL連接法對資料進行操作，SQL連接法符號是 “ @ ”，
例如
1 string sql = "update Users set " + "UserRoleId=@UserRoleId," + "UserStateId=@UserStateId," + "LoginId=@LoginId," + "LoginPwd=@LoginPwd," + "Name=@Name," + "Address=@Address," + "Phone=@Phone," + "Mail=@Mail " +" where Id=@Id"; 2 SqlParameter[] para = new SqlParameter[] 3 { 4 new SqlParameter("@Id",us.Id), 5 new SqlParameter("@LoginId",us.LoginId), 6 new SqlParameter("@LoginPwd",us.LoginPwd), 7 new SqlParameter("@Name",us.Name), 8 new SqlParameter("@Address",us.Address), 9 new SqlParameter("@Phone",us.Phone),10 new SqlParameter("@Mail",us.Mail),11 new SqlParameter("@UserStateId",us.UserStates.Id), //FK12 new SqlParameter("@UserRoleId",us.UserRoles.Id) //FK13 };14 DBHelper.ExecuteCommand(sql, para);
即可，
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/12363.html
標籤：ASP.NET