|
how can i send messages to gtalk or yahoo messenger and receive from it.
“You will never be a leader unless you first learn to follow and be led.”
–Tiorio
"Coming together is a beginning, staying together is progress, and working together is success." Henry Ford
|
|
|
|
|
Do not attempt to bump your post to the top of the forums. That's bad form - very bad form.
|
|
|
|
|
I second that. It's bad enough some clown on the town/community forum for my area loves to do this to keep old, dead threads, alive. I think the chap is still trying to figure out what FFS means
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
I need to get sql command text where parameters are replaced by values.
I tried code below but displayed sql statement contains parameter names,
not actual values.
How to obtain command where parameters are replaced by their values ?
Andrus.
static IDataReader ExecuteReader(string command
, out IDbConnection connection
, CommandBehavior behavior
, params IDbDataParameter[] dataParams)
{
connection = ...
connection.Open();
IDbCommand cmd = new SqlCommand(command, connection as
SqlConnection);
foreach (IDbDataParameter p in dataParams)
cmd.Parameters.Add(p);
MessageBox.Show(cmd.CommandText);
return cmd.ExecuteReader(behavior |
CommandBehavior.CloseConnection);
}
Andrus
|
|
|
|
|
As far as I know you can't get the actual command text that is executed programmatically. With sql server you can use sql server profiler to see the command being executed.
|
|
|
|
|
There is a tricky way to do it.
ADO not seems to help providing the SQL query with the proper values prior running.
Here my code snippet that will do the job and may be easily converted any other .NET variant. It's a simple example but may be a start.
Some basic checks were done regarding quotes and backslashes but for sure this code need some care before use on production enviroment.
Note: You will need to change the type SQLiteCommand/SQLiteParameter to the one that matches your ADO methods set.
public static string getQueryFromCommand(SQLiteCommand cmd)
{
string CommandTxt = cmd.CommandText;
foreach (SQLiteParameter parms in cmd.Parameters)
{
string val = String.Empty;
if (parms.DbType.Equals(DbType.String) || parms.DbType.Equals(DbType.DateTime))
val = "'" + Convert.ToString(parms.Value).Replace(@"\", @"\\").Replace("'", @"\'") + "'";
if (parms.DbType.Equals(DbType.Int16) || parms.DbType.Equals(DbType.Int32) || parms.DbType.Equals(DbType.Int64) || parms.DbType.Equals(DbType.Decimal) || parms.DbType.Equals(DbType.Double))
val = Convert.ToString(parms.Value);
string paramname = "@" + parms.ParameterName;
CommandTxt = CommandTxt.Replace(paramname, val);
}
return (CommandTxt);
}
Bruno Ratnieks
CTO Sniffer.net
bruno@sniffer.net
|
|
|
|
|
Hello
I want to detect a mouse StandBy state
I presume that I can do that by combining the MouseMove event and a timer event
But I have no experience with timer event in Csharp
So, before to re-invent the wheel Im looking for some example / suggestion
Thanks for any help
|
|
|
|
|
With forms there's the Control.MouseHover Event.
To implement your own, something like this maybe...
How to detect NO mouse movement[^]
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
Timers are easy, don't worry about that.
I'd say create a timer and start it then leave it running until your application closes.
Inside the callback for the Tick event increase a counter, if the counter is above a certain value then you can do whatever it is you need to do. Inside the MouseMove event, reset the counter to 0.
Timer Demo[^]
All you really need are the 4 lines at the beginning of the constructor, and you can just add a timer in the designer too, and set it up there.
My current favourite word is: Nipple!
-SK Genius
Game Programming articles start - here[ ^]-
|
|
|
|
|
Thank you SK Genius
Yes it sounds simple I'll try that
However I do not really see what the other solution "Mouse not move" is doing beside this one
|
|
|
|
|
Mark just made his post as I was still writing mine, either way would work just fine.
My current favourite word is: Nipple!
-SK Genius
Game Programming articles start - here[ ^]-
|
|
|
|
|
Hello SK Genius
Your method sounds good !
A little question
I have the Idea to use the timer only when the mouse is on the concerned control
So I will do a Timer.something(); for the MouseEnter and a Timer.anotherthing() for the mouseLeave
The question is what thing :
Timer.enabled=true;
or
Timer.Stop();
What is the difference ?
|
|
|
|
|
Did you completely ignore my post?
Did you look at the code at the link I provided?
Are you using Windows forms? If so did you know mouse hover
functionality (which is what you're doing) is built in?
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
Hello Mark
I'm sorry
No No I do not ignore your post but I thought that the other solution mentionned was similar to yours
For mousehoover : I 've tried this event a few month ago on a picturebox but discard it
As far as I remember I've found that MouseHoover only trigger once at the first stand_by on the control after entering the control. To get another MouseHoover I have to leave the PB and reenter
But maybe I'm wrong ???
|
|
|
|
|
|
Hello Again Mark
Ok I understand now that you are using Stop() / Start() sequence to reset the timer
But it is very similar as the counter ... No ?
My other question remain : what is the difference between Start / Stop
and
enable / disable
|
|
|
|
|
baranils wrote: But it is very similar as the counter ... No ?
I'm not sure what counter you're referring to - I missed
something somewhere
baranils wrote: what is the difference between Start / Stop
and enable / disable
No difference that I see besides Enabled being a property and
Start/Stop being methods.
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
SK Genius suggest to use a counter
Increment the counter at every Tick interval
Reset the counter at every MousMove
I like this method because it allows to decide wich action to take depending of the counter value
Fast action for lowest counter
Much time consuming action for higher counter
|
|
|
|
|
Ohhh - Got it, thanks
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
Hello
I one more Question
Now I catch the MouseNotMove event
How can I get the MousePosition on my picturebox at that moment ?
|
|
|
|
|
One way is use the Cursor.Position property followed by
the Control.PointToClient() method.
Mark
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
Yes got it too !
But when I try it first I thought it does not work because in debugger the mouse was still active and I was getting another position that I was expecting !
Good to know !!
|
|
|
|
|
I have been trying to do this for some time now, and at one time, before I gave up, had code from 2 different people, 1 in VB for detecting the thumb drive being inserted, and 1 in C# for suppressing Autorun.(Could have been the other way around.) Since then, I have lost both files, and I'm simply wondering if it is possible to code something in C# to do both, and then run a program on that drive(PortableApps). My biggest problem is that I know very little C# or any other language for that matter. I do have a friend that is really good at it, but he hasn't been able to figure it out either.
Thanks in advance, for anyone who takes the time to read this.
|
|
|
|
|
This article covers device insertion detection, not sure about preventing autorun, however.
Regards,
--Perspx
Don't trust a computer you can't throw out a window
-- Steve Wozniak
|
|
|
|
|
thanks for the tip. The autorun suppression has proven to be a problem, as nobody seems to be able to code it in C#, only VB.
Does anybody have a solution to this?
|
|
|
|