C# - Selecting Data From SQL Server Table According To Month?

Mar 31, 2010

I have to come up with a way to get data from a SQL server table given it's month

There's a smalldatetime type field called "date" in the "events" table and a field from it looks like this:

29/01/2003 17:00:00

It should be one among those that appear in the gridview when I select jan/03 in a given DropDownList control in ASP.NET.

What would be the best way to do this? Assuming I only want to go as long as 10 years to the past, wouldn't making a dictionary be a good way?

How do I change it so the top month is always the current, and each month another options appeaars in the dropdown ?

It should be a common issue, so that shall not be a trick, but I want a good and clean way of doing this, and (since I'm new to asp.net) I myself would come up with something messy after a long time trying.

So what I want is:

1) Select

2) Best way of populating DropDownList (with the current month always at the top)

3) Best way to bind the DropDownList user-friendly way of writing months to the select query-friendly way of writing datetimes

Info: ASP.NET, (C# or VB.NET), SQL Server 2005

View 4 Replies


Similar Messages:

Selecting One Day / Week / Month From Sql Server Timedate?

Mar 29, 2011

I have data saved in a sql server database which i am using to draw a graph with in asp.net (c#) one field is an INT and the other is a datetime At the moment the graph is only drawing for all the data in the table i was wondering if there is any way to add into the sql string a statement that says for only today or this week or this month.

this is my sql string at the moment:

SelectCommand="SELECT [Time], [Temp] FROM [test2] ORDER BY [Time]"<br>

the format that the datetime is in is "2011-03-29 00:46:06.377"

View 5 Replies

SQL Server :: How To Get The Data In A Table Based On Month And Year

Jan 8, 2011

I have a requirement that I have to retrieve data base on month and year.I am using the below query

<pre lang="sql">SELECT SUM(areasft),DATEPART(year, sdate),DATEPART(month, sdate) FROM storedata
GROUP BY DATEPART(year, sdate) ,DATEPART(month, sdate)
ORDER BY DATEPART(year, sDate) ,DATEPART(month, sDate)</pre>

The above query is retrieve data like below.

SUM YEAR MONTH
51013 2000
1
30970 2007
1
NULL 2007
3
900 2007
6
807 2007
8
NULL 2007
9
1756 2007
10
7535 2007
11
NULL 2008
1
1193 2008
2
4230 2008
3
350 2008
4
2200 2008
5
4660 2008
6
6685 2008
8

But I need to display including all the months of the year along with year irrespective of SUM . My query only displays only some months in a year.

View 12 Replies

SQL Server :: Name From Table A ,minimum Rate1 And Rate2 Values For A Month In A Dropdownlist From Date Field From Table B?

Nov 19, 2010

I need to write a query to populate a gridview with minimum rates in ascending order for a month from three tables.For example i have three tables A,B,C as follows

TABLE A TABLE B
TABLE C
Id id id
Quote_no Quote_no Quote_ no
Name Rate1 Equip_name
Rate2 E_rate
Date R1_rate
R2_rate
Date

Now if the data is as follows

I need to get the Name from Table A ,minimum Rate1 and Rate2 values for a month in a dropdownlist from date field from Table B and the corresponding minimum rate(E_rate) for Equipment E1 and E2 only from Table C for the month in ascending order group by Name.

TABLE A

id
Quote_no
Name
1
101
XYZ

2
102
ABC
TABLE B
id
Quote_no
Rate1
Rate2
Date

1
101
105
200
12/11/2010

2
102
90
210
15/11/2010

TABLE C
id
Quote_no
Equip_name
E_rate
R1_rate
R2_Rate
Date

1
101
E1
60
0
0
12/11/2010

1
101
R1
0
110
0
12/11/2010

1
101
E2
80
0
0
12/11/2010

2
102
R2
0
0
300
15/11/2010

2
102
E2
100
0
0
15/11/2010

2
102
R1
0
60
0
15/11/2010

2
102
E1
230
0
0
15/11/2010

View 9 Replies

AJAX :: Add Dropdown For Selecting Month And Year

Mar 24, 2011

Is it possible to add dropdown for selecting month and year within ajax calender.

View 5 Replies

SQL Server :: Selecting A Percent Of A Table And Similar Records?

Oct 19, 2010

I have a piece of sql code that selects the top 10% of a table. See below a sample of the database table

And this is my code

[Code]....

So what this code does is add up all the points in the points table, (also works out what percentage of the points each user has) and then displays the top 10%, which in this case will give me "John" and "Dave"

So what I need the sql to do is check if any other records in that table have the same number of points ast the last selected record, and to select it to.

View 3 Replies

Display Dates In Datagrid On Selecting Month And Year From Dropdown

Sep 13, 2010

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

View 2 Replies

ADO.NET :: Display Data By Selecting A Linker Table (SQL)?

Feb 8, 2011

I have three tables namely tblPerson, tblAction and tblLog.

tblPerson and tblAction has many to many relationship, so a linker table which is tblLog is necessary. tblLog contains three fields, which is logID, PersonID (tblPerson) and ActionID (tblAction). Now, I need to display the data from the GUI. How could I display the records from tblLog wherein instead of the ID from tblPerson and tblAction, the other fields would show. I know that's the purpose of a linker table, but how to use it?

View 2 Replies

DataSource Controls :: Selecting All Data From A Table Based On Some Given Conditions?

Jul 8, 2010

I am having a staff table which contain staff information on it. To search staff information from the table, I want to prefer filter style. For example in the select query I want to display staff information according to three criterias. Select staff information from all sections, Select staff information from a given section, select staff information by a given Name. All these selects must be performed in a single select statement. Suppose,

SELECT * FROM StaffDetailsTbl
WHERE SectionID = CASE WHEN @SectionFilter IS NULL THEN [SELECT ALL]
ELSE SectionID = @SectionFilter
and Name = CASE WHEN @NameFilter IS NULL THEN [SELECT ALL]
ELSE Name Like '%@NameFilter%'

Where Declared variables are parameterized stored procedure values retrieved from the user.

View 2 Replies

Forms Data Controls :: Selecting A Row In Gridview And Add That Particular Row Into A Database Table?

Aug 2, 2010

I want to select a row in gridview and add the data of the row into a DataBase Table.

I have 2 tables

Table A and Table B.

I am displaying Table A data using gridview.When the user clicks the select command button in the gridview then i need to add that row data into Table B.

View 6 Replies

Group The Table According To The Month In The Table?

Mar 27, 2011

I need to group the table according to the Month in the table.

The query goes this way:

var query =
from a in db.Dates
from b in db.Facts
where a.Count_Key == b.Date_key
select new
{
a.Month,
b.Fact_key
};

From this query I try to group by Month

query = query.GroupBy(x => x.Month);
Grid1.DataSource = query;
Grid1.DataBind();

Then I get the following error which says:

Cannot implicitly convert IGrouping int ? into IQueryable

View 3 Replies

SQL Server :: Get Data In Result Set Order By Month Name?

Jan 11, 2011

Below the is working fine but I am not getting in month order.

SELECT SUM(TaxableAmt) [NSV], (UPPER(CONVERT(VARCHAR,LEFT(DATENAME(MM,invoicedate),3)))+'/'+ CONVERT(VARCHAR,RIGHT(DATENAME(YYYY,invoicedate),2))) AS MONTHYEAR
FROM SALESDATA where (invoicedate >='4-1-2009' and invoicedate <='4-30-2010')
GROUP BY (UPPER(CONVERT(VARCHAR,LEFT(DATENAME(MM,invoicedate),3)))+'/'+

[Code]....

View 5 Replies

SQL Server :: Retrieve Data Before One Week Or Month?

Dec 4, 2010

need sql statements to retrive the records which addbefore one week ,two week,one month and two month depend on the date column in databaase i want to retrive the records which add before week and so onany one can help me how i doing this

View 7 Replies

SQL Server :: How To Group Weekly Data For A Month Days

Sep 16, 2010

how to group weekly data for a month days

View 6 Replies

SQL Server :: Selecting Columns Based On Data?

Jan 17, 2011

I'll admit that I'm not the best at SQL, but what I have is a database that has different podcasts in it. We have 3 locations, so each podcast contains three columns, one for each location. In each column is the date it was shown at each location, or null if it wasn't shown there. Most of the time, I'm selecting podcasts for a specific location, which is easy enough:

[Code]....

But what if I want to select them all? I want "Date" to always be the Hudson location, but if Hudson is null, I want it to be the date of the location it was shown at: AuroraDate or StowDate.

View 4 Replies

C# - Selecting Multiple Table Values And Binding The Data Into Multiple Grids?

Oct 5, 2010

i have multiple tables .

I have created one stored procedure where I am selecting the table values.

like

[code]....

I am using LINQ to retrieve the Data. So Using Linq I am calling the stored procedure.

So I ll get the table values in the C# Code the table values.

so in my UI i have 4 gridviews.

I want split the output values into four source and bind it to the grid.

View 1 Replies

SQL Server :: How To Get Month And Year In Single Column And Grouping The Data For All The Years And Months

Jan 10, 2011

For the below query (sdate is column name and table name is storedata)

View 2 Replies

SQL Server :: Selecting Data From Multiple Tables Whilst Using A Union Statement?

Nov 29, 2010

I basically have a series of tables from one database that have an identical structure thus making retrieval of all records fairly easy (I just use a UNION ALL statement). However I need a list of values from another table within a different database that contains information regarding the group of the data.

I so far have the following:

SELECT Table1.* FROM Table1 UNION ALL SELECT Table2.* FROM Table2 UNION ALL SELECT Table3.* FROM Table3 UNION SELECT Database.dbo.SRFILE.SR_GROUP FROM Database.dbo.SRFILE INNER JOIN Database.dbo.SRFILE.SRONUMBER = Table1.Incidentx

I keep receiving a unable to parse message however all I need to retreive is the SR_GROUP value but just don't know the correct syntax. Is it actually possible to do this as the structure of SRFILE is not the same as Table1/2/3.

View 3 Replies

ADO.NET :: Selecting Table From A Dropdown Menu?

Feb 5, 2011

I was wondering if ther is a Way to select a table name from a DropDown Menu and then dispaly the data in say a GridView?

For Example;

In PHP you can post a Value to a Veriable and Put that Veriable into a SQL Statement.

"SELECT * FROM '.$VAR.'" would be the statment used to return the data.

I was wondering if there was a similar way to dot his. Currently I have a different page for each table with other dropdown menus to select other options, or would continuing to do it like i have just stated be better?

View 5 Replies

MVC :: Selecting And Inserting Dropdownlist Value In To Table?

Mar 31, 2010

I have a table MemberProfile with columns FirstName, LastName, Gender and ComplexionCode.here iam displaying complexioncode as a dropdownlist with values fair, very fair, brown and when user selects a value I want to insert that in to table

I have creted a class( LookUpCodes) and written following code

public static IEnumerable<ComplexionCode> ComplexionCodes
{
get

[code]...

now when I click the button FirstName, LastName Gender are inserting in to the table. only Dropdownlist( ComplexionCode ) value is not inserting.

View 1 Replies

Data Controls :: Get Data In GridView Of Month And Year Less Than Current Month / Year

Jan 30, 2014

I am having one table in whic there is monthyear column and amount column..i want the data in gridview of monthyear less than current monthyear ...

my table entry is like this

Monthyear                Amount

December 2013        10000
January 2014            20000
February 2014          60000
March 2013               40000

View 1 Replies

Crystal Reports :: Calculate Current Date(month) Minutes One Month?

Feb 25, 2011

How to calculate current date(month) minus one month in crystal report?

View 1 Replies

Web Forms :: Display Number Of Days In A Month When Month Is Selected From DropDownList

Dec 11, 2012

How to display the number of days in textbox when the month is selected in the dropdown list,,,for example if i select the month december ,after selection i want to display 31days in the textbox how ?

View 1 Replies

Web Forms :: Get Start And End Date In A Month Based On Month And Year

Jun 7, 2012

lblperiod.Text = " period " + "01/" + drpsmon.SelectedValue + "/" + drpsyr.SelectedItem.Text + "---" + System.DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) + "/" + drpsmon.SelectedValue + "/" + drpsyr.SelectedValue;

i want the daate ie the 1st to  the end of month when page is loaded i get the current months 01/06/2012 - 30/06/2012  but i want it on dropdown changed

i mean whever the user selcts in dropdown for month & year i want the period for the same

View 1 Replies

Forms Data Controls :: Access Exchange Server's Address Book, To Enable Selecting Aggregate Groupings By Manager

Apr 16, 2010

The end goal is to be able to reference our address book, and give the user the ability to select a Manager, which then in turn would return all the results for all the users under that manager. This information is stored in our Exchange servers address book. ie when you select on a person's name in Outlook, then Organization, you get their manager, so when you select the Manager on this site, I want it to return the results for all of his/her members.

I have a site that has a dropdown list of users who've entered data into a DB. This list is populated with a User's alias when they enter data.This DB of data (including Users' aliases) contains data from users in multiple groups, and I am trying to figure out how I can access our Outlook exchange.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved