Avatar of mathieu_cupryk
mathieu_cupryk
Flag for Canada

asked on 

Update problem on sql in vb.net.

Dim ConnectionString As String = System.Configuration.ConfigurationSettings.AppSettings("FinSolMainDBConn")
        Dim connfinsol As New System.Data.SqlClient.SqlConnection(ConnectionString)
        Dim strsql As String
        strsql = "UPDATE [CCFinSol].[dbo].[TransOverride] SET " & "Policy_Nbr='" & txtPolicyNumber.Text & "',Trans_CodeOrig='" & cmbOriginalTransCode.Text & "', Trans_Eff_Date='" & DateEditTransEff.Value & "', Override_Code='" & cmbOverrideAction.Text & "', NR_CodeOvr='" & cmbOverrideNR.Text & "', Trans_CodeOvr='" & cmbOverrideTransactionCode.Text & "', Plan_Year='" & txtPlanYear.Text & "'"
        connfinsol.Open()
        Dim cmd As New SqlDbCommand(strsql, connfinsol)
        cmd.ExecuteNonQuery()
        connfinsol.Close()

I am not sure how to set this up. I get an error on SqlDbCommand Syntax?
Where am I going wrong here.
Visual Basic.NET

Avatar of undefined
Last Comment
amyhxu

8/22/2022 - Mon