Thanks, you were right :) I now have it working.

I think thats what I need, but not sure. Basically I want to rotate the returned data by 90 degrees

I think the main problem is I need multiple aggregates (for X, Y and Z). I have this so far select * from Example pivot ( Max(X) for site in ([A],[B],[C]) ) as p

I have done that! Can't work it out tho, as all the example sum values and I dont want to do that. TSQL is not my strong point

I have the following data returned buy a simple SQL query | Site | X | Y | Z | -------------------- A 1 2 3 B 4 5 6 C 7 8 9 I need to get it to the following format | A | B | C | -------------- 1 4 7 2 5 8 3 6 9 Any ideas / code snippits most welcome Mark

Yes s is a string, I have tried that, but it means that my results are in lower case :( Thanks

I have now got this, which works, but i need the grouping to be case insensitive var foo = from s in colours group colours by s into ss select new {colour= ss.Key,score=ss.Count()} any help most welcome

Good Afternoon. I have a list called colours I have the following LINQ statement that returns that list var foo = from s in colours select s ; What I need to do is also select the frequency, so say the list contained red,blue,red,yellow,yellow,green,green,yellow I would get returned red 2 blue 1 yellow 3 green 2 Is this possible using LINQ? any advise, links keywords most welcome Regards Mark

Thanks :D

Hi, I am new to silverlight, and have a little problem! I basically want to have a button and a textbox, and when the user presses the button it links to google and does a search on the text in the text box, so it calls "www.google.co.uk/search?q=" + TextBoxText The problem is when i put somthing like c# in the textbox, the # gets ignored. Mark

Fixed using http://geekswithblogs.net/HouseOfBilz/archive/2009/03/15/binding-to-resources-in-silverlightwpf.aspx[^]

Sorry, thought it backed up your comment of using IsSynchronizedWithCurrentItem="True"

check this out http://windowsclient.net/learn/video.aspx?v=149522[^] Its about validation, but also show what you want to do. you can also download the source

Hopefully this will be an easy one for someone to answer!! I have a class (CollectionsViewModel) with a static properity in (they dont have to be static), which return a List. I want to call the propertiy in xmal to set my itemsource of a combo. Here is what i have

ItemsSource="{Binding Source={x:Static collections:CollectionsViewModel}, Path=GetQueueCollection}"

where collections is defined as the namespace of CollectionsViewModel class I can't set the CollectionsViewModel to the datacontext, as that is set to another class Any help/links most welcome Mark

I agree, its not worth the hassle. Thanks :)

Just checked in public static void MyClassCleanup() { if(QueueLength!=0) { Thread.Sleep(1000); } }

I have a number of test that each submit an object to a Queue (that is declared statically in my Unit test Class) The queue automatically processes each item until there is non left and then fires an event allProcessed. The problem, is that for each unit test all i test is that it was added to the queue correctally, and i need to let the queue finish processing and at the moment it is getting cut off becasue all the tests finish before the queue processed. Is there any way to make the test run wait until the allProcessed is fired? Thanks

Thanks for your reply. It does work if i just have the config file. I was kind of hoping not to have to decalare it in the UI. so that other UI's that use the same BLL dont have to know about the config file.

Good Luck!! :)