|
dataGridView1.CurrentCell = dataGridView1[1, 1];
Be sure that your datagridview had at least 1 column , 1 row .
I know nothing , I know nothing ...
|
|
|
|
|
It works!!
Thanx!!!
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 ...
|
|
|
|
|
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.
|
|
|
|
|
ProcessStartInfo ps = new ProcessStartInfo();
ps.FileName = "console.exe";
ps.Arguments = "";
ps.CreateNoWindow = false;
ps.UseShellExecute = false;
ps.RedirectStandardInput = true;
ps.RedirectStandardOutput = true;
ps.RedirectStandardError = true;
Process proc = new Process();
proc.StartInfo = ps;
proc.Start();
string line = proc.StandardOutput.ReadLine();
proc.Close();
I know nothing , I know nothing ...
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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 used it in my router project ...
when ever I add router or computer I call the set method like this :
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 ...
|
|
|
|
|
Alo,
Que esta' la differencia entre algun y alguno. O esta' la differencia???
Chow
Troy
|
|
|
|
|
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
|
|
|
|
|
|
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.
|
|
|
|
|
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.”
|
|
|
|
|
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
I know nothing , I know nothing ...
|
|
|
|
|
it does not work for the moment
|
|
|
|
|
thank you
I know nothing , I know nothing ...
|
|
|
|
|
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
|
|
|
|
|
thank you yusuf , it's very useful for me ....
Shokarn ....
I know nothing , I know nothing ...
|
|
|
|
|
... please please please please give me a working code sample that uses SendInput to SIMULATE the movement of a mouse on a x64 vista system:
1. move mouse to screen location 200,100
2. mouse down
3. move the mouse down 12 (to 200,112)
4. mouse up
it seems like such a trivial task but is clearly one that i have not been able to master. i have searched the internet high and low, found a gazillion articles on the subject, tried 9 different samples (all failed), and have spent a minimum of 100 hours on this problem. I've learned a lot but the idea of running 32-bit DLL's on a 64-bit computer is still way over my head ... i need help desperately.
I have been able to get it to work using SetCursorPos and mouse_event but those methods actually steal the mouse from the user and make him VERY grumpy
Thank you oh so VERY MUCH in advance!
|
|
|
|