MySharpSQL 1.1

MySharpSQL 1.1 is a FREE fully functional program that uses MySQL which is designed to meet all your needs of 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.

Major Features:

1. Chapter 1: MySQL Server, SQLyog and Connector/Net 1.0
   
   • Download and Install the MySQL Server
   • Starting and Stopping the MySQL Server
   • Download and Install SQLyog
   • Download Connector/Net 1.0
   • How to Understand Connector/Net 1.0
   
   
2. Chapter 2: MySharpSQL: Beginning Project Work
   
   • Create MySharpSQL Project Starter Files
   • Copy MySQL .NET Files into the Project Folder
   • Add a Reference to MySql.Data.dll
   • Set the MySharpSQL Main Form Properties
   • Create Login and Logout Controls in Main Form
   • Create a New Database Using SQLyog
   
   
3. Chapter 3: MySharpSQL Database Table Creation
   
   • Connect to a MySQL Server and Database
   • Disconnect from a MySQL Server and Database
   • Define the MySharpSQL Database Table
   • Create the MySharpSQL Database Table
   • Modify the MySharpSQL Main Form
   
   
4. Chapter 4: Building the MySharpSQL Alpha Version
   
   • Create Function to Save New Data
   • Create Function to Load the Listbox with Topics
   • Create Function to Handle Double-Clicks on Listbox Item
   • Create Function to Update Data
   • Create Function to Delete Data
   • Create Function to Exit Program
   • Create Function to Search for Data
   • Create Function to Display Help File
   
   
5. Chapter 5: MySharpSQL Alpha Testing and Program Refinements
   
   • Enable and Disable Dialog Controls
   • Enhance Program Error Handling
   • Guide User Actions on Dialog Controls
   • Validate Data Input and Display Errors
   
   
6. Chapter 6: MySharpSQL Second Phase Alpha Testing and Documentation
   
   • Data Entry of Sample Data and Second Phase Alpha Testing
   • Refine the Comments in the Source Codes
   • Prepare the HTML Help File
   • Prepare the MySharpSQL Quick Start Guide
   
   
7. Chapter 7: Prepare MySharpSQL Beta Version for Release
   
   • Why and How to Obfuscate MySharpSQL
   • How to Pack the MySharpSQL Executables
   • How to Create a Program Installer
   • How to Release and Distribute a Program
   • How to Control Program Revisions and Maintenance

Requirements:.Net runtime version 1.1 or later

WareSeeker Editor