black zero
Well-known member
- Joined
- Jan 15, 2009
- Messages
- 53
- Programming Experience
- Beginner
Here's the scenario:
I would like to select transaction id based from its creation date. All transactions are displayed on form load event on a datagrid. The select function should be executed on 2 datetimepicker (the first should be the start date, the last should be the end date).
So there are three controls on a form, 2 datetimepicker and a datagrid. I managed to load all transactions into a datagrid, and managed to select/filter those transaction based on id, but not date.
Oh, the table is called 'transaction_details', it contains 'transaction_id', 'transaction_date', and few other columns. transaction_id is the primary key.
Any help is really appreciated.
I would like to select transaction id based from its creation date. All transactions are displayed on form load event on a datagrid. The select function should be executed on 2 datetimepicker (the first should be the start date, the last should be the end date).
So there are three controls on a form, 2 datetimepicker and a datagrid. I managed to load all transactions into a datagrid, and managed to select/filter those transaction based on id, but not date.
Oh, the table is called 'transaction_details', it contains 'transaction_id', 'transaction_date', and few other columns. transaction_id is the primary key.
Any help is really appreciated.