We have a list of titles, some of which start with numbers (e.g. 5 Ways to Make Widgets). We would like to sort this as if it were "Five Ways..." without changing the title. We know that some movie places do this, but I can't find info online on how to do it.
View 4 Repliesi have a gridview populated by a Web Service search function. some of the columns in the grid are templatefields, because the values coming back from the search (in a datatable) are ids - i then use these ids to lookup the values when the rowdatabound event is triggered and populate a label or some such.
this means that my sorting function for these id/lookup columns sorts by the ids rather than the textual value that i have looked up and actually populated the grid with (although i do put the ids in the grids datakeys).
what i want to do is top be able to sort by the looked up textual value rather than the codes for these particular columns.what i was going to do to get around this was to when the datatable comes back from the search, adding more columns the textual values and doing all the looking up then, thus being able to sort directly from the manually added columns.
is there another way to do this? as that approach seems like a bit of a bodge. although i guess it does remove having to do the looking up in the rowdatabound event....
my sorting function works by sticking the datatable in the session and on each bind grabbing the sort column and binding the gridview to a DataView with the sort attribute set to the column - and the direction.
I need to find a regex that tests that an input string contains exactly 10 numeric characters, while still allowing other characters in the string.
I'll be stripping all of the non-numeric characters in post processing, but I need the regex for client-side validation.
For example, these should all match:
1234567890
12-456879x54
321225 -1234AAAA
xx1234567890
But these should not:
123456789 (not enough digits)
12345678901 (too many digits)
I need to extract numerical digits from a string using sql in a select statement
"Customer is eligible for Balance Billing with $10 credit on the next bill. Fixed monthly Balance Billing amount is $141.38. Offer is valid till the end of March 31, 2010."
I need ot extract 141.38 from teh above text.The length of the decimal can vary
i'm trying to sort a datatable using the typical select method*. The problem comes because the field is string defined but it's containing integer values.
With sql the problem will be solved just using something like:
select * from table order by to_number(field);
but of course it's not working properly with the method commented above (select method).
*http://msdn.microsoft.com/en-gb/library/b5c0xc84(VS.80).aspx
I have an item template field retrieving a date field from an Oracle 11g database that can be null. The date is converted to a string before binding to the gridview. When the column is sorted is is being sorted as a string. I have read in several places if you add a formatting string to the eval statement in the item template that the sort operation will then sort the string as a date. However, I cannot get it to work. I also tried a bound column, but the column is still being sorted as a string.Code from the aspx page:
<asp:TemplateField HeaderText="Comp Date">
<HeaderTemplate>
<asp:LinkButton ID="sortDatea" runat="server" CommandName="Sort"
[code]...
This should be a fairly simple one. I am creating a dataset which will contain a description field which I would like to sort by. The reason I want to sort the dataadapter and not in my SQL is that I am already ordering by the results that have a particular value. My SQL looks like this:
SELECT pif_desc, pif_fund, psf_end, (CASE WHEN SUM(pmi_units) IS Null THEN 0 ELSE SUM(pmi_units) END) As fundunits FROM tbl_mem INNER JOIN tbl_sfunds ON pm_scheme = psf_scheme INNER JOIN tbl_invfun ON tbl_fund = tbl_fund LEFT JOIN pe_minv ON pmi_fund = pif_fund AND pm_member = pmi_member WHERE pm_member = @pm_member GROUP BY pif_desc, pif_fund, psf_end ORDER BY fundunits DESC
My VB looks like this:
Dim cmd As New SqlCommand("getMembersFundsDCGENST", conn)
cmd.CommandType = CommandType.StoredProcedure
Dim p_pm_member As New SqlParameter("@pm_member", SqlDbType.Int)
p_pm_member.Value = pm_member
cmd.Parameters.Add(p_pm_member)
Dim p_period_closing_date As New SqlParameter("@closingdate", SqlDbType.DateTime)
p_period_closing_date.Value = period_closing_date
cmd.Parameters.Add(p_closing_date)
Dim da As New SqlDataAdapter(cmd)
da.Fill(ds)
I want to sort the datarows is ds.tables(0) by pif_desc but still have the rows with fundunits > 0 listed first.
my code will explain what the problem is in the WHAT DO I PUT HERE section how can get the list ordered by a-z?
View 3 RepliesI have a table:Category with some sort of categorie
[code]...
Well, the strange question is: how can i order the subcategories alphabetically?
If i'd have binded the children repeater to a linq it would be easy.
But in this case?
I am dynamically binding the treeview using DOM.
I m populating the tree by sayin treeview1.nodes.add(Treenode)
After this, i need to sort them alphabetically. I have followed this ref:[URL] but I was not able to understand how to do it only for parent nodes, since I don't have child nodes.
Moreover I m not able to get property sort().
How do I achieve this?
I'm wondering if Visual Studio is ever going to allow users to sort the available templates alphabetically.
When clicking on File | New File, I'm greeting with the New File dialog window, which has a seemingly arbitrarily ordered list of items to choose from. This isn't so bad, because there aren't that many, but it would still be nice to order them.
When right-clicking a project, and choosing Add | New Item, I get a Add New Item dialog box that has the same dementedly senseless order, and there are many more of them. Fifty-three on my system, in fact. Having no easy way to order these alphabetically is a serious pain, and I've seen complaints about it all over the Internet. Does anyone know of a way to get Visual Studio 2008 to order these templates alphabetically, and does anyone know if Visual Studio 2010 will finally include this feature?
I found a PowerShell script online that was supposed to accomplish this, but it appears to have been written for .NET 2.0, and I'm using .NET 3.5. I don't have the time to pick apart the PowerShell script and hope I get the modifications right.
How to sort the names in combobox alphabetically?
View 3 RepliesModerators 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.
I need to sort dropdownlist alphabetically.
This is the code I am using ,its working but it brings numbers first and then alphabets like 1,2,abc,bcc..
[code]....
I am having a problem .I want to display the book category and subcategories which is fetched from database .
I want to show record like
Example
--------
A
Autobiographies
- Advertising
- Artists
[Code]....
How to show record like this and which control I have to use for this.
LinkButton A
LinkButton B
A B C D E
-----------------------------------------
EmpID EmpName
1 Aakash
2 Ajit
I want to do something like this.
[URL]
i have all the categories in my dataset. now i want my repeater to display it in alphabatically categories.
How to I use DataFormatString to display last 4 digits (xxxxx1234)?
<asp:BoundField ReadOnly="True" DataField="SSN" >
<ItemStyle Wrap="False" />
</asp:BoundField>
I have a TextBox in a FormView that I want to make sure that the user enters exactly 9 digits. The FormView is inside an Update Panel so I want to be able to validate without a Postback. I cannot figure out which validation control can do that and how. I already have a FilteredTextBoxExtender that forces all digits.
View 3 Repliesmy code:
[Code]....
I have a stored encryption: "dkljas84u238jidasjidoia"When I get in this instance decryption "11111111111111111"show how the combobox "****************** 1111 "Something like: SELECT RIGHT ('11111111111111111 ', 4)
I have a textbox where the user must not be able to enter more than two digits after a decimal.How do I do this without using javascript?
View 3 RepliesI am using regular expressions for matching only digits, minimum 10 digits, maximum 14. I tried:
^[0-9]
I have a TextBox inside my .rdlc file contains decimal numbers. I want to separate its numbers in every 3 digits. How can I accomplish this?
View 1 RepliesI've build this function:
I like to convert 1234,222 to:
1.234,22
But what happends below is he converts it to 1.234, so verything after the , is gone. How can i change this function so it works correctly?
Also if the number is 1.234,248 the result should be 1.234,25 , so just 2 numbers after the ,
public static string AddDigits(string source, int digitaldigits)
{
System.Globalization.NumberFormatInfo format = new System.Globalization.NumberFormatInfo();
format.NumberGroupSeparator = ".";
format.NumberDecimalDigits = digitaldigits;
decimal i = decimal.Parse("1234,222");//decimal.Parse(source);
//int i = int.Parse(original);
string str = i.ToString("N0", format);
return str;
}
Is there a easy way to transform 1000000 in 1.000.000? A regex or string format in asp.net, c#
View 5 Replies