Re: How to launch a console application from a form application - C# Discussion Boards

Re: How to set focus to specified cell of Datagridview

6-Jun-09 21:34

dataGridView1.CurrentCell = dataGridView1[1, 1];

Be sure that your datagridview had at least 1 column , 1 row .

I know nothing , I know nothing ...

KIDYA6-Jun-09 21:42

KIDYA

6-Jun-09 21:42

It works!!
Thanx!!! Big Grin | :-D

Sending sql Query string as parameter in User defined function

mmdullah6-Jun-09 19:37

mmdullah

6-Jun-09 19:37

Hi all,

I want to write a sql generic function that will return numeric value.
I want to pass the whole sql query.
but it results error when executing

my user user defined function:

Create FUNCTION GetDoubleAmount(@strSQL varchar(500))
RETURNS decimal(18,6)
AS
BEGIN
return (select @strSQL)
END

calling with:
select dbo.GetDoubleAmount(
'SELECT SUM(CRAMT) As TotAmt From tblTLHistory'
)
results:

Msg 8115, Level 16, State 6, Line 1
Arithmetic overflow error converting varchar to data type numeric.

please help in asap

Re: Sending sql Query string as parameter in User defined function

Mycroft Holmes6-Jun-09 21:27

Mycroft Holmes

6-Jun-09 21:27

You need to do some more study, this is not going to work. The error in your current attempt is that you are using Select @StrSQL, this returns the string variable.

What you want to do is EXECUTE the string variable which I don't think you can do in a UDF. Besides it is bloody dangerous any time you exec a sql string (sql injection) and a UDF has no additional security.

Never underestimate the power of human stupidity
RAH

Re: Sending sql Query string as parameter in User defined function

I Believe In GOD6-Jun-09 21:58

How to lunch a console application from a form application

6-Jun-09 21:58

Excute this code all at once from Query Anaylzer

DECLARE @val as decimal
SET @val = (SELECT SUM(CRAMT) As TotAmt From tblTLHistory)
select dbo.GetDoubleAmount(@val)

I know nothing , I know nothing ...

nhack6-Jun-09 11:36

nhack

6-Jun-09 11:36

Hy,

I need to lunch a console application from a C# Windows Forms application. I have done something like that

Process serverProcess=new Process();

serverProcess.StartInfo.FileName = "wserver2";
serverProcess.StartInfo.UseShellExecute = true;
serverProcess.StartInfo.CreateNoWindow = false;

this.serverProcess.Start();

The code works fine, but I need a console to appear when the serverProcess is started and this process should appear in that console.

Re: How to lunch a console application from a form application

I Believe In GOD6-Jun-09 12:20

Re: How to launch a console application from a form application

6-Jun-09 12:20

ProcessStartInfo ps = new ProcessStartInfo();
ps.FileName = "console.exe";
ps.Arguments = "";
ps.CreateNoWindow = false;
ps.UseShellExecute = false; // or true donna know 
ps.RedirectStandardInput = true;
ps.RedirectStandardOutput = true;
ps.RedirectStandardError = true;

Process proc = new Process();
proc.StartInfo = ps;
proc.Start();

//proc.StandardInput.WriteLine("testing");
//proc.StandardInput.WriteLine("testing");

string line = proc.StandardOutput.ReadLine();
			
proc.Close();

I know nothing , I know nothing ...

Alan N6-Jun-09 12:48

Alan N

6-Jun-09 12:48

nhack wrote:
The code works fine

Is wserver2 a console application?
What do you mean by works fine as I assume you are asking the question because it isn't working fine!

Alan.

Re: How to launch a console application from a form application

nhack6-Jun-09 21:24

nhack

6-Jun-09 21:24

wserver2 is a console application and it works fine because i connect to it (it is a ssl server). My problem is that i want to see the output of the server in a new console window.

Re: How to launch a console application from a form application

Alan N7-Jun-09 0:42

Alan N

7-Jun-09 0:42

Hi,
I can't see anything wrong with the Process code. Are you missing any important command line switches? When the process is started from Windows Explorer does it display a console window?

Alan.

Re: How to launch a console application from a form application

nhack7-Jun-09 1:22

nhack

7-Jun-09 1:22

Yes, when the server is started from Explorer it displays a console window. If a lunch my Form application from the console the output is printed on the console, but what i want is to open a new console and to print the output from the server process on the new console.

any advantage by using get/set in c#?

Seraph_summer6-Jun-09 10:43

Seraph_summer

6-Jun-09 10:43

I know that get and set is widely used in C#, e.g.

public class test

{

private int a = 2;

public int example
{
get {return a;}
set {a=value;}
}

}

above code is same as (I think)

public class test
{
public int a = 2;
}

but I believe that get/set should have more advantages, anyone can give me one hint for that?

thanks

0x3c06-Jun-09 10:53

0x3c0

6-Jun-09 10:53

Because they allow you to perform special handling when a value is set or got. They offload the validation checking away from main methods, keeping the main code 'clean'. Additionally, they let you provide calculated values, so that you don't have to call UpdateProperty() - you can just put the code in the get method. Also, you can properties to interface declarations

Between the idea
And the reality
Between the motion
And the act
Falls the Shadow

I Believe In GOD6-Jun-09 11:17

6-Jun-09 11:17

I used it in my router project ...

when ever I add router or computer I call the set method like this :

// 5 routers added ;
ObjectsCounter.Routers = 5;

here is my code :

class ObjectsCounter
    {
        private static int routers;
        public static int Routers
        {
            set {
                routers += value;
            }
            get {
                return routers;
            }
        }
}

of course you can call it like that too :

ObjectsCounter.Routers += 5;

I know nothing , I know nothing ...

Troy Russell6-Jun-09 11:18

Troy Russell

6-Jun-09 11:18

Alo,
Que esta' la differencia entre algun y alguno. O esta' la differencia???

Chow
Troy Sleepy | :zzz:

FocusedWolf6-Jun-09 11:32

FocusedWolf

6-Jun-09 11:32

Properties have a special use if your making a custom control with custom properties.

#region Color HighlightColor

private Color highlightColor = Color.Yellow;
[DefaultValue(typeof(Color), "Yellow")]
public Color HighlightColor
{
get { return highlightColor; }
set
{
if (highlightColor != value)
{
highlightColor = value;
this.Invalidate();
}
}
}

public bool ShouldSerializeHighlightColor()
{
return highlightColor != Color.Yellow;
}

public void ResetHighlightColor()
{
HighlightColor = Color.Yellow;
}

#endregion

here's one from a control i'm working on... the attribute for defaultvalue and the ShouldSerialize##"Property Name" Reset##"Property Name" functions are specially called by the visual studio ide... so when you have your control on the designer, and you play with a setting... you can do stuff like right click it and hit "Reset"... also the shouldSerialze function is checked for if the designer needs to save that setting to the .designer.cs file. This way the designer doesnt have to serialze a dozen default values... which probably improves performance or whatnot... looks nicer to when you gotta go in the designer file... i forget if the defaultvalue attribute means so when you type a value in the propertygrid, that if its the default value in that attribute, that the ide shows regular font or bold, that you changed it from default,...

So properties are nice if your making a custom control. Otherwise, properties are handy for controlling what comes in and leaves your class...

like have a getOnly type property like:

public int Something {
get { return something; }
}

or here's checking input:

public string SomeOtherThing {
get { return someOtherThing; }
set
{
if (!String.IsNullOrEmpty(value))
someOtherThing = value;
}
}

.... so i see your point... i mean in C++ the method was with functions to do the same job. So the only advantage of a property is that the IDE can draw a nice little icon when it detects one in your class... like i mean intellisense... other then that, and all programmers already expect to play with properties to set settings, that they have no purpose. Practically a bloated feature if we just look at C# as the language... but ya, their good for the vs.net designer when plopping controls on a form :P

Troy Russell6-Jun-09 12:10

Troy Russell

6-Jun-09 12:10

Christian Graus6-Jun-09 12:51

Christian Graus

6-Jun-09 12:51

The obvious one is that you can make the set private.

Christian Graus

Driven to the arms of OSX by Vista.

Please read this[^] if you don't like the answer I gave to your question.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

http://www.sourceforge.net/

Henry Minute7-Jun-09 0:48

Henry Minute

7-Jun-09 0:48

C# is an Object Oriented Language, or at least it purports to be.

get/set, as you call it, or Properties, as they should be called, are a fundamental part of the .NET implementation of the principals of OOP.

Take a look at this[^] for a clearer explanation than I could give in a reasonable space.

You can use C# to program in a non-OOP way but you are better off learning what OOP is all about and trying to adhere to its principals.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

I Believe In GOD6-Jun-09 10:29

6-Jun-09 10:29

http://www.sourceforge.net/

is this site still working ? can any one browse it ?

I got bad request

sorry for this Question , but I have no friends around me , to ask them ...

you are my only Rose | [Rose]

I know nothing , I know nothing ...

Seraph_summer6-Jun-09 10:38

Seraph_summer

6-Jun-09 10:38

it does not work for the moment

I Believe In GOD6-Jun-09 10:49

6-Jun-09 10:49

thank you

I know nothing , I know nothing ...

Yusuf6-Jun-09 11:19

Yusuf

6-Jun-09 11:19

Stark DaFixzer wrote:
but I have no friends around me

hmm, well, may be make this[^] your friend. You see it[^] knows the status of website Wink | ;)

Yusuf
May I help you?

I Believe In GOD6-Jun-09 11:55