MySharpSQL version 1.1
"Easy Way to Use MySQL with C#"

Learn from the eBook and step by step commented C# source codes
the easy way to code MySQL client programs in C#.

 

MySharpSQL small screenshot

View large screenshot of program's main dialog.

Welcome,  

Would you like to create your own database client applications in C# using MySQL and its ADO .NET Data Provider?

MySharpSQL is a FREE fully functional program that uses MySQL for keeping a database of programming notes. The MySQL database that comes with the program contains relevant and specially selected MySQL, ADO.NET and C# programming resources.

Program functions implemented in this fully functional program are: load records topic in a listbox, gets user selection from the listbox and displays the record details in a set of textboxes. The command buttons allow the user to clear and reload the listbox, save a new record or an edited record, delete existing records, display the program's help file, close the program and search for keywords in the records.

The registered version of this package contains an eBook with step-by-step fully commented source codes for a complete Visual C# program that shows you how to create your own C# program and use an ADO.NET Data Provider to access MySQL databases. Both MySQL version 4.x and version 5.x databases are supported.

MySharpSQL eBook Table of Contents 

Introduction

Chapter 1: MySQL Server, SQLyog and Connector/Net 1.0
1.1 Download and Install the MySQL Server
1.2 Starting and Stopping the MySQL Server
1.3 Download and Install SQLyog
1.4 Download Connector/Net 1.0
1.5 How to Understand Connector/Net 1.0

Chapter 2: MySharpSQL: Beginning Project Work
2.1 Create MySharpSQL Project Starter Files
2.2 Copy MySQL .NET Files into the Project Folder
2.3 Add a Reference to MySql.Data.dll
2.4 Set the MySharpSQL Main Form Properties
2.5 Create Login and Logout Controls in Main Form
2.6 Create a New Database Using SQLyog

Chapter 3: MySharpSQL Database Table Creation
3.1 Connect to a MySQL Server and Database
3.2 Disconnect from a MySQL Server and Database
3.3 Define the MySharpSQL Database Table
3.4 Create the MySharpSQL Database Table
3.5 Modify the MySharpSQL Main Form

Chapter 4: Building the MySharpSQL Alpha Version
4.1 Create Function to Save New Data
4.2 Create Function to Load the Listbox with Topics
4.3 Create Function to Handle Double-Clicks on Listbox Item
4.4 Create Function to Update Data
4.5 Create Function to Delete Data
4.6 Create Function to Exit Program
4.7 Create Function to Search for Data
4.8 Create Function to Display Help File

Chapter 5: MySharpSQL Alpha Testing and Program Refinements
5.1 Enable and Disable Dialog Controls
5.2 Enhance Program Error Handling
5.3 Guide User Actions on Dialog Controls
5.4 Validate Data Input and Display Errors

Chapter 6: MySharpSQL Second Phase Alpha Testing and Documentation
6.1 Data Entry of Sample Data and Second Phase Alpha Testing
6.2 Refine the Comments in the Source Codes
6.3 Prepare the HTML Help File
6.4 Prepare the MySharpSQL Quick Start Guide

Chapter 7: Prepare MySharpSQL Beta Version for Release
7.1 Why and How to Obfuscate MySharpSQL
7.2 How to Pack the MySharpSQL Executables
7.3 How to Create a Program Installer
7.4 How to Release and Distribute a Program
7.5 How to Control Program Revisions and Maintenance

Appendix A: Selected List of URL Resources
Appendix B: About this Ebook’s Example Source Codes
1. Feedback Welcomed
2. Features in Future Versions
3. Where to Download the Latest Version
4. Revision History

 

FREE UPGRADE for registered buyers: Download the next version for free when it is released.

SPECIAL OFFER: For a limited time only, this eBook and Example Source Code Package retails for only $24.95 (Usual price $34.95) (Price is in U.S. dollars). Full source codes - 1.73 MB.

BONUS for registered buyers:  For a limited time only!

You will also get to download two additional versions of this program that you can compile using Visual C# 2005 Express edition and SharpDevelop. 

Order easily online using your credit card through our Secure Online Ordering System

We accept major credit cards: Mastercard, VISA, Discover and American Express.

Main Secure Online Ordering Site at eSellerate

Buy Now Click Here to Order Now

Only $24.95 (Usual price $34.95) Price is in U.S. dollars.


About the Author

Yeoh HS first began programming personal computers in 1987 while working as an auditor. He has a background in accounting and information systems auditing. It wasn't long before he realized his true calling in life. Since then, he had focused on contract programming jobs and now runs his own IT consulting firm based in Penang, Malaysia.

Contact Information

Yeoh HS can be contacted at author@yeohhs.com
Mailing Address:17-3-1 Lorong Batu Bukit Dua, Tanjong Tokong, 10470 Penang, Malaysia.
Telephone:+6012-5357595


 
 
Buy Now
  Click Here to Order Now

Only $24.95 (U.S. dollars)

Full source codes and ebook - 1.73 MB.

Download    FREE Download  program and sample eBook from main site. (zip file size 299 KB)    


 The fully functional program and a sample eBook is in a zip file.


About the FREE MySharpSQL Program
The FREE fully functional C# program shows how to use MySQL to keep a database of programming notes. Also included is a sample eBook.

 



 
 
System Requirements

This program requires Microsoft .NET runtime version 1.1 or later. Click here to download it from Microsoft's website.

 
Awards

5 STAR AWARD

MySharpSQL software

Ivertech 5 Stars Award

5 Stars Award at SoftsLand

5 Stars Award

5 Star Editor's Pick
































































































Related Products

MyBooks, a MFC MySQL Client source codes. Easy way to learn how to use the MySQL C API with MFC.

MyNotes, a MFC MySQL++ Client source codes. Easy way to learn how to use MySQL++ with MFC.


 

Hot
SPECIAL OFFER - Order the source codes for only $24.95. Price is in U.S. dollars.

 

Guarantee

60-DAY GUARANTEE WORLDWIDE This example source code package is backed by a 60-day money back un-conditional guarantee.

 



Buy Now
Click Here to Order Now

Order easily online using your credit card through our Secure Online Ordering System

We accept major credit cards: Mastercard, VISA, Discover and, American Express.

Delivery: via download from our web site.


 
  Last updated on October 10, 2007
 

Copyright © 2006, 2007 by Yeoh HS, All Rights Reserved