[naak2803]

löst!
lösta på detta sättet, vet dock inte om det är den bästa! men det funkar... =)

foreach (DataRow r in ds.Tables[0].Rows)
                {
                    DataRow row = table_b.NewRow(); 
                    
                    row[col1_b] = r["name"].ToString();
                    row[col2_b] = Helper.distance(double.Parse(sLat.Replace(".", ",")), double.Parse(sLng.Replace(".", ",")), double.Parse(r["lat"].ToString().Replace(".", ",")), double.Parse(r["lng"].ToString().Replace(".", ",")), 'K');

                    table_b.Rows.Add(row);
                }

                table_b.DefaultView.Sort = "km ASC";

                DataTable cloneDataTable = table_b.Clone();

                for (int i = 0; i < 1; i++)
                    cloneDataTable.ImportRow(table_b.Rows[i]);

                GridView2.DataSource = cloneDataTable;
                GridView2.DataBind();

[digiArt]

Google är din vän: http://stackoverflow.com/questions/1...get-the-top-10

var rows = MyDataSet.Tables[0].Rows
   .Cast<DataRow>()
   .OrderByDescending(r => r["columnName"]) 
   .Take(10);