No problem. It's the commonest problem with it, which was how I guessed at the top. Forgive your enemies - it messes with their heads My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

Etienne_123 wrote: I do not want to use string formattin What is displayed on screen is a string that is currently using the default formatting, so doing a custom string format is the correct way. The sort should be done on the real values regardless of how it's displayed IMO, this way therer is no issue. Dave Binging is like googling, it just feels dirtier. Please take your VB.NET out of our nice case sensitive forum. Astonish us. Be exceptional. (Pete O'Hanlon) BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

Etienne_123 wrote: Anyone have any ideas why this won't work? What would it fill the variable with if FirstName does equall null? You'd better assign it directly without the IF statement, and use the [ISNULL](http://msdn.microsoft.com/en-us/library/ms184325.aspx)[[^](http://msdn.microsoft.com/en-us/library/ms184325.aspx "New Window")] function. Bastard Programmer from Hell :suss:

Etienne_123 wrote: some of the columns come back as NULL. However, when I SELECT TOP 1000 rows from the view, the records in these columns are returned with the correct values Sounds like a data conversion issue. Common sense is admitting there is cause and effect and that you can exert some control over what you understand.

Indeed I'm not. Plz send appropriate regex codez. :) Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

We also have a RegEx forum.

Move your sub query from the join to the select and add the mandateID to the where clause. This can be repeated for different feature types. Caveat this type of sub select can be very slow and expensive. Another way would be to left join out to the feature table multiple times (1 for each feature type) using a case statement on the if field (case featureid when is null then 0 else 1 end), group by your mandate fields and sum each feature field. Another way is to use the same multiple joins and then pivot the rows so each feature is in it's own column. Never underestimate the power of human stupidity RAH

if you upload by sending chunks of data, then yes you could use the exact number of bytes transferred so far. OTOH if your upload is a single action with no progress reporting, then you don't really know; you could still use a timer to have the progress bar advance corresponding to the amount of bytes in that upload, based on an assumed upload rate, which you could derive from the uploads done before, so only the first upload would have a jerky progress, and even that could be remedied by starting with either a historic upload rate, or a reasonable first estimate. So it all depends on how you upload things. Since you asked, I expect you'd be in the latter category. :) Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

Thanks for all the replies :) I managed to sort it out

I've realised that this method won't work due to various other methods that gets called from the long operation, methods that change controls etc. This raises the "control accessed from a different thread..." error. I cannot change these methods becauses it is part of a rather tightly coupled project. There must be a way to simply update the progressbar on the LoadingForm using a thread?!

Nice Link it help me also :)

I do not want to disable the whole service though, only the selection of the properties e.g. the combobox for selecting the DPI etc. so that the user cannot modify these

Yes - the encryption doesn't care what the content is. I would suggest either a simple directory structure, or just a length prefix/filename combination to each file so you can extract them from the decrypted stream. Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.

Ennis Ray Lynch, Jr. wrote: set off data security alarms Absolutely, as I mentioned in my first post, but I don't think HIPAA is involved. I had a class on HIPAA last month. It's more a common sense issue -- don't write down passwords... anywhere. Especially where others can get them. And don't trust a third party to keep them safe.

I just figured it out :) Below is what I used: if (element.GetAttribute("value") == "Login") { element.InvokeMember("click"); }

I have found few useful links for the same. Just go through it. Controlling Skype with C#[^] http://blogs.skype.com/devzone/2006/12/c_example_project_for_skype4co.html[^] http://forum.skype.com/index.php?showtopic=73172[^] HTH Jinal Desai - LIVE Experience is mother of sage....

Is that a AND/OR or XOR? Sessions are usually temporary, and according to the docs I just been reading, you'd want to request "offline access". See the bottom of this[^] page. I are Troll :suss: