hey guys
i need to sort the hashtable or sortedList by the Value, NOT the KEYs
does any one know how to do that?
first my idea was to do
1. select * from table order by value
2. retrieve the data into the Hashtable or sortedList
both of them changes the order of way i insert the data, does anyone know how to do it?? right now i'm trying to over write the compare method and this is my code below
<%@ Page Language="c#" Debug="true" %>
<%@ import Namespace="System.Collections" %>
<%@ import Namespace="System.Globalization" %>
<script runat="server">
private static IHashCodeProvider hashCodeProvider;
private static IComparer comparer;
private static IHashCodeProvider HashCodeProvider {
get {
if (hashCodeProvider == null) {
hashCodeProvider = new CaseInsensitiveHashCodeProvider(CultureInfo.InvariantCulture);
}
return hashCodeProvider;
}
}
private static IComparer Comparer {
get {
if (comparer == null) {
comparer = new SymbolEqualComparer();
}
return comparer;
}
}
private class SymbolEqualComparer: IComparer
{
int IComparer.Compare(object keyLeft, object keyRight)
{
return 1;
}
}
void Page_Load()
{
// Hashtable ht = new Hashtable(null, comparer);
SortedList ht = new SortedList(comparer);
ht.Add("a", "first");
ht.Add("c", "a c");
ht.Add("b", "zzz");
ht.Add("aaa", "an apple");
ht.Add("z", "z");
ht.Add("x", "x");
ht.Add("v", "v");
ht.Add("r", "r");
ArrayList keys = new ArrayList(ht.Keys);
ArrayList Values = new ArrayList(ht.Values);
for(int i = 0; i < keys.Count; i++)
{
Response.Write(keys[i].ToString() + "---->" + Values[i].ToString());
Response.Write("<br>");
}
Response.Write("<br><br><br>");
listSelect.DataSource = ht;
listSelect.DataValueField = "Key";
listSelect.DataTextField = "Value";
listSelect.DataBind();
}
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<asp:ListBox id="listSelect" runat="server"></asp:ListBox>
</form>
</body>
</html>