XML Database In C# - CodeProject

Download source - 155.92 KB

Introduction

This is a small application which stores the data in the form of XML and can be easily retrieved, inserted and deleted by using the ID.

Using the Code

Here is the code. You can use this application.

The code is not very difficult, I wrote it in less than 2 hours, whether or not you believe it.

// Insertion
         private void btnInsert_Click_1(object sender, EventArgs e)
        {
            if (txtBoxID.Text == "")
            {
                MessageBox.Show("Insert ID please");
                return;
            }

            XmlWriterSettings st = new XmlWriterSettings();
            st.Indent = true; ;

            st.OmitXmlDeclaration = true;
            st.Encoding = Encoding.ASCII;
            string path = @"ContactsDB\" + txtBoxID.Text.ToString() + ".xml";

            using (XmlWriter writer = XmlWriter.Create(path, st))
            {
                writer.WriteComment("This xml file for ID " + txtBoxID.Text + ".");
                writer.WriteStartElement("Contact");
                writer.WriteStartElement(lblID.Text);
                writer.WriteStartAttribute(lblID.Text);
                writer.WriteValue(txtBoxID.Text);
                writer.WriteEndAttribute();
                writer.WriteEndElement();


                writer.WriteStartElement(lblName.Text);
                writer.WriteStartAttribute(lblName.Text);
                writer.WriteValue(txtBoxName.Text);
                writer.WriteEndAttribute();
                writer.WriteEndElement();

                writer.WriteStartElement(lblFName.Text);
                writer.WriteStartAttribute(lblFName.Text);
                writer.WriteValue(txtBoxFname.Text);
                writer.WriteEndAttribute();
                writer.WriteEndElement();

                writer.WriteStartElement(lblAdd.Text);
                writer.WriteStartAttribute(lblAdd.Text);
                writer.WriteValue(txtBoxAddress.Text);
                writer.WriteEndAttribute();
                writer.WriteEndElement();

                writer.WriteStartElement(lblEmail.Text);
                writer.WriteStartAttribute(lblEmail.Text);
                writer.WriteValue(txtBoxEmail.Text);
                writer.WriteEndAttribute();
                writer.WriteEndElement();

                writer.WriteStartElement(lblMob.Text);
                writer.WriteStartAttribute(lblMob.Text);
                writer.WriteValue(txtBoxMobile.Text);
                writer.WriteEndAttribute();
                writer.WriteEndElement();

                writer.WriteStartElement(lblHome.Text);
                writer.WriteStartAttribute(lblHome.Text);
                writer.WriteValue(txtBoxHome.Text);
                writer.WriteEndAttribute();
                writer.WriteEndElement();
                writer.Flush();
                MessageBox.Show("DataBase Entry Successful!!");
                clearTxtBox();
                btnClearInsert.Enabled = true;
            }
            btnUpdate.Enabled = false;
        } 
           
// Deletion
             private void button2_Click_1(object sender, EventArgs e)
        {
            try
            {
                if (txtDel.Text == "")
                {
                    MessageBox.Show("Insert ID please");
                    return;
                }
                string path = @"ContactsDB\" + txtDel.Text.ToString() + ".xml";
                File.Delete(path);
                MessageBox.Show("record for ID:" + txtDel.Text + " is deleted");
                txtDel.Text = "";
            }
            catch (Exception f)
            {
                MessageBox.Show("The desired record is not available");
            }
        }
        
//Search
        private void btnProcess_Click(object sender, EventArgs e)
        {
            try
            {
                string path = @"ContactsDB\" + txtQuery.Text.ToString() + ".xml";
                XmlDocument document = new XmlDocument();
                document.Load(path);
                XmlNode node = document.SelectSingleNode(@"//*");
                rtbResults.Text = node.OuterXml.ToString();
                btnUpdate.Enabled = true;
            }
            catch (Exception f)
            {
                MessageBox.Show("ID:" + txtQuery.Text + " not found");
                txtQuery.Text = "";
                rtbResults.Text = "";
            }
        }