473,327 Members | 1,952 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Display dates in datagrid on selecting month and year from dropdown

40
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
Sep 13 '10 #1
2 1863
veenna
65
On selection of date, query the db to return data , where date between selected date.
Sep 13 '10 #2
Frinavale
9,735 Expert Mod 8TB
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....there 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
Sep 13 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

8
by: Zero.NULL | last post by:
Hi, We are using Month-year tables to keep the history of long transaction of our application. For example: We capture the details of a certain action in table...
3
by: Bob | last post by:
I wish to group data on a report by week, month and year. Crystal reports has this ability as a built in function. Is there a quick way to do this in Access97/2000 VBA reports ? Thank you in...
18
by: PC Datasheet | last post by:
An Access user saw my name in a newsgroup and sent me a request for help on a project. As part of the project, a list of the dates in a month was needed. For anyone needing a list of dates in a...
3
by: owz | last post by:
Working with ACCESS 2000 SQL, I’m getting very frustrated with it now so Any ideas would be well appreciated I want the sum of the sales of a Salesperson for a specific month i.e. the month...
1
by: sang | last post by:
Hi how to list the inserted dates by week,month and year. That is how to select the dates by past one week. similarly the month and year of the particular filed. Thanks in Advance Sang
5
by: soni2926 | last post by:
Hi, I have a web application, asp.net and c# done in 2.0, which is going to return rows from the db with dates or certain events. The db is going to have events dates for the entire year, but on...
0
by: =?Utf-8?B?bW9oYW5yYWpfaw==?= | last post by:
Hi, how can we select the day/month/year component in a DateTimePicker control, while navigating between fields. i.e, when i gotfocus to the control, either day/month/year component to be...
3
by: =?Utf-8?B?R3V5IENvaGVu?= | last post by:
Hello how do I get the day/month/year part of a date in vb.net? sample in vb6: day(13/10/2001) = 13 month(13/10/2001) = 10 year(13/10/2001) = 2001 Thanks Guy
1
by: cmuraz | last post by:
hi, hope the query is simple, but i donno how to do. i have some records in a table for the month may 2009 as no date --------------------------------------- 1 ...
7
by: kkshansid | last post by:
i want to display it in date/ month/ year format <td><?php echo date("d/m/y",($row)); ?></td> output 01/01/70 <td><?php echo $row; ?></td> output 1977-08-09
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.