I just passed my view a list of products for the last 90 days sorted by date and need to display it in an efficient way that will group the products by date.Linq-To-Sql doesn't understand a lot of the date comparison functions,so I'm kinda lost as to what to do here.What I would like to do is contain each group of products with the same date inside of a div with a title like "Today", "Yesterday" or "Last 30 Days".
View 1 Repliesi have used a repeater in my website, and linked it to acccess data source, and thats the good bit...
i now have 26 items displalying on 1 page...
i was wondering if i could have help on how to limit the number of products displaying on my page.
my code:
[Code]....
I am developing a website that display products and the users will be able to rate these products. At the end of the month a winner product will be highlighted on the website home page. What I need to know is how to determine the winner product if I have the following rating scenario, The user will rate for the product by choosing a value from 1 to 5 where 1 mean bad and 5 excellent.
If 10 users voted for the product A and the average rating was 4 and 1 user voted for product B and the average rating were 5 that mean product B will be the winner. I feel this is not the correct method to determine the winner. one has better method that take in consideration the number of voted users to determine the winner?
this is my last thread
[URL]
this is my code
<li><a href="Furniture.aspx?h_name=electric">Electric</a></li>
in Furniture.aspx will show all product that have H_name=electric
i have another Item
<li><a href="Furniture.aspx?h_name=?">show all</a></li>
i want when user click in this item on jquery menu in Furniture.aspx will show all product in this item H_name is'nt important i want show all product with different H_name
I am generating report through report viewer.. I want show my record which date i select but it cant select data from date which are giving it taking system date to display data...
Example: I select 2013-11-15 it does not showing any data but when i change my system date to 15 it is showing data...
<body> <form id="form1" runat="server"> <table class="style1"> <tr> <td class="style4"> </td>
<td class="style3"> </td> <td align="right"> Date</td> <td> <asp:TextBox ID="TextBox1" runat="server">
</asp:TextBox> <asp:CalendarExtender ID="TextBox1_CalendarExtender" runat="server" Enabled="True" TargetControlID="TextBox1" format="yyyy-MM-dd"> </asp:CalendarExtender> </td> <td>
<asp:Button ID="Button1" runat="server" Text="Search" onclick="Button1_Click1" /></td>
[code]....
Here report is temporary table which save all the select data from purchase from.
I am using
[DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:dd-MMM-yy}")]
but the problem im having is its always displaying 01-Jan-01 if the date value is null.
I am also using jquery for the display as follows:
[URL]
I want to dipsly today`s date by default if the date value is null.
When I try the following code in a sub, it always returns a date of 12/31/1600.
why it's not giving me the correct date?
Dim x
As
New FileInfo("/MainMenu.aspx")
Master.Say(x.CreationTime.ToLongDateString)
I'm using the following code to display an arabic date:
Dim dtFormat As DateTimeFormatInfo = New CultureInfo("ar-sa", False).DateTimeFormat
dtFormat.Calendar = New HijriCalendar()
Dim hijriDate As String = Now.ToString("d MMMM yyyy", dtFormat)
Today this is displaying as 16 ربيع الثاني 1432. However, according to a user, the arabic text should be in the middle with the year 1432 at the end.
However, when you highlight the text, it highlights back to front.
i m using visual studio 2003 to modify my existing module.In my module ,i have two dropdownlists,first one contains year while other contains month.After selecting particular month and year,i need to display date in one column and day in next columnt within datagrid according to selected year and month.Furthermore, i need to display Saturday and last Sunday of month with different color.Can anyone help me out from this problem,i really got stuck at this problem.
View 1 RepliesI have an ASP.NET GridView in which i want to show dates from selected month and year. Month and year fields are DropDownList and bound to XML data source. Is there any easy to do that or i have to use Code behind to add dates using iteration.
View 1 RepliesI want to display a blank text box if the date in the table is null. Any ideas on this using MVC 2 RC? 1/1/0001 12:00:00 AM displaying for Null DateTime in Html.TextBoxFor(model => model.IssueDate)
View 11 RepliesI have the following page in my admin.aspx.vb page and the aspx page of this page displays the all the details in a grid view....
Everything is fine ... just need to display only the date instead of the entire date and time...
I tried using DateTime.Date.ToString("yyyy/MM/dd") but it does not go in the colde below...as it has "" in the bracket above... my friend created the page for me and i have very mittle programming skills ...
Protected
Sub DisplayTransactions()
Dim RepID
As
String =
Me.Page.Session("RepID")
[Code]....
How to set the current system date in ("dd/MM/yyyy") format under datetimepicker on the page_load method ..
View 1 RepliesI have several reports that I have published to a SQL 2008 report server with parameters that are dates (DateTime format). For these parameters, a calendar icon is displayed next to the textbox to allow users to select the date via mouse. Some of my reports are used by people overseas (England), where the date format is dd.mm.yy (instead of mm/dd/yyyy).
I went to the report properties, and changed the Language property from "un-US" to "en-GB". The affect of this is that all of the dates that are displayed on my report now show the date format of [dd.mm.yy] (which is good). However, the textbox where they specify the report parameter still shows the old mm/dd/yyyy format.
Can this be changed somehow? I have looked around, but could not find a setting that would apply to this. Or is this a client-side setting (in other words, when viewed overseas, it takes the "native" date format)?
I am using file upload option in asp.net web application,how to display filename, date and time of file creation,modification date of file that we browse.
View 4 RepliesI have a DataGrid which gets populated from a Dataset. One of the columns is of type DateTime. The stored proc returns the data correctly. I mean, It returns both the Date and Time. But, the datagrid is displaying only the date and not the time.
View 3 RepliesWorking with VB code - I have code which displays a figure between brackets. The figure displayed is a count of the amount of entries made to my textbox and outputs to my placeholder- I hope I make sense here...???Anyways, I'd like to output the correct data and time (at time of textbox entry) instead of the count.
[Code]....
[Code]....
Here my question is very simple. That what I want to do is to select a date using asp.net calender control and insert into textbox. Both the controls are in the InsertItemTemplate of the FormView.
1. Page1.aspx has a textbox and an image for calender.
2. Calendar.aspx is to select any date and with the help of session it should go back to its parent page in the text box and dispose itself.
Achievement:1. From Page1.aspx when i click Calender image, perfectly a new page Calendar.aspx opens.
2. On Calendar.aspx page, date selection is also OK.
3. Using Session, the date is perfectly transfering to next page.
Problem: 1. When I select date from Calendar.aspx it is not transfering back to Page1
in textbox.
2. Secondly when I select date from Calendar.aspx it is not disposing itself after date selection.
I want to pass date from one page to another page using querystring. I have used a gridview hyperlinkfield.
When user click hyperlink in gridview the data should display on other page.
I have tried this but due to date format (dd/MM/yyyy) that is showing in gridview the hyperlink is not showing. I think '/' is creating problem. In gridview I already tried by replacing / to -.
I got one web page which is developed by using Asp.net. and in that page I have got one tab control which developed by using Ajax control toolkit (tab container). In that tab container i have got three tab pannels. In the first tab pannel have got two drop down list boxes and one image control box. wat I was trying to do is that by using calendar extender control in ajax control toolkit i was trying to display a day in the first drop down list box and month and year in second drop down list box. when user click on image control during run time a small calender will pops up and then user will select the propective date according to there choice and when they have finish selecting the date from the calender a day will display on first drop down list box and month and year will display on second drop down list box.
I was keep trying to do that but i was failed. then i took one test box from the toolbox and i was got success in displaying the user selected date in the text box by using ajax calender extender. How to display that date instead of one textbox into two separate drop down list boxes from which a user can select manual date from drop down list as well and from the calendar as well also when the page loads, the two drop down list boxes must show current date ( by default)
I am having a DOB field in database of type Datetime.I am retrieving this into a gridview .I want to display only date into the gridview in 'DD-MM-YYYY' format and that to in sorting order. How can I do that. I know that by converting DOB to varchar and using SQL Date formats codes(103,105...) I can do that but I can't able to display in sorted order as it will check only the date part and sort the dates. It will not chk the month & year. And I also want the user to insert the date in 'DD-MM-YYYY' format and this to be stored in database. How can I do this? Pls respond me ASAP.
View 6 Repliesi used below code for date time picker validation but it's not working.
Actually I want a date time picker which date dd/mm/yyyy format date. With validation for start and end date. Also for manual entry it should take only no. and for date rest like / or, will be auto formatted.means user should not be able to enter it.
I m using c# .net 2008.
[code]....
I have been messing around with a Shopping Cart Tutorial i found on NetTuts+ I would be keen to find out how get the products from a Databse rather than use the product class they have made for the tutorial.
View 7 RepliesI am having problems in getting product data when using different levels of categories. My knowledge of SQL is also very limited.
Here is what i have so far
TABLES
Categories
CategoryID (PK) int
CategoryName nvchar(max) allow null
ParentID int allow null
Data for this table
1,Soaps,null
2,Original Range,1
3,Premium Range,1
4,Speciality Range,1
5,Seasonal Collection,4
6,Selection,4
Products
ProductID (PK) int
ProductName nvarchar(max)
ProductDescription nvarchar(max) allow null
ProductPrice money
CategoryID int
Data for this table
1,Prod1,some text,0.25,6
2,Prod2,some text,0.25,6
I have some linq to sql in the page load event that populates a list view,
[Code]....
Now when the category passed in from the query string is 6 then the products with a category of are shown correctly but category 6 is a child category of 4 and 4 is a child of 1 so when i pass in 4 as the category i should still be retrieving the data for products 1 and 2.
I can explain my problem pretty straightforeward. I am using Visual Web Developers reporting GUI but the question should remain the same. I have that consists of a month, year, employee, and Hours. Sample data would look like this:Month, Year, Employee, Hours
1, 2010, Jim, 20
2, 2010, Jim, 50
1, 2010, Jen, 95
3, 2010, Jen, 65