About PostMessage() API - C# Discussion Boards

Abdul Rahman Hamidy3-Jan-09 2:35

Abdul Rahman Hamidy

3-Jan-09 2:35

Here in Afghanistan, If you prefer MS SQL Server, then of course the price for that application will increase and if u get MySQL then u have to consider about the performance,replication,recovery and security.
My question is regarding only performance, that which one of these two RDBMS provides faster performance.

Thanks,

Abdul Rahaman Hamidy
Senior Student Student in Computer Science
Kabul, Afghanistan
Software Developer

Aman Bhullar3-Jan-09 5:21

Aman Bhullar

3-Jan-09 5:21

IF you are using .net as a fron end, then best RDBMS option available is MS SQL. There is a performance gain when we use MS SQL as back end.
And the performance gain is not negligible.

Regarding cost factor for original. Do not install it on your computer. Have one with web hosting account.
Install SSMSE(Its free) on you PC. Connect to remote server and do your job.

N a v a n e e t h3-Jan-09 16:14

N a v a n e e t h

3-Jan-09 16:14

It's very tough to say which is better. I have a high traffic website which uses MySQL as backend and works like a charm. It gives good performance. But you can gain that only by optimizing your queries and code. Proper indexing also reduces the query execution time.

BTW, how are you connecting to MySQL from C#? Is it through Oledb? If yes, that might be the reason for bad performance. Oledb is slow and you should consider the MySQL connector provided by MySQL which can be downloaded from MySQL site. I'd suggest to go with MySQL (5.0 or later).

Navaneeth

How to use google | Ask smart questions

Abdul Rahman Hamidy4-Jan-09 0:30

Abdul Rahman Hamidy

4-Jan-09 0:30

I am using MySql.Data.dll with c#, there is no OleDb.
In here if some one asks me what u recommend as back end with c#, i really get stacked, because now i have read different articles about both of them, in truth i do really appreciate to have trusted reference regarding benefits of each and disadvantage of each.

Abdul Rahaman Hamidy
Senior Student Student in Computer Science
Kabul, Afghanistan
Software Developer

Wendelius4-Jan-09 1:20

Wendelius

4-Jan-09 1:20

I think it's impposible to say which one is better. The choice depends on many factors like:
- investment costs (both hardware and licenses)
- desired support level and are you willing to pay for it
- possibly existing databases (why bring a new product if existing are implemented using a different product)
- how familiar you/your team is with the product
- what is the future roadmap for the product etc.

From my experiences, if you are worried about the performance, there's very little difference between different databases, but the way how you get most out of them may be different. So the optimization process may not be equal. However, most of performance isn't coming from the database itself, instead it's how you use it:
- database modelling
- indexing
- types of sql statements
- application logic
- number of roundtrips etc.

If I should say something good for both products:
- both SQL Server Express Edition and MySQL are free to use
- SQL Server has more capabilities and features than MySQL
- MySQL group is very active but the information may be scattered
- integration for SQL Server in .Net is better

But as said, you should think of your environment and your needs in order to make the decision. One product isn't the best choice in all cases, so there's no absolute truth.

The need to optimize rises from a bad design.My articles[^]

Abdul Rahman Hamidy4-Jan-09 22:57

Abdul Rahman Hamidy

4-Jan-09 22:57

thx alot, infact u solved my problem.
i am sure, after this i would use RDBMS based on Envoirnment and for solving cost i would use SQL Express Edition which is free instead of Management studio.
your answer is really appreciated,
thanks,

Abdul Rahaman Hamidy
Senior Student Student in Computer Science
Kabul, Afghanistan
Software Developer

Wendelius5-Jan-09 6:06

Wendelius

5-Jan-09 6:06

Abdul Rahman Hamidy wrote:
thx alot, infact u solved my problem

You're welcome Smile | :)

The need to optimize rises from a bad design.My articles[^]

About PostMessage() API

tr_thorn3-Jan-09 1:01

tr_thorn

3-Jan-09 1:01

Hi i wanna do a bot program for a game.This program send key strokes to Game Application.But i got a problem.I only wanna send key to Game Application Window Handle not another active window.I write a class for this but i havent get worked it.Its sending keys only notepad not to game or any other window.Can ya help me for this ? Iam sending ya codes below ; and tell me where is my problem. thanx for ur help.

class SendKeySample
{
private static Int32 WM_KEYDOWN = 0x100;
private static Int32 WM_KEYUP = 0x101;

[return: MarshalAs(UnmanagedType.Bool)]
[DllImport("user32.dll", SetLastError = true)]
static extern bool PostMessage(IntPtr hWnd, int Msg, System.Windows.Forms.Keys wParam, int lParam);

[DllImport("user32.dll", SetLastError = true)]
private static extern IntPtr FindWindowEx(IntPtr hwndParent, IntPtr hwndChildAfter, string lpszClass, string lpszWindow);

public static IntPtr FindWindow(string windowName)
{
foreach (System.Diagnostics.Process p in System.Diagnostics.Process.GetProcesses())
{
if (p.MainWindowHandle != IntPtr.Zero && p.MainWindowTitle.ToLower() == windowName.ToLower())
return p.MainWindowHandle;
}

return IntPtr.Zero;
}

public static IntPtr FindWindow(IntPtr parent, string childClassName)
{
return FindWindowEx(parent, IntPtr.Zero, childClassName, string.Empty);
}

public static void SendKey(IntPtr hWnd, System.Windows.Forms.Keys key)
{
PostMessage(hWnd, WM_KEYDOWN, key, 0);

}
}

Calling Code ;

var hWnd = SendKeySample.FindWindow("Untitled - Notepad");
var editBox = SendKeySample.FindWindow(hWnd, "edit");

SendKeySample.SendKey(editBox, Keys.A);

Windows Users

yogesh_kumar_agarwal3-Jan-09 0:32

yogesh_kumar_agarwal

3-Jan-09 0:32

Dear All

I want to create a form in C# by that a user is unable to change the users detail for windows.

Means i want to change, create users in windows using c# application.

How could i do the same. plz reply

Regards

Yogesh

pikmindoctor3-Jan-09 4:25

pikmindoctor

3-Jan-09 4:25

Try rephrasing your question - It's difficult to read.

EliottA3-Jan-09 10:50

EliottA

3-Jan-09 10:50

I think he wants to control user accounts and their permissions...

yogesh_kumar_agarwal5-Jan-09 23:33

yogesh_kumar_agarwal

5-Jan-09 23:33

Yes, you are right i want to do the same.

How To Install .net Framework Without Wizard

Eddy Vluggen3-Jan-09 23:10

Eddy Vluggen

3-Jan-09 23:10

That's too vague. Do you want to crud the local accounts, or do you want to administer all the network-accounts as well?

IOW; do you want to make new users on YOUR pc, or do you want to make new users on the network?

I are troll Smile | :)

add control

hamidhakimi2-Jan-09 18:52

hamidhakimi

2-Jan-09 18:52

i want add control when program run then apply event for it? please help

Re: add control

Giorgi Dalakishvili2-Jan-09 20:53

Giorgi Dalakishvili

2-Jan-09 20:53

Like this:

TextBox box= new TextBox();
box.TextChanged += new (TextChangedHandler);
this.Controls.Add(box);

Giorgi Dalakishvili

#region signature
My Articles

Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^]

My blog
#endregion

convert pdf to doc

inzibharti2-Jan-09 18:15

inzibharti

2-Jan-09 18:15

I have to convert pdf to doc in .net

I have tried some dll's but they are not preserving the image
and the formatting of the text.
Any solution or idea except code project's article on pdfbox.

Don't walk as if u rule the world,walk as if u don't care who tha Hell rules the world ...

Re: convert pdf to doc

Dave Kreskowiak2-Jan-09 19:55

Dave Kreskowiak

2-Jan-09 19:55

Google around for more libraries that support doing this. I don't know of any since I have never used PDF in my apps.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Joe Rozario2-Jan-09 17:23

Joe Rozario

2-Jan-09 17:23

Dear Friends,

i am working on a project where we need to install application in remote machine,

now i want to install .Net Framework to Install.

i want to know how to install .Net Framework without wizard??

please help Me?

Any idea?? Any References??

BY

Joe.I

N a v a n e e t h2-Jan-09 17:35

N a v a n e e t h

2-Jan-09 17:35

Is there a specific reason for installation without wizard? AFAIK, you can't control it.

Navaneeth

How to use google | Ask smart questions

Dave Kreskowiak2-Jan-09 19:54

Dave Kreskowiak

2-Jan-09 19:54

Try launching the dotnetfx.exe with the /Q command line switch:

dotnetfx /q

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

N a v a n e e t h3-Jan-09 1:05

N a v a n e e t h

3-Jan-09 1:05

Dave Kreskowiak wrote:
dotnetfx /q

WOW! New information to me. Thanks Smile | :)

Navaneeth

How to use google | Ask smart questions