MySharpCode version 1.1 - Easy Way to Use SQLite with C#

Learn from the step by step commented C# example program
that shows how to use SQLite for keeping a database of C# code snippets.

 
small screenshot

View large screenshot of program's main dialog.

Welcome,  

Would you like to create your own embedded database application in Visual C# using SQLite and its ADO .NET Data Provider?

What is SQLite? From its website at http://www.sqlite.org/, "SQLite is small a C library that implements a self-contained, embeddable, zero-configuration SQL database engine."

In the .NET-framework, you can use the FREE i.e. BSD Licensed, Finisar.SQLite, an ADO.NET Data Provider for SQLite to access SQLite databases.

MySharpCode is a FREE fully functional demo program that uses SQLite for keeping a database of C# code snippets. The SQLite database that comes with the demo program contains some C# code snippets from the program's C# source codes.

The program functions implemented in this fully functional demo program are: load records topic in a listbox, gets user selection from the listbox and displays the record details in a set of editboxes. 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 the 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 SQLite databases. Both SQLite version 2 and version 3 databases are supported.

MySharpCode C# Example Source Codes Package 

Here's what you'll learn from the C# source codes in this package:

  1. use listboxes: load items, get items selected and clear the listbox;
  2. use editboxes: fill them with data and clears them;
  3. use command buttons to control program processes;
  4. create a new SQLite database and table;
  5. create, open and close a connection to a SQLite database;
  6. create a non-query SQL command and execute it;
  7. create a SQL query, execute it and retrieves the results set;
  8. avoid and overcome apostrophe problems in SQL queries;
  9. construct proper SQL strings with program variables;
  10. implement SQL search, including search for partial strings;
  11. loop through a result set and use the data for further processing;
  12. change the cursor type from default arrow to hourglass and back to default;
  13. use control variables to flag processing status;
  14. use try and catch block to handle potential program errors;
  15. use message dialogs to report program errors; and
  16. use HTML help files.


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

SPECIAL OFFER: For a limited time only, this Example Source Code Package retails for only $50 (U.S. dollars). Regular price was 75 U.S. dollars. Full source codes - 1.86 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 $50 for full source codes. 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

Now only $50 (U.S. dollars)

Full source codes - 1.86 MB.

Download    FREE Download demo program from main site. (zip file size 459 KB)    


 The fully functional demo program is in a zip file.


About the FREE MySharpCode Program
The FREE fully functional demo program shows how to use SQLite to keep a database of C# code snippets.

 



 
 
System Requirements

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

 
Awards



5 Stars Award

5/5 Stars

MySharpCode on Core Download

MySharpCode software



































































Related Product

C++ ebook: Using SQLite with Visual C++. Learn how to use SQLite with MFC.






 

Hot
SPECIAL OFFER - Order the source codes for only $50. 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 March 23, 2009
 

Copyright © 2005, 2006, 2007, 2008, 2009 by Yeoh HS, All Rights Reserved