MySharpCode description
A step by step commented C Sharp example program that uses SQLite

MySharpCode is a FREE fully functional demo application that uses SQLite in orde to keep 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.

Here are some key features of "MySharpCode":

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


Requirements:

· .NET framework runtime version 1.1 or later