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