I have a column TimePeriod with values in mmm-yyyy format. ex. Jan-2010, Apr-2010,Nov-2010, Dec-2010, Jan-2011
How can I wirte query so result will be in order by Jan-2010, Feb-2010,..... Jan-2011.
I tried to cast, convert but i couldnt figured it out. I did googling... can't find solution.
I have a form on my website which inserts information into a table stored in sql server 2008... when I try to submit the form and I have entered a date like "08/10/2010" it works perfecting... but when trying to enter "24/10/2010" it doesn't work as the default format in SQL server is "mm/dd/yyyy" - so throws up an error saying:
The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value. The statement has been terminated. Also when I enter the date "08/10/2010" then submit the form, when retreiving that date on another page it displays as "10/08/2010"?
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 have a repeater using paging (see code below) I want to be able to offer a button that sorts the results by price and one for alphabetical order. I'm not sure how to achieve this with my current system. Would it just be a case of altering the sql select statement on click?
Private Sub BindRepeater()
Dim dv As DataView
dv = CType(SqlDataSource3.Select(DataSourceSelectArguments.Empty), DataView)
PagedResults.DataSource = dv
PagedResults.AllowPaging = True
PagedResults.PageSize = 9
PagedResults.CurrentPageIndex = CurrentPage
lnkBtnNext1.Visible = Not PagedResults.IsLastPage
lnkBtnPrevious1.Visible = Not PagedResults.IsFirstPage
Repeater1.DataSource = PagedResults
Repeater1.DataBind()
doPaging()
End Sub
[Code...]
i m using asp.net 2005 with access 2003. i need a code using vb.
how can i sort the record in descending order?
explain what the Dynamic Data team was thinking when they designed grid sorting in Dynamic Data scaffolded tables? Sorting defaults to using all columns, in the order the appear in the model, often arbitrary very counter-productive.We've just had a run in with the 'out-of-the-box' sorting, and solved it with a simple SortExpression attribute on MetaTables. Another, even simpler solution would have been for them to avoid any sorting, allowing the DB to provide a default order based on clustered index.
View 1 RepliesI have a photo album gallery within my website and would like to allow users to sort the order of their photos within an album. After looking at very different ways I came across this example http:[URL]Admin=true which is exactly what I need.
The photo are stored in the uploads directory and details in the database. The images are displayed using the ListView as shown below:
<asp:ListView ID="ListView1" runat="server" DataSourceID="SqlDataSource1" GroupItemCount="15">
<LayoutTemplate>
<table id="groupPlaceholderContainer" runat="server" border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse; width: 100%;">
<tr id="groupPlaceholder" runat="server">
</tr>
</table>
</LayoutTemplate>
<GroupTemplate>
<tr id="itemPlaceholderContainer" runat="server">
[Code]....
Here's my gridview when it comes it it's sorts on Age. Sorting is available for all columns/headers. How do I make the sort order to change on the ddsrpt sort to desc order when it's clicked?
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource7" EnableModelValidation="True" Width="789px"
CaptionAlign="Top" Height="126px" BackColor="White" BorderColor="#DCBE68"
BorderStyle="Solid" BorderWidth="1px" CellPadding="4"
HorizontalAlign="Center" CellSpacing="2" Font-Names="Arial"
AllowSorting="True" EmptyDataText="No Records" DataKeyNames="FO,CLMSSN">
[Code] ....
I got this error message - Gridviewsortdirection is not declared
is it possible to change the default date values accepted by sql server to dd,mm,yyyy instead of the default mm,dd,yyyy?
View 3 RepliesI've a date picker in a .NET page. I've seen that sometimes (on the same PC) I show date in UK format (mm/dd/yyyy) and sometimes in (dd/mm/yyyy)
.... I want only IT format (dd/mm/yyyy) ... why sometimes I show UK format?
Is it possible to set the format and don't have this problem?
I have a datepicker which shows date in format dd/MM/yyyy(i know i coould change there itself but by client want it that way) and in database its in format MM/dd/yyyy so i do want to convert in that way.
e.g. in text box 23/09/2010 and in c sharp its convert to mm/dd/yyyy(txtbo1.text)
how can i convert a textbox that contains date in format dd/MM/yyyy to yyyy/MM/dd?
View 2 RepliesI want to convert datetime from dd/mm/yyyy to mm/dd/yyyy.
my date is coming from URL as a parameter and format is 10/11/2010 04:55:15 PM.
I need to change this to 11/10/2010 04:55:15 PM.
i want to convert date from dd-MM-yyyy to yyyy-MM-dd in vb.net.
[Code]....
but it is giving me in format yyyy-dd-MM
I have a photo album gallery within my website and would like to allow users to sort the order of their photos within an album. After looking at very different ways I came across this example
http://www.west-wind.com/rick/photoalbum/demoMaui2006/Default.aspx?Admin=true which is exactly what I need.
The photo are stored in the uploads directory and details in the database. The images are displayed using the ListView as shown below:
[Code]....
I would like to rearrange the order of the photos; change the captions and/or delete the photos just like as in the example.
So could someone please provide the steps that I need to follow in order to achieve the following:
Firstly to display the photos from the Photo table in the database (can use the above listView) Rearrange the order; change caption and/or delete the photo(s) Final to update the changes in the Photo table
I am new to programming, especially jQuery so could you kindly provide/explain the steps that I need to follow.
i need to save date format DD/MM/YYYY tells me what format should i use when creating mt table (datatype)
View 7 Repliesi have added to my web.config page this instruction:
<globalization culture="en-GB"></globalization>
all the dates in my web page are formated as dd/mm/yyyy but my database is still under mm/dd/yyyy is there a way to also change the format of sqlexpress to dd/mm/yyyy ?
I am selecting the date field in the 'dd-mm-yyyy' format by using SQL Codes(103,105...).While inserting I want the userto insert the date in same format(dd-mm-yyyy) but it will not happening as in SQL Server we need to insert the date in'mm-dd-yyyy' format.Pls send me insertion query in sql to achieve this.Pls respond me ASAP.
View 4 RepliesWhen the user enter the data in the text field, they are entering as 12/1/2010 4:19:49 PM.But in database, the date is in this format 2010-12-01 16:19:49.367.Here I have to change date format and Convert 12 hr format to 24 hr format.
View 15 RepliesI have 5 hard corded texboxes in a page in a sequence with sequence Number . Now i want to add re-order /re-arraning functionaly .. but i can't use ajax reorder list because i have 5 hard corded texbox. how can i maintain the order in Insert/Update cases. And also suggest me control that i can use, another than ajax re-order list. coz i not using any list items i have hard corded items on the page.
View 1 RepliesThe AjaxToolkit has a ReorderList. I'm searching for a jQuery solution that does the same and found this page. I would like to change the order of divs (vertically) and upload the new order to the database (ajax).
View 2 RepliesI have two table Order and Order Detail.
What i need is i need to bind last 10 Order in Gridview/details view with paging, and the same order detail also fetch from database and shown in another gridview.. if user click any oderNo in first Gridview/DetailView then i need to show Respective order detail in anther gridview..
without postback coz we already fetch 10 order with orderdetails from the database..and if user click next 10 orderNo using paging then again we need to load 10 orderNo with respective orderdeatils from database like this going on....as well as let me know how to take print of particular oder and order detail....?
Moderators Note: THIS ISSUE IS BIG FOR ME AND EVEN IF POSSIBLE, GET THE REPLY FROM THE DESIGNER OF GRIDVIEW. I have been looking for him for long. I am really fed up with reviewing a good lot of web pages on how we can possibly customize the gridview to enable sorting and paging. So many sites have listed out a lot of information and so many guidances. But the problem is that one works out fine and the other is a burden. I really feel bad about being given the job of customizing this kind of a gridview which has no user friendly approach to it. Also, this control is rendered without the pager links inside the <tfoot> tag. I have tried the Pear Pager in php. It is that good and easy to use and compared to that, the gridview in asp.net is the worst ever control i have ever tried so far.
1. i can use the images to indicate the sorting direction
2. I can have the custom pager like
[code]
<<Previous 1 2 3 .. 7 Next >>.
[/code]
When i click the next when i am viewing the page at 3 , the pager links should change as
[code]
<<Previous 2 3 4 .. 7 Next >>
[/code]
Kindly look into this type of requirement and firstly tell me whether this is possible with the gridview control. I would like this request even to be escalated to the designers of the gridview control also, so that Microsoft comes out with a reply THAT WORKS and not the kind of stuff like surfing through a lot of links and pages and finally wasting a lot of days precious time and still breaking the head with this useless control. I have spent a lot of time in searching for a perfect way. Not writing a code that is non-standard. I am really serious b'cos I have spent weeks in customizing this control. If I dont get a solid reply atleast now, I am going to generate all the output by HTML content by custom coding.
From my testing, it appears that the order of parameters for the UpdateParameters must match both the order of the bound fields on the form (asp:Formview), and the order of the parameters in the UpdateCommand. Is that correct? If so, why do the parameters have names if all that matters is the order? I tried both asp:ControlParameter and asp:Parameter. Maybe the more relevant question is why aren't the names used instead of the order, particularly for the form order?
So, given I display the Identity field (CID), and need that for the update, I cannot get the update to work without including it in the UpdateCommand. Of course, since it is an autonumber field in Access, I cannot actually set it. So, I had to add another field to the db (lngUpdateCID) that I could set. That can't be how it has to be done, but I could not figure out another way to do this.
The relevant code is below:
[Code]....
I have this statement:
[Code]....
The problem is, it is not ordered correctly. How can I order it correctly with earliest datetime on top?
