Any help would be appreciated
Why is error coming even though I am using semester as varchar in table defination?
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='Pass' WHERE Semester=9"
Dim cmd2 As SqlCommand
cmd2 = New SqlCommand
cmd2 = New SqlCommand(query2, con)
cmd2.ExecuteNonQuery()
con.close()
