how can i limit the borrowing of books in our system.
the user is only allowed to borrow books 3 times a day..
so if the user reaches the limit,.the system will not allow the user to borrow books anymore.
here is our codes but it does not work well..so we need help.. tnx!!
Private Sub TextBox11_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox11.TextChanged
con = New OleDbConnection("Provider = Microsoft.ace.oledb.12.0; data source=|DataDirectory|\AutomatedLibrarySystem.accdb")
cmd = New OleDbCommand("Select * from Borrowing where Username='" + TextBox11.Text + "'", con)
dr = cmd.ExecuteReader()
If (dr.Read() = True) Then
disDate.Text = dr(10)
If disDate.Text <> TextBox6.Text Then
num = 1
num = num + 1
NumBookBor.Text = num
If NumBookBor.Text.Length = 3 Then
Write the code in LostFocus event...
and change the sql statement to query for date condition as well...
Dim TNo As Integer
TNo = 0
con = New OleDbConnection("Provider = Microsoft.ace.oledb.12.0; " _
cmd = New OleDbCommand("Select Count(*) from Borrowing where Username='" _
& TextBox11.Text + "' And MyDateFld = #" & TextBox6.Text & "#", con)
TNo = cmd.ExecuteScalar()
If TNo >= 3 Then
Write a C program that should create a 10 element array of random integers (0 to 9). The program should total all of the numbers in the odd positions of the array and compare them with the total of the numbers in the even positions of the array and indicate ...
I have a 2d matrix with dimension (3, n) called A, I want to calculate the normalization and cross product of two arrays (b,z) (see the code please) for each column (for the first column, then the second one and so on).
the function that I created to find the ...