How to check if Row exists in MS Acess

See more:

VB

Can anyone kindly help me with my problem:

Through the use of VB.NET i would like to know if a row in ms access exists or not. If it does exist then it should set the variable pass = true else should be false.

Im doing a school application program and what user needs to select is the year they wish to start now the database has the previous 10 years etc and in October every year it adds the new year to accept application for the next year.

but the problem i have is if someone selects to start for e.g 2013 before october i needed the program to check the database to see if the row of 2013 (row 12) exits if it does then accept application if row 12 (2013) does not exist give error message.

How can i achieve this??

I just need to know how to check the row information..
Please can someone kindly help

i have tried this code:

 Try 
sql = ("SELECT * FROM Application") 
Dim dsx As New DataSet("app") 
Dim dax As New OleDb.OleDbDataAdapter 
dax = New OleDb.OleDbDataAdapter(sql, con)
 dax.Fill(dsx, "app")
 Dim tblapplications As DataTable 
tblapplication = dsx.Tables("app") 

If dsx.Tables("app").Rows.count = nothing Then 
msgbox("Year does not exist!")
 else
 call add()
 End If 
Catch ex As Exception MsgBox(ex.ToString)
 End Try 
End Sub 

Help needed urgently!!!

But this does not work for me, dont know how to fix, so can someone help


Thanks