05.01.2004 : NetDbExplorer : Demo for mj10777.DataBase Class
Compact / Desktop .EXE and Help File |
NetDbExplorer_src.zip 1.074 KB |
Desktop .EXE and needed .DLL for Access .mdb Creation |
NetDbExplorer_demo.zip 59 KB |
mj10777.DataBase is a Class Collection for Database support under .NET Framework / .Net Framework.Compact
For private use your are free to do what you want with this Source, otherwise please note the Copyright notice and the end of this article.
The Source is highly Documentated, therefore this article will remain short (see note on Documentation below)
NetDbExplorer_src.zip has 2 Zips inside, one for PC and one for Compact
NetDbExplorer_demo.zip has a PC Exe for free use
(Compact Exe is included in NetDbExplorer_src.zip)
Beware : I used a different directory for my Projects (Microsoft.Net and Microsoft.Net.Compact) - the directory inside the Zip have the same name !
This may also be considered as a way to write a Project that will run on both Platforms.
The Directory \DataBase\*.* from the PC Project can be (and was) copied (often) to the Compact Project and back (also)
A precompiler directive "COMPACT" is used in the Compact project Configuration to write Code for both Platforms in one .cs file with no warnings/errors from the compiler. (not true of course if you forget to set ....)
See Documentation on how to do this.
Having written a Class (with George Tasker - Remstar) for wxWindows (http://www.wxwindows.org/) to analyse a Database with Table/Field Structures (wxDB/wxTable), I was unhappy about the mess Visual Studio made and all the work that had to be done with each Table.
However after a carefull study of DataSet / DataTable / DataView and DataRow I was very pleased with what had been achived in .NET Framework.The result and use is very similar to what we did under ODBC with wxWindows (I wrote the wxWindows/demos/dbbrowse, that does the same thing as NetDbExplorer).
Still all these Connection Strings and Engine Types had to be worked out, since a friend of mine did not know if he wanted to switch from dBase to Access or Excel. The result was my first NET Project called DbBrowser (Google : Searched the web for dbbrowser. Results 1 - 10 of about 4,470. Search took 0.17 seconds) which put all the Connection Strings / Engine Type's in one Class.
At first I wrote a class each for Odbc and OleDb since Odbc was not really needed.
Then came Visual Studio 2003 and SqlCe for Compact and with it the beauty of NTEXT as apposed to VARCHAR (at least UNSIGNEDTINYINT is now TINYINT), so I wrote an extra Class for this.
Being feed up with all of this, I started write a Card Playing logic for Games and started to learn the Documenting System as I went along.
The result of this was my article about Language Support also published here just before Christmas.
The next move was of course to Document the Odbc/OleDb/SqlCe Classes - but to do this 3 times was out of the question.
It was much easier to put them all togeather in one DataBase.cs that used a "ServerType" Parameter (Odbc,OleDb,SqlCe/SqlServer) and compile on both PC and Compact Platforms (Documenting everything while doing this). 4 hours before Silvester / New Year everything was compleated and worked. What I did then you can imagine.
The major goals of this Class are :
the simple use of this Class to Connect, Create (Database/Table), Read and Fill Tables, Update, Insert and Delete Records.
OleDb and SqlCe does not have a direct way to read all Tables found in the DataSet.
Using "SELECT * FROM INFORMATION_SCHEMA.TABLES" this class will collect the names of the existing Tables on Connection and fill the DataSet with these Tables when read :
private const string s_DataSetNamespace = "MainFrame";
private const string s_mj10777_Company = "mj10777.de.eu";
private const string s_mj10777_Folder = "\\My Documents\\"+s_mj10777_Company+"\\";
private const string s_DocumentFolder = s_mj10777_Folder+s_DataSetNamespace+"\\";
private int ip_EngineType = 5; // 5= Access ;ServerType=1 : OleDb
private DataBase db_DataBase = null;
public FormMainFrame()
{
InitializeComponent();
i_Language = 1; // Call Method to create sa_CreateTables, if needed
db_DataBase = new(DataBases_DocumentFolder,s_DataSetNamespace,ip_EngineType,1,ip_Language);
dset_MainFrame = db_Table.OnReadDBtoDataSet(); // Connects to Database and Disconnectd after reading
//DataSet now has all Tables found in the DataBase
// Save Access Database as Excel File
db_Table.i_EngineType = 24; // (Excel 8.0 and 9.0 Workbooks)
// Connects to Database and Disconnectd after writing
db_Table.OnCreateDBfromDataSet(dset_MainFrame,true);
} // public FormMainFrame()
The need to test this for PC and Compact lead to the creation of :
The major Goals of this Demo are :
- testing mj10777.DataBase.DataBase Class
- tool for analysing Databases on PC and Compact for Framework Development
(thus System.String, System.Int32 etc)
The major Function of this Demo are :
- read and writing Databases without User/Password protection
- tool to Change Dataset / Table / Field names
The .cs file's are highly Documented for the use of Programers which wish to use these Classes.
An nDoc Configuration File and the resulting Help file has been included in the Zip files.
Each Class has a full description in the Class Overview of what was indended to achive.
Here there are many References to the Class Methods with Code examples of the use of these Classes and the general use of DataSet, DataTable, DataView and DataRow.
The idea was to generate one Help file with all the collected Information pertaining to ODBC, OleDb, SqlCe and certain programming technics developed in the last 6 Months.
Also certain aspects of the .NET Framework that I find interesting have been build in to this Help file.
I have attemted to make full use of the XML-Documentation offered by the Visual-Studio to build one source of what, where and how things are done (Not to mention : "what was I thinking abut when I did that?").
Known problems, things that do not work and hopes for the future development are also noted.
Please send me an EMail if something does not work and needs fixing (with a Sample of the Database where possible)
Please send me an EMail if would like Functionality to be added
Condition for free suport is of course that this is for private use (See Copywrite below)
No support can be given if the Copyright of other Products are not respected!.
If somebody changes these Classes to support other Systems (Sql-Server on PC for one), please send me the changes.
All general changes will be re-published here
E-Mail : mj10777@mj10777.de
none as of yet
Mark Johnson - Berlin, Germany
05.01.2004
