I am working on an if statement that I want to check if a unique value , which is stored in the session object, is already inserted into a database's table. Thus the coding would be something like :
* Connect to database and table
* If unique value = session "(Value") update the database
Else insert this value into the table
Now within asp.net I assume you would use the select command with an sql statement to do this, but how exactly should I do this ?
e.g Dim queryString As String = "SELECT [tblxxx].[value] FROM [tblxxx]"
If [tblxxx].[value] = Session("value") ......
However this results in an error stating "Name [tblxxx] is not declared"....
Any examples would help ? I'm using asp.net 1.1 with vb
.net and connecting to an access database.