Hello I'm using M.Access
I want to get date from database to my datetimepicker, but I got problem
please help, here is my code.
Dim sStatement As String sStatement = "SELECT Transactions.RentDate " & _ "FROM Transactions INNER JOIN TransactionsDetails ON Transactions.[TransactionID] = TransactionsDetails.[TransactionID]" & _ "Where Transactions.MemberID = " & TextBox20.Text & " AND TransactionsDetails.BookID = " & TextBox21.Text & "" Try Dim sCommand As OleDbCommand = New OleDbCommand(sStatement, sConnection) sConnection.Open() Dim sReader As OleDbDataReader = sCommand.ExecuteReader() DateTimePicker3.Value = Format(sReader(0), "dd/MM/yyyy") sConnection.Close() Catch sException As System.Exception MsgBox(sException.Message, MsgBoxStyle.OkOnly Or MsgBoxStyle.Critical) End Try
it always appears
No data exists for the row/column.
But I have many data...
and the second time i click the button
The connection was not closed. The connection's current state is open.
it appears that msg