This is my first article about my very first C# Study application. While I was reading books and watching videos, I thought to create something that I would also use, nothing fancy, simple to use. This application can be used for notes as well, not only for codes. The code itself, not the application and its functionality, is the most important part, and will be the main part of my following articles (if I am approved by you... the readers)

Background

I started this code using Access DB. Then I purchased a laptop that came with 64bit Win7 OS. This is my first 64 bit machine and didn't know how my code would react. Apparently there are some issues with MS Jet engine vs 64 bit systems. Even though I found out some fixes and fix-around, I decided to move on to the other things. I tried SQL Express... Very powerful database, I love SQL. I used SQL servers for my previous applications (not in C#), and I love it. Although, I wanted this program to be very light and very "portable + Sharable" without any pain (or less pain). So, Instead of using a "Home-made" text based DB, I decided to use XML. This way if someone wants to transfer XML into another database, would be able to do so easily. This is my first time dealing with XML, and I enjoyed a lot.

Using the code

There are two forms and two custom classes for this program.

Form1 (Main form)

Form Settings

IO class

XML class

Application lets you create a new XML file with three fields (ID, Code subject and main code) for its database, or locate an existing one. So, if multiple users are using different databases, they can share their XML files, also one can be shared between applications throughout the office or home. I didn't put any restrictions, such as log-ins and/or user levels to make changes. Maybe some of you want to add an option to give user the flexibility of creating as much as fields they want for their own purposes as well... all those things can be added into this code. Sky is the limit :)

Since the entire code is available for download, I would like to show a few methods/codes here that I like because of their work.

Tooltip setup: I use "_toolTip" class almost all my "form load" methods to show control tips for my users. Simple, but since this is a beginners article, I thought maybe some of you just might missed it. There is also "#region" "#endregion" usage here. It's a very nice tool to pack some of your codes out of the way.

#region ToolTips// Set some tooltips here_toolTip.SetToolTip(btnCopy, "Copy to ClipBoard");_toolTip.SetToolTip(btnNew, "Add new code with this subject");_toolTip.SetToolTip(btnExit, "Exit program");_toolTip.SetToolTip(lstSubjects, "Click to see the code");_toolTip.SetToolTip(chkOnTop, "Check to keep this window top of all windows");_toolTip.SetToolTip(btnSearch, "Search DB");_toolTip.SetToolTip(txtCodeMain, "Double Click to copy code into clipboard");#endregion

Resizing and positioning the form: Even there is "StartPosition" property for Windows forms, I still use following code to adjust my form size using current screen bounds. // Resize the form using current screen sizethis.Width = Screen.PrimaryScreen.Bounds.Width / 2;this.Height = Screen.PrimaryScreen.Bounds.Height - 300;

I use "Split" a lot in my codes. Sometimes it is much easer to pass information throughout classes and methods. Split also a "cheap" way to pass field information, I believe it does take less memory than arrays. Finding the right character is the thing, which I used "backspace" character here, since it can't be passed through a textbox.XMLDatabase clsXML = new XMLDatabase(); // Create instance of XMLDatabase classArrayList CurrentSubjectList = new ArrayList(); // Create instance of ArrayList// This will loaded with the ArrayList// sent by clsXML objectstring[] SplitText = newstring[2]; // Each item in the array will contain a tring// that will be splited by 'Backspace' characterCurrentSubjectList = clsXML.GetSubjectList(clsIO.XMLPath, SearchWord); // Get the ArrayList from clsXMLchar Splitchr = (char)8; // 'char 8' is Backspace character.foreach (string FullString in CurrentSubjectList) // Start looping the ArrayList{SplitText = FullString.Split(Splitchr); // Split ItemListViewItem s_Items; // Set ListView item to add new informations_Items = lstSubjects.Items.Add(SplitText[0]); // Add Subject ID to the first (not visiable) colomns_Items.SubItems.Add(SplitText[1]); // Add Subjectname to second (visiable) colomn}

ListView control one of my favorite controls (above). When used with "Details" mode, it can be very nice tool to show items for my database fields. I don't like bounding data, so everything is dynamically coded to fill ListView control... even when I use SQL or Access database. No bounding... I hate bounding things to my application. Application must be totally free of ties between any data source, and connection should be done after program runs, when needed... (totally personal).

I probably won't repeat all this "simple" information for my next articles, but they're extremely useful things which some of you might be missing.

There might be another way to edit a nod information, although this looks pretty good and works just fine for me. All I am doing here is to loop XML nodes and search for ID field for the ID I'm passing. If match found, change selected field information with the new one.XmlDocument XMLEdit = newXmlDocument();XMLEdit.Load(XMLPath);XmlElement XMLEditNode = XMLEdit.DocumentElement;foreach (XmlNode node in XMLEditNode) // Loop through XML file{if (node["ID"].InnerText == SubjectID) // Check for the ID field information{node["DBCode"].InnerText = CodeMain;break;}}XMLEdit.Save(XMLPath);

Deleting portion of the XML file is done as follows. Just like above code, I am looking for the ID field. If I find it, I only delete the parent node that ID field and other children fields located. I probably could merge those two loops into one, but for learning purposes, this is ok. You're always welcome to do your own merging. That could save you writing extra lines of codes.XmlDocument XMLDelete = newXmlDocument();XMLDelete.Load(XMLPath);XmlElement XMLDeleteNode = XMLDelete.DocumentElement;foreach (XmlNode node in XMLDeleteNode){if (node["ID"].InnerText == SubjectID) // Find the match for the ID field{node.ParentNode.RemoveChild(node); // Delete the parent for the children (fields)break;}}XMLDelete.Save(XMLPath);

Getting a field information (node) from XML file, and throwing exception. I included a bit more code here to show how I used the Try/Catch and Exception thrower. When exception is throwing like this, it comes back to the "sender" (I like to call it that way, it's actually sending exception back to the method which class was initiated). Same as other three codes, I loop through the XML until I find my ID.XmlDocument XMLRead = newXmlDocument(); // Create instance of XmlDocument classtry{XMLRead.Load(XMLPath); // Set XMLRead object's path valueXmlNodeList XMLItems = XMLRead.SelectNodes("Codes/NewCode"); // Create instance of XmlNodeList class// and set its node valueforeach (XmlNode node in XMLItems) // Loop Node for the child node items{if (node["ID"].InnerText == SubjectID) // Find the ID number{StrInf = node["DBCode"].InnerText; // Set return value to Main Code value from the XML filebreak; // Exit loop}}return StrInf;}catch (Exception exc){throw exc;}

By the way, the ID field always grows to higher numbers even if anything deleted from XML file. I could (and easy to do) find the missing number and assign that for the next ID (for example, I have data from ID number 1 through 40... and I deleted number 23. So there is a gap now. Next time when I enter a new data, I could just find number 23 and assign my ID to it). I like the way it is though. To get the latest number, I have another loop that reads the ID field only and adds "1".publicstring GetLatestID(string xmlFilePath){int LastIDEntry = 0;XmlDocument XMLGetLastID = newXmlDocument();XMLGetLastID.Load(xmlFilePath);XmlNodeList XMLItems = XMLGetLastID.SelectNodes("Codes/NewCode");foreach (XmlNode node in XMLItems){LastIDEntry = Convert.ToInt32(node["ID"].InnerText) + 1;}returnConvert.ToString(LastIDEntry);}

I know there are probably better ways than looping through XML files, which could slow things down when file gets larger, and I need your help to find them (if any).

Points of Interest

This code is for C# beginners (like myself). I love coding and enjoy any challenges come with it. I research a lot to learn (even at my age) a lot. These days internet is my only source (99.90% of the time) to do researches for C#. Hopefully some of you will copy/paste and use some of my codes here. I like to modify the codes I find to fit my code, which probably the best way to learn (next to watching C# videos). I hope to see you at my next article "Study II" :)