Web Forms :: Results Based On Dropdown Selection Of Month And Year
Jan 13, 2014
I am trying to display results based on both dropdown list selection.If a user selects Jan from 1st ddl and 2013 from 2ns ddl then results of Jan 2013 will be displayed to the user,everything works fine,I wanted to confirm the query that I have used is correct or not.
Store Procedure
Create proc usp_monthwisedata
@month int,
@year int
[Code].....
My concerns are:
1.Is the way of writing the Sp is correct to achieve the result.
2.Is it correct to set the onselectedindexchanged of both the ddls to 1 method i.e onselectedindexchanged="DropDownList1_SelectedIndexChanged"
3.Over all Performance wise is it correct.
View 1 Replies
Similar Messages:
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
Aug 2, 2010
Is there any way that we can make year and Month as DropDown in Web Calender.
View 8 Replies
May 19, 2010
I have asp.net calender control on my form and I have dropdown for month and year. and one button When I select month and year from dropdown and then when i click Button then I want to be able to go the specified month and year on my calender?
View 5 Replies
Mar 24, 2011
Is it possible to add dropdown for selecting month and year within ajax calender.
View 5 Replies
Aug 3, 2010
Is there a way to show year and month drop down on the calendar extender like the jquery ui calendar, If so could you kindly post it for me. If not would you be willing to show me how to do the jquery ui calender with Start Theme.
View 3 Replies
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
Jan 20, 2011
I am using a drop down lists for selecting the month and year in .aspx page. I have to get last date of the selected month of particular selected year in .aspx.cs page. (some months have 30 days and some have 31 days)
View 2 Replies
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
Sep 16, 2010
I am a complete newcomer to ASP.NET. However in the few weeks I have been playing with it I have got pretty far and have mastered things like stored procedures, gridviews, formviews and templates.I have a dropdown box which is populated from SQLDataSource1
I have a second dropdown box which is populated from SQLDataSource2, but i need the query feeding this to be dependent on what was selected in the first dropdown box. I assumed it would simply be a case of modifying the select statement on SQLDataSource2 using the SelectedIndexChanged event on the first DropDownList to update the second SQL source, but I cannot work out for the life of me how to do it. Pretty much all of the code I have is ASP.
can i do this purely in ASP rather than using VB behind the scenes or do I need to use VB? I am pretty comfortable with vb.net but one of the other issues I have is referencing an ASP object from VB... so for instance if I had a text box in ASP, how can I read or change the properties of this object from VB?
FYI I am using Visual Studio 2010 and SQL/Server
View 3 Replies
Oct 26, 2010
I have the following line on my aspx page..
[Code]....
My issue is, that i only need this to display when my datalist is displayed and has records.. every time else, it needs to be hidden ( Visible = false ) on page_load i have it set to
btnAddVideo.Visible = false;
btnAddVidCart.Visible = false;
Should i only be check then within my dropdown event? By default the page is displaying my datalist, so it should be hidden.. then you have a dropdown to make a selection, if you change it, then it should show ONLY if there are records to be displayed.
View 12 Replies
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
Jan 9, 2011
I am new to MVC, I have a form in which selection of one dropdown should reload another dropdown. On selection of the dropdown, I use a jquery post to get the data and my viewstate is reloaded with new data, but I am not sure how to set the newly loaded viewdata to load the dropdown again.
View 5 Replies
Jan 4, 2011
I have drop down selection box as follow...
1 - Car
2 - Plane
3 - Train.
Now, based on user selection say, 'Car', I want to display Help text associated with selection on page. Help text description - 1000 characters. Now, how do I fetch Help Text Description from? should I store in Session scope or Application Scope or fetch from Database based on drop down selection.
View 2 Replies
Sep 13, 2012
i have an asp.net application, i want to incorporate init the functionality of having the user select from a dropdown list a name, select multiple files (images), upload those images to a physical path on a server, save the image paths to a database on the said server.
If the user fails to select a name from the dropdown list then the user would receive an alert message stating that a name must be selected.
In addition once the files have been successfully saved to the server's physical location, then and only then should the path be uploaded to a table in the database.
View 1 Replies
Feb 21, 2010
I'm having trouble figuring out how to display a gridview based on the selection of a drop down list. I manually entered the drop down list items, but in the configure/choose data source I don't understand how you make a relationship between each list item and the corresponding database table you want to show.
View 7 Replies
Jan 3, 2011
i want to see the sales in the grid view based on the month selected from drop down list. Ex: when I select June 2010 from the ddl box, the sales for that month are correctly displayed in the grid view. I go to page 4 to look at some sales there and then switch the month to August 2010 to see sales for that month instead. Here is the problem. When I switch the month, it show August 2010 sales, but stays in page 4 instead of going back/resetting back to page 1 of August 2010 sales.
How do I reset the grid view page back to the first page of August 2010 sales?
I am fairly new to ASP. If I have missed an imp. detail in this post, let me know and I will get that info. out there.
View 4 Replies
Feb 20, 2011
I am using the following code to bind BusinessID as the DataValueField of the ddlIndustry dropdown. What I want to do is save the selected ID to a different table (Company). I am doing this with ddlIndustry.SelectedValue. For some reason, the first value is always saved (1), and not the selected value.
[code]....
View 1 Replies
Dec 24, 2010
I want to do a drop down for the year and month for a calendar object. How would I go about that:
[Code]....
Using: VB.net code; Visual web developer 2008; Asp.net; SQL server 2008 db
View 11 Replies
Nov 29, 2010
I have a standard calendar control and is now showing Nov 2010 calendar on page.
I want it return to label1.text as Nov-2010. Then I want when users click forward arrow and turn Calendar to Dec 2010, I want Dec-2010 be displayed in label1.text. ie not when user click a particular date but when user click Calendar to a particular month the Calendar is showing.
What is the code for that ?
View 1 Replies
May 7, 2015
I have 3 drop down lists for days,months and years,also i have a textbox to show the selected values from the 3 drop down lists when i select a month it shows in textbox and if i select another month it shows in textbox beside the first selected month.i want not to repeat the values in textbox.
the code:
protected void ddl_day_from_SelectedIndexChanged(object sender, EventArgs e)
{
txt_exhib_dateFrom_add.Text ="";
day_from = ddl_day_from.SelectedItem.Value;
txt_exhib_dateFrom_add.Text = day_from +"/";
}
[Code] ......
View 1 Replies
Jun 20, 2013
I have 3 TextBox in my page
1-TxtYear
2-TxtMonth
3-TxtDay
I want when Run page in TxtYear show current Year in TxtMonth Show Current Month and in txtDay show current Day
How I can do it?
View 1 Replies
May 7, 2015
i have complete date in a textbox i want to make the selected value in drop down list_days equal the day part of textbox,the selected value in drop down list_months equal the month part of textbox & the selected value in drop down list_years equal the year part of textbox to make the user update it if he want i tried to find the answer but i coudn't.
View 1 Replies
May 20, 2013
I use below code to showing date in Persian in my site
DateTime miladi = DateTime.Now;
System.Globalization.PersianCalendar shamsi = new System.Globalization.PersianCalendar();
DateTime shamsidate = new DateTime(shamsi.GetYear(miladi), shamsi.GetMonth(miladi), shamsi.GetDayOfMonth(miladi));
Lbldate.Text = (shamsidate.ToString("yyyy/MM/dd", System.Globalization.CultureInfo.InvariantCulture));
But below error happen
Server Error in '/behtop website' Application.
Year, Month, and Day parameters describe an un-representable DateTime.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.ArgumentOutOfRangeException: Year, Month, and Day parameters describe an un-representable DateTime.
Source Error:
Line 43: DateTime miladi = DateTime.Now;
Line 44: System.Globalization.PersianCalendar shamsi = new System.Globalization.PersianCalendar();
Line 45: DateTime shamsidate = new DateTime(shamsi.GetYear(miladi), shamsi.GetMonth(miladi), shamsi.GetDayOfMonth(miladi)); Line 46:
Line 47:
it worked correctly before but suddenly it make an error Why?
View 1 Replies
Mar 13, 2012
ReportViewer1.LocalReport.ReportPath = Server.MapPath("reports/DETAILS.rdlc");
ReportDataSource rdS = new ReportDataSource("PERSONAL",
GetData()); ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rdS);
ReportParameter rp = new ReportParameter("Year", ListYear.SelectedValue);
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp });
I have a listbox with year and another with month
I need that the report when generated by default shld be of current month & year
when the users selects the month or and year from the listbox i shld get the reposrt accordingly
I get error when passing parameters
I tried using even server report instead of local
When using local i get report path not set ....
View 1 Replies
