Before Datetime

Question

I have a form with datetimepicker1 and datagridview .
In the database one table named purchace
purid
purno
purdate
itemid
purqty
putgtotal
balance
I want to select itemname ,sum(purqty),sum(balance) from purchace where purdate is less than the selected date from datetimepicker1 and this will displayed in datagridview. plz help?

Jiteendra Sampathirao · Answer

Hi,
What Suthish said is right.
For Sql stuff refer this: SQL
Gridview Control: Link
so many articles are available in this site regarding Gridview....

Suthish Nair · Answer

Shyja, Now you must start learning SQL instead of looking for complete solutions. You are asking lots of sql questions now days, i don't think even you tried to build the queries. We can answer your threads and gain 5 points, but that will not be helpful for your career and future. So instead of looking for answers, start learn SQL today. That's my suggestion only, rest is on u..

Sam Hobbs · Answer

There are many ways to do that and there are many articles in this web site that explain how. Have you looked there?