Linq + Group by Problem [modified]

[EBeylo]

Hi All,

var MyDataSet = (from devicesPermissions in userDevicePermissions
where devicesPermissions.Username == "MyName"
orderby devicesPermissions.IslandID, devicesPermissions.DeviceGroupsID,
devicesPermissions.DevicesID
group devicesPermissions by devicesPermissions.IslandsName).Distinct()

      foreach (var dataSet in MyDataSet)
         {
            Console.WriteLine(dataSet.Key);

            foreach (var devgro in dataSet)
            {
                Console.WriteLine(devgro.DeviceGroupsID);

                 //Till here works fine like i want.
              //\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

                foreach (var devices in **devgro**) ////\*\*here i get an Error:
                 ///Error: foreach statement cannot operate on variables of type 'Vw\_MyView' because         'Vw\_MyView' does not contain a public definition for 'GetEnumerator'.	
                {
                    Console.WriteLine(devices.**DevicesID**);
                }
            }

concerning my Code i want that it gives me this output: Key1 --DeviceGroup1 ----Devices1 ----Devices2 ----DeviceGroup2 --DeviceGroup3 Key2 --DeviceGroup4 ----Devices3 --DeviceGroup5 ----Devices4 ----Devices5 Please Help me !

modified on Tuesday, December 16, 2008 6:11 AM