Re: Validation techneques? - C# Discussion Boards

Re: How to localize BackgroundWorker thread?

Pete O'Hanlon10-Feb-11 2:05

Pete O'Hanlon

10-Feb-11 2:05

Why not use CultureInfo.CurrentUICulture?

I'm not a stalker, I just know things. Oh by the way, you're out of milk.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

Re: How to localize BackgroundWorker thread?

Chesnokov Yuriy10-Feb-11 2:29

Chesnokov Yuriy

10-Feb-11 2:29

That is the property returning current thread culture settings that is UI thread.

Чесноков

Re: How to localize BackgroundWorker thread?

Bernhard Hiller10-Feb-11 5:04

Bernhard Hiller

10-Feb-11 5:04

A new thread receives culture/UI culture from the Windows system - in my opinion that's a bug (but Microsoft may see that differently). I use to set the UI culture with a value from the .exe.config file - that can also be applied in a newly started thread. Otherwise, have a (static) member in some class/object you can access from the background worker.

Re: How to localize BackgroundWorker thread?

Chesnokov Yuriy10-Feb-11 6:27

Chesnokov Yuriy

10-Feb-11 6:27

Bernhard Hiller wrote:
I use to set the UI culture with a value from the .exe.config file - that can also be applied in a newly started thread

I do that in UI application, but background worker is in class library which is used by UI application.
Class library is not supplied with config file by intent.
I know it is possible to pass an argument to a thread or access its class variable or static field set up externally but I wonder if it was possible to getbackground thread handle and change its culture.

Чесноков

Run Application With Non Administrator Mode

Anubhava Dimri9-Feb-11 18:54

Anubhava Dimri

9-Feb-11 18:54

Hello Everybody,

If my application is running in administrator Previledge (Run as admin) then i am executing any application from this
application.The Executed application is also run with Administrator Mode. But i want to run it with current user Previledge.

pls describe me how can it possible.

Thanks

If you can think then I Can.

Re: Run Application With Non Administrator Mode

Eddy Vluggen10-Feb-11 7:19

Eddy Vluggen

10-Feb-11 7:19

eg_Anubhava wrote:
But i want to run it with current user Previledge.

Only the user can run processes under his privileges, if you're an admin you'll spawn processes with admin-privileges. You can use the Proces class to spawn a process under a different account, but you'll need the users' name and password. Point is that your process isn't in the users' space, and it has to provide the right credentials before it's allowed there Smile | :)

I are Troll Suspicious | :suss:

Validation techneques?

venomation9-Feb-11 16:19

venomation

9-Feb-11 16:19

I have decided that I need a better way of validating data.

I currently have various objects that can validate information, for example:

if(TextBoxValidator.IsValidTextBox(tbText))...

Also I tend to use the Debug.Assert() methods often, making sure that null or invalid states of variables are shown.

Its starting to get repetitive when I validate:

if(fileDetails.ToString() == string.Empty || map == null) return Common.ReturnResult.Failed;
         if(map.StaticImages == null || map.Tiles == null) return Common.ReturnResult.Failed;
         if(map.Infomation.Columns == 0 || map.Infomation.RootContentFolder == string.Empty || map.Infomation.Rows == 0 || map.Infomation.TileSize == 0)
             return Common.ReturnResult.Failed;

There must be a better way to validate methods input and such than this! Big Grin | :-D

Any suggestions, Thanks D'Oh! | :doh:

Re: Validation techneques?

Keith Barrow9-Feb-11 22:51

Keith Barrow

9-Feb-11 22:51

One way is to avoid nulls in the first place, but if you need to check , here is a start, it is longer but clearer to read:

...

bool Success(footype map) //This isn't the best name
{
 if(map.StaticImages == null)
    return false;
 if(map.Tiles == null)
    return false;
 if(map.Information.RootContentFolder == "")
    return false;
 if(map.Infomation.Rows == 0)
    return false;
 if(map.Infomation.TileSize == 0)
    return false;
}


public Foo()
{
  if(fileDetails.ToString() == string.Empty)
    return Common.ReturnResult.Failed;
  if(map == null) 
    return Common.ReturnResult.Failed;
  if(!Success(map))
    return Common.ReturnResult.Failed;
  return Common.ReturnResult.OKorWhatever;

}

Can you change the map object? If so the Success Status is probably better off there as a property, you could also break this down into further sub-properties such as HasImages, HasInformation etc

Sort of a cross between Lawrence of Arabia and Dilbert.[^]
-Or-
A Dead ringer for Kate Winslett[^]

Re: Validation techneques?

Dalek Dave9-Feb-11 23:02

Dalek Dave

9-Feb-11 23:02

May be better to use CASE statement.

------------------------------------

I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave

CCC League Table Link
CCC Link[^]

Re: Validation techneques?

Bernhard Hiller10-Feb-11 5:13

Bernhard Hiller

10-Feb-11 5:13

What about an "IValidable" interface defining a method "Validate()"?
When "map" and its properties implement it, you could simply call map.Validate() which would encapsulate that logic there.

Re: Validation techneques?

venomation10-Feb-11 7:43

venomation

10-Feb-11 7:43

Thanks for the reply,the problem is that I would have allot of validation objects everywhere, which wouldn't be very fun to use...

Re: Validation techneques?

Matty2210-Feb-11 16:07

Matty22

10-Feb-11 16:07

HOw about

public bool CheckForNulls(object[] thingsThatShouldntBeNull)
{
return thingsThatShouldntBeNull.TrueForAll(x => x != null);
}

CheckForNulls(new object[]{dumbshitCoderField1,dumbShitCoderField2);

Help with excel and hyperlinks

turbosupramk39-Feb-11 10:11

turbosupramk3

9-Feb-11 10:11

Anyone know why isn't this working?

The line oSheet.Cells[row, column] = data; works correctly and it writes to incrementing columns and rows correctly, but I would like it to see if data contains a \\ and then make it a hyperlink if it does.

Thanks for reading.

oSheet.Cells[row, column] = data;

                   if ((data.Contains(@"\\")) && (createSheet == false))
                   {
                       oSheet.Hyperlinks.Add(oSheet.get_Range(row, column), data, System.Type.Missing, System.Type.Missing, data);
                   }

Re: Help with excel and hyperlinks

Dalek Dave9-Feb-11 11:23

Dalek Dave

9-Feb-11 11:23

The main problem is the way you are adding the hyperlink.

Instead of Hyperlinks.add you could try Range.ApplyFormula.

Obviously you have to define the formula...

//create xl file
 string filexl = @" C:\NewFile.xls";
//and a workbook
 Workbook wbnew = new Workbook();
//add the worksheet
Worksheet wsnew = wbnew.Worksheets.Add("New");
 //add a hyperlink
wsnew.Rows[0].Cells[0].ApplyFormula(@"=HYPERLINK(""http://www.codeproject.com"",""Urgentzzzz"")");

Re: Help with excel and hyperlinks

turbosupramk39-Feb-11 16:45

turbosupramk3

9-Feb-11 16:45

Thanks, I will try this tomorrow

Re: Help with excel and hyperlinks

turbosupramk310-Feb-11 5:32

turbosupramk3

10-Feb-11 5:32

Hi Dalek,

As an update, I tried this, it does not work in my IDE. I have 2008 express .net 3.5.

I do not have an option for .ApplyFormula and my oSheet.Cells or oSheet.Rows have to be defined with [row, column].As an update,

Re: Help with excel and hyperlinks

Luc Pattyn9-Feb-11 13:12

Luc Pattyn

9-Feb-11 13:12

URLs tend to contain forward slashes, not backslashes.

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.

Re: Help with excel and hyperlinks

Dalek Dave9-Feb-11 13:32

Dalek Dave

9-Feb-11 13:32

Do you know I looked at that and still didn't see it!
That gets an upvote for Olympic Standard Noticing Smile | :)

Re: Help with excel and hyperlinks

Luc Pattyn9-Feb-11 14:01

Luc Pattyn

9-Feb-11 14:01

Maybe you need polarizing spectacles? Big Grin | :-D

Always see what is there and don't see what isn't.

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.

Re: Help with excel and hyperlinks

turbosupramk39-Feb-11 16:39

turbosupramk3

9-Feb-11 16:39

Hi Luc!

You are right, this is actually a UNC path Smile | :)

I believe it is still considered a hyperlink, but I may have used the wrong terminology, I used hyperlinks because of the c# method terminology.

Re: Help with excel and hyperlinks - ANWSER HERE

turbosupramk310-Feb-11 10:35

turbosupramk3

10-Feb-11 10:35

Here is what works, thanks to all that contributed and answered

oSheet.Cells[row, column] = data;
string cell = oSheet.Cells[row, column].ToString();
if ((data.Contains(@"\\")) && (createSheet == false))
{
Excel.Range rng = (Excel.Range)oSheet.Cells[row, column];
oSheet.Hyperlinks.Add(rng, string.Empty, data, "", data);
}

Desktop application and DB on web server

AlexB479-Feb-11 5:36

AlexB47

9-Feb-11 5:36

Hi,
I'm new in DB programming in .net context and I have a question.
If I use a DB in my internet site (es www.mysite.org), I can quering this DB from my desktop application using ADO.net?

Thank a lot.

Alex

Re: Desktop application and DB on web server

#realJSOP9-Feb-11 5:40

#realJSOP

9-Feb-11 5:40

Yes, as long as the database server can be connected to remotely. If it can't be done that way, you can always create a web service to handle the access, and just connect to the web service instead.

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997

Re: Desktop application and DB on web server

Manfred Rudolf Bihy9-Feb-11 7:53

Manfred Rudolf Bihy

9-Feb-11 7:53

My 5! Good answer since it's most likely that the webserver is behind a firewall. A webservice is a good and viable solution.

Re: Desktop application and DB on web server

Eddy Vluggen9-Feb-11 6:33

Eddy Vluggen

9-Feb-11 6:33

If it's hosted then the database will be likely hiding behind a firewall. Yup, webservices are the way to go Smile | :)

I are Troll Suspicious | :suss:

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.