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.