DataView : Upper the strings and distinct them?

Question

I have this code :

<asp:DropDownList AutoPostBack=False id="nation" runat="server" DataTextField="Title" DataValueField="Desc"></asp:DropDownList>

DataView nation = new DataView(new MyObjects().RsTable);
nation.Sort = "Title DESC";
DropNazioni.DataSource = nation;
DropNazioni.DataBind();

What I'd like to do is :

Put only distinct values in the DropDownList (so if I have 2 values "Italy", insert only one time Italy);
Upper the strings in the DropDownList (so if I have Italy, print ITALY);

Tried nation.Distinct() or nation.ToUpperString() but seems that these methods don't exists.

I'm on (unfortunatly) an old project, with .NET 2.0, so no LINQ.

LINQ on the .NET 2.0 Runtime - Take look at - http://stackoverflow.com/questions/2138/linq-on-the-net-2-0-runtime — KV Prajapati, Feb 01 '12 at 11:53

score 1 · Answer 1 · answered Feb 01 '12 at 08:44

1

Try GroupBy.

var result = MyObjects().RsTable
                        .AsEnumerable()
                        .GroupBy(p => p.Field<string>("Nation"))
                        .Select(p=>p.Key);

Or

var result = MyObjects().RsTable
                        .AsEnumerable()
                        .GroupBy(p => p.Field<string>("Nation").ToUpper())
                        .Select(p=>p.Key);

answered Feb 01 '12 at 08:44

KV Prajapati

93,659
19
148
186

DataTabel doesnt contain a definition of AsEnumerable() (I'm on .NET 3.5) – markzzz Feb 01 '12 at 08:59
@markzzz - It is there - http://msdn.microsoft.com/en-us/library/system.data.datatableextensions.asenumerable(v=vs.90).aspx – KV Prajapati Feb 01 '12 at 09:02
Damn! Sorry! I'm on an old project, .NET 2 :( That's why I can't use also linq... – markzzz Feb 01 '12 at 09:58

markzzz · Accepted Answer · 2012-02-01T10:26:24.510

0

Found a solution :

DropNazioni.DataSource = nation.ToTable(true,new string[] { "Title", "Desc" });

and CSS on DropDownList :

style="text-transform:uppercase;"

edited Feb 01 '12 at 10:26

answered Feb 01 '12 at 10:15

markzzz

47,390
120
299
507

DataView : Upper the strings and distinct them?

2 Answers2