通过 Visual Studio 更新 SQL Server 中的 UsageTime [英] Updating UsageTime in SQL Server via Visual Studio

问题描述

我想更新 UsageTime 当时间每分钟一次时，无法获得正确的代码.

I want to update the UsageTime when the time ticks per minute, couldn't get the right code.

Private Sub LBLTime_TextChanged(sender As Object, e As EventArgs) Handles LBLTime.TextChanged

    con.ConnectionString = My.Settings.Finals_DBConnectionString
    cmd.Connection = con
    con.Close()
    con.Open()
    cmd.CommandText = "update tbl_transaction set usagetime = @ut, remainingtime = @rt"
    cmd.Parameters.Clear()
    cmd.Parameters.AddWithValue("ut", +1)
    cmd.Parameters.AddWithValue("rt", -1)
    cmd.Parameters cmd.ExecuteNonQuery()
    End With
End Sub

推荐答案

试试这个.

update tbl_transaction set usagetime = usagetime+1 , remainingtime = remainingtime -1 

在您的 sql 中也看不到任何位置".这不是一个好习惯

Also don't see any "where" in your sql. It's not a good practice

这篇关于通过 Visual Studio 更新 SQL Server 中的 UsageTime的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！