Display dates in datagrid on selecting month and year from dropdown

[Blacky]

Hi,

I have a application where in on selection of Month and year, the datagrid should be display, username and the dates, the username and number of leaves from the database.

UserName 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19..

Sam P P
Susi U

P - Planned Leave
U - Unplanned Leave

In database i have only Username, leave start and end date.
1.How to display the dates in column in datagrid based on month and year selection.
2.How to map the dates in the datagrid with the start and end date from sql server database

Please do the needful

Thanx in advance,

Blacky

[veenna]

On selection of date, query the db to return data , where date between selected date.

[Frinavale]

Please review the following article that outline how to use a database:
Database tutorial Part 1
Database tutorial Part 2

Also, all the information you need on GridViews and any other .NET controls can be found in the MSDN Library. This resource should get you pointed in the right direction....th ere are multiple articles on the GridView control there. I recommend bookmarking the MSDN Library and using it as your primary resource when developing in .NET.

-Frinny