Hi all,

i have a table "Contracts", with fields CompanyNumber, MaturityDate and other fields.

i have a form in vb.net, with a textbox that should check if the entered company number exist in my db, if it does it should check whether the maturity date is bigger or less than current date.

Any one out there that knows how to go about it? Here is the code am trying with;


Private bindingSource1 As New BindingSource()
Private dataAdapter As New OleDbDataAdapter()
Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=mtc.mdb"
Dim selectCommand As String
Dim connection As New OleDbConnection(connectionString)
Dim current As Date = Date.Now

selectCommand = "select * from Contracts where CompanyNumber = '" & txtCnumber.Text & "'"

Dim MyCmd As New OleDbCommand(selectCommand, connection)

Dim count As Integer
connection.Open()
count = CInt(MyCmd.ExecuteScalar())
connection.Close()

If count = 0 Then
MsgBox("Employee new on contract, add all areas")

ElseIf count > 0 And current.Date > "MaturityDate" Then
MsgBox("Employee already has contract and it has matured,add contract info only!")
Else
MsgBox("Employee already has contract and it has not matured yet")
End If

Thanx for the prvnkmr194, The Maturitydate supposed to come from the db, and compare it to current date. My question is rather how to call MaturityDate from db and do the comparison

ElseIf count > 0 And DateDiff(DateInterval.Day, "#"+MaturityDate+"#", Now())>0 Then

Here i assume that you know how to retrieve the data from database.
MaturityDate is a variable of type string which contain date in the form MM/DD/YYYY and should be enclosed within # this symbol so that it looks like #3/13/2011#

Hope it ll help you

Retrieving the data from database is a problem, excuse me but am new at all these.. please help.

Thanx BIG, got it

Mark this thread as solved, if you got solution

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.