Click here to Skip to main content
15,891,431 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi, wondering if anyone could supply me with a query to enter a tableadapter query that will return the records on file for the current month.
My table headers and sql statement are as follows - SELECT ID, ThisDate, TimeStart, TimeFinish, TotalTime, StartTempo, FinishTempo, [BPM+/-], Notes FROM tblarp

I have entered a diplay_Data function that displays data in the datagrid (this works good) but I want to modify the data or create a dataset query to only show the reports only for the current month.
Posted
Updated 3-Jul-15 18:27pm
v3
Comments
Suvendu Shekhar Giri 3-Jul-15 23:18pm    
What do you mean by table adapter query?
Jaybo007 4-Jul-15 0:15am    
Sorry, should be dataset.
I am trying to add a query in my dataset to display the records for the current month. I think its a fill by method using a right click and add query. I'm new at this so please bare with me.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900