|
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).
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
Abdul Rahman Hamidy wrote: thx alot, infact u solved my problem
You're welcome 
|
|
|
|
|
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);
|
|
|
|
|
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
|
|
|
|
|
Try rephrasing your question - It's difficult to read.
|
|
|
|
|
I think he wants to control user accounts and their permissions...
|
|
|
|
|
Yes, you are right i want to do the same.
|
|
|
|
|
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 
|
|
|
|
|
i want add control when program run then apply event for it? please help
|
|
|
|
|
Like this:
TextBox box= new TextBox();
box.TextChanged += new (TextChangedHandler);
this.Controls.Add(box);
|
|
|
|
|
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 ...
|
|
|
|
|
Google around for more libraries that support doing this. I don't know of any since I have never used PDF in my apps.
|
|
|
|
|
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
|
|
|
|
|
Is there a specific reason for installation without wizard? AFAIK, you can't control it.
|
|
|
|
|
Try launching the dotnetfx.exe with the /Q command line switch:
dotnetfx /q
|
|
|
|
|
Dave Kreskowiak wrote: dotnetfx /q
WOW! New information to me. Thanks
|
|
|
|
|
Make the wizard leave the room before you install it.
(I love the easy questions like this one.)
"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
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
Dear Sirs:
I have a C# application with a ToolStrip control and a RichTextBox control.
Three of the buttons on the toolStrip are for formatting the text in the RichTextBox, i.e., Bold, Italic, and Underlined. I have the CheckOnClick property set to true for these 3-buttons. My code successfully sets the selected text to any\all of the above formatting.
However, the button's CheckState remains "Pressed" or clicked, unless I physically unclick it. What I want to do is emulate what occurs in a WordPad document, where by both scrolling over formatted text, or clicking into formatted text causes the Bold button, Italic button, or Underline button(s) to appear depressed or clicked and conversely, to not appear depressed or clicked when the user clicks outside of the formatted text or scrolls past it.
Does anyone know how to accomplish this in C# and also what event(s) to place this code in, so that this happens smoothly for the end-user?
Thank you in advance for your answer
Richard
|
|
|
|
|
private void richEdit_SelectionChanged(object sender, EventArgs e)
{
if (richEdit.SelectionFont != null)
{
ButtonBold.Checked = richEdit.SelectionFont.Bold;
ButtonItalic.Checked = richEdit.SelectionFont.Italic;
ButtonUnderline.Checked = richEdit.SelectionFont.Underline;
}
}
Enjoy
I are troll
|
|
|
|
|
Hello Eddy:
Thanks a lot for your reply. The code gives me exactly what I was looking for and works great.
I didn't know how to accomplish this but was fairly certain it could be done. Also, I wasn't sure which event to call it in.
Your submission is very much appreciated.
Thanks again.
Richard
|
|
|
|
|
I have followed another tutorial on adding checkboxes to datagrids and have gotten it to show up. The problem is that I cannot get the checkbox column to bind to my dataset column. I alway see gray checkboxes when I run. All of the other columns are binding correctly. Anyone know what I am doing wrong?
Here is the code
DataGridTableStyle tableStyle = new DataGridTableStyle();
tableStyle.MappingName = "Invoice";
DataGridColumnStyle DateColumn = new DataGridTextBoxColumn();
DateColumn.MappingName = "Date";
DateColumn.HeaderText = "Date";
DateColumn.Width = 200;
tableStyle.GridColumnStyles.Add(DateColumn);
DataGridColumnStyle InvoiceNumberColumn = new DataGridTextBoxColumn();
InvoiceNumberColumn.MappingName = "InvoiceNumber";
InvoiceNumberColumn.HeaderText = "Invoice Number";
InvoiceNumberColumn.Width = 200;
tableStyle.GridColumnStyles.Add(InvoiceNumberColumn);
DataGridColumnStyle RackNumberColumn = new DataGridTextBoxColumn();
RackNumberColumn.MappingName = "RackNumber";
RackNumberColumn.HeaderText = "Rack Number";
RackNumberColumn.Width = 100;
tableStyle.GridColumnStyles.Add(RackNumberColumn);
DataGridColumnStyle PaidColumn = new DataGridBoolColumn();
PaidColumn.MappingName = "Paid";
PaidColumn.HeaderText = "Paid";
((DataGridBoolColumn)PaidColumn).AllowNull = false;
PaidColumn.Width = 100;
tableStyle.GridColumnStyles.Add(PaidColumn);
DataGridColumnStyle PickedUpColumn = new DataGridBoolColumn();
PickedUpColumn.MappingName = "PickedUp";
PickedUpColumn.HeaderText = "Picked Up";
((DataGridBoolColumn)PickedUpColumn).AllowNull = false;
PickedUpColumn.Width = 100;
tableStyle.GridColumnStyles.Add(PickedUpColumn);
myDataGrid.TableStyles.Add(tableStyle);
[IMG]http://i40.tinypic.com/34fo65j.jpg[/IMG]
Here is a snapshot of my APP. The datagrid on the lower portion shows the unaltered dataset, whereas the top datagrid is the one I am using the datagridstyle for
|
|
|
|
|
Also, I am getting:
'System.Windows.Forms.DataGridColumnStyle' does not contain a definition for 'TrueValue'
'System.Windows.Forms.DataGridColumnStyle' does not contain a definition for 'FalseValue'
Using dotnet 1.1. Anyone know how to solve this?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
