服务,底层是个什么样的原理
更新时间:2023-09-28 08:09
最满意答案
在
where
子句之前,我where
参数后面缺少一个空格:String sql = "UPDATE cashieraccount SET cashieruser = ?cashieruser, cashierpass = ?cashierpass, isadmin = ?isadmin, cashierfname = ?cashierfname, cashiermname = ?cashiermname, cashierlname = ?cashierlname"; sql += " WHERE cashierid = ?cashierid"; // here ^
I'm missing a white-space behind your parameters, before the
where
clause:String sql = "UPDATE cashieraccount SET cashieruser = ?cashieruser, cashierpass = ?cashierpass, isadmin = ?isadmin, cashierfname = ?cashierfname, cashiermname = ?cashiermname, cashierlname = ?cashierlname"; sql += " WHERE cashierid = ?cashierid"; // here ^
相关问答
更多-
在where子句之前,我where参数后面缺少一个空格: String sql = "UPDATE cashieraccount SET cashieruser = ?cashieruser, cashierpass = ?cashierpass, isadmin = ?isadmin, cashierfname = ?cashierfname, cashiermname = ?cashiermname, cashierlname = ?cashierlname"; sql += " WHERE cashi ...
-
当不需要时,SQL参数应该在更新语句中(What should a SQL Parameter be in a update statement be when it's not required)[2023-08-20]
如果col2不能更新为NULL,请尝试此操作 update table1 set col1 = @someval , col2 = ISNULL(@someotherval, col2) where col3 = 1; If col2 cannot ever be updated to NULL, try this update table1 set col1 = @someval , col2 = ISNULL(@someotherval, col2) where col3 = 1; -
你似乎有一个错字; WHERE [CallID]= $callid 应该是最有可能的 WHERE [CallID]= @callid You seem to have a typo; WHERE [CallID]= $callid should most likely be WHERE [CallID]= @callid
-
SQL语句在C#中失败(SQL statement fails in C#)[2023-04-12]
您需要在update.ExecuteNonQuery()之前执行update.ExecuteNonQuery() 。 您还需要使用using语句来确保在update.ExecuteNonQuery()执行后关闭connection 。 update.Parameters.Add(...)方法中的参数名称也是错误的,你忘了添加@ using (SqlConnection connection = new SqlConnection(@"Data Source=(LocalDB rest of my conn ... -
使用c#[关闭]在SQL Server 2014中更新语句不起作用(Update statement is not working in SQL Server 2014 using c# [closed])[2022-03-28]
交易示例并清理您的一些代码: **确保输入修复问题的更改 (有些我离开以防你重复使用) (using *子句实现了IDisposable,它会为你清理连接) //rename ct1, ct and fields to something meaningful. This will help you when you have ct1-ct1000 :) using(SqlConnection cn1 = new SqlConnection(ConfigurationManager.Conn ... -
正如gzaxx所说的。尝试改变这一点 string queryText = "UPDATE Customers SET Balance = ?, where CustomerId = ?;"; 同 string queryText = "UPDATE Customers SET Balance = ? where CustomerId = ?;"; As gzaxx said .. Try change this string queryText = "UPDATE Customers SET Bala ...
-
我会使用数据库权限。 创建一个只有读取访问权限的数据库用户,然后,执行除SELECT之外的任何查询都将失败。 I would use db permissions. Create a database user with read-access only and then, any queries that do anything other than SELECT will fail.
-
在C#中形成参数化SQL语句的正确方法是什么(What is the correct way to form a parameterized SQL statement in C#)[2023-04-18]
您不必在SQL代码中重新声明该变量。 这应该工作: sql = "INSERT INTO " + "database.dbo.table" + "(database.dbo.tabe.RowName) " + "VALUES " + "(@RowName) "; cmd.CommandText = sql; cmd.Parameters.AddWithValue("@RowValue ", Row.RowName); You don ... -
使用C#中的if语句通过UPDATE更新特定行(sql)(Update a specific row(sql) via UPDATE using if-statement in C#)[2023-03-22]
更改你的sql语句: UPDATE [Course_Student] SET QueueIndex = QueueIndex - 1, Accepted = (CASE QueueIndex WHEN 1 THEN 1 ELSE 0 END) WHERE QueueIndex > 0 AND CID = @CourseID; 希望这可以帮助; change your sql statement: UPDATE [Course_Student] SET QueueIndex = QueueIn ... -
C#更新SQL Server表(C# update SQL Server table)[2022-07-12]
究竟是什么问题? 我认为在使用参数化查询指定参数时,您不再需要使用引号,因此 string querystr = "UPDATE Users SET User_FirstName='@User_FirstName', User_LastName='@User_LastName' WHERE User_ID='@User_ID'"; 应该成为 string querystr = "UPDATE Users SET User_FirstName=@User_FirstName, User_LastName=@ ...