You should consider normalizing the table. It would make it a lot easier in the future to add functionality. Consider this: CREATE TABLE Incidents ( Site varchar IncidentType varchar, IncidentDate Date, Incidentinfo varchar, ... ) Then just make your pivot on Select site,incidenttype,count(*) as incidentcount from incidents You may also exchange site and incidenttype for IDs referencing tables holding info on sites and incidenttypes. If you add a site to your organisation you simply add a row in a table. "When did ignorance become a point of view" - Dilbert

I remembered such class exists. When I was answering the question I thought it was System.Collections.CaseInsensitiveComparer but I checked and it isn't an IEqualityComparer. Gideon Engelberth suggested ToLower so I decided to go with it at least to illustrate the IEqualityComparer interface. Thanks for reminding me where to find it :) I'll try to never forget it again, it is an IComparer too :cool: Eslam Afifi

You are welcome. :) "WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes. My blog | My articles | MoXAML PowerToys | Onyx

It is simple only Check this article Displaying Multiple Property Values In WPF Combo by using DataTemplate, Style & Triggers[^] -Niladri Biswas :) Niladri Biswas

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

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

Many thanks for your reply. That still does not do what i want, i am starting to think that i am going about this the wrong way :( Put simply what i need is a combobox with a datasource of list of my objects (all the same type). Then when the form loads i want the combobox to have preselected an object of my choice (what ever was saved in xml/db) I am new to wpf and the mvvm pattern, and this is getting a bit frustrating!! ps for info i changed the colour class to the following as the other throw an exception public class Colour { public string Description { get; set; } public override bool Equals(object obj) { if(obj.GetType()== typeof(Colour)) return this.Description == ((Colour) obj).Description; return base.Equals(obj); } public override int GetHashCode() { return base.GetHashCode() ^ this.Description.GetHashCode(); } }

I was just looking at virtual print drivers, thanks for the link, I may have to write a bit of C++.

Its one of those things, been seaching all morning for the solution (about 2hours) then think right final effort post on here, and 2 min later i find the solution, :doh:

I see no reason to treat this as a bad practice. I have done this exact thing once, and I reference Windows.Forms all the time to get the File Dialogs (I just like the old ones better).

Probably easiest to find a command line compressor, and run that There's an OSS version here: http://sourceforge.net/projects/ARC[^] Help me! I'm turning into a grapefruit! Buzzwords!

yeah thats what i meant to write lol

Looks good, but it wont work for my needs (my fault for not being detailed enough in the first post, sorry) The value must be a string, so they will all be Dictionary <int, string > The 1st post was only trying to give an example, and in the real app, the values will be things that are not represented by .net classes (I could make classes for each type, but again that means loads of classes)

Thanks Guys, got it all sorted

after some digging, i have found the answer adapter.ContinueUpdateOnError = true; will make sure it continues after an error and SqlCeCommandBuilder builder = new SqlCeCommandBuilder(adapter); builder.ConflictOption = ConflictOption.OverwriteChanges; Makes it a last in wins, which will do for my app.

Being polite costs nothing. As a member of a number of (coding/car/RC Helicopter) forums I see no end of rudeness. When others try and help (even if they cant solve your problem), they have taken their time to try, why not be polite and say thanks just my 2p worth :) Mark

Please go through the given link http://blogs.msdn.com/ie/archive/2005/01/26/361228.aspx[^] Cheers!! Brij

Hi mark, i don´t know if that works for you, my coding different static string _image_path; public static string Image_Path { get { return _image_path; } set { _image_path = value; } } but, were is the database? :doh: nelsonpaixao@yahoo.com.br trying to help & get help

Thanks for your reply