I am using following code, but getting error.
conversion failed when converting the varchar value 'passed' to data type int
Try
con.open()
Dim query = "update NTable SET Semester=Semester+1 WHERE Semester BETWEEN 1 AND 8 "
Dim cmd As SqlCommand
cmd = New SqlCommand(query, con)
cmd.ExecuteNonQuery()
con.close()
con.open()
Dim query2 = "update NTable SET Semester='Passed' WHERE Semester=9"
Dim cmd2 As SqlCommand
cmd2 = New SqlCommand
cmd2 = New SqlCommand(query2, con)
cmd2.ExecuteNonQuery()
con.close()
display()
Catch ex As Exception
MsgBox(ex.Message)
End Try
Is there anything I am missing?
