我有一个收到货币类型的列。我希望在抵消栏中增加金额。如何获得具有新价值的Previoius价值？ [英] I Have A Receved Money Type Column. I Want To Add Amount In Preveious Value In Receved Column. How To Get Previoius Value To Add With New Value?

问题描述

Dim pre As Integer = dr.Item("receved")
                Dim newrec As Integer = CInt(receved) + pre

                cmd1.CommandText = "update feerpt set receved=" & newrec & " where studentid=" & studentid & ""
                cmd1.ExecuteNonQuery()

推荐答案

不确定你的问题是什么



肯定你只是做

not sure what your issue is

surely you just do

"update feerpt set receved = receved + " & newrec & " where studentid ..... 

是吗？

yes ?

试试这个：

Try this:

"update feerpt set receved=receved + " & newrec & " where studentid='" & studentid & "'"

但是，你应该使用参数查询到防止-SQL注入攻击，在-SQL Server.aspx [ ^ ]

这篇关于我有一个收到货币类型的列。我希望在抵消栏中增加金额。如何获得具有新价值的Previoius价值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！