xml data insert update

This article is shows about insert data into XML file instead of using SqlServer database.

For that first Design your form as per your requirements.

In this am adding daily expenses of a person for that am taking fields as Date,  Amount, Purpose, Source  Bank and one Save button like below:

For accessing XML file add the following namespace in top of your code:

                         using System.Xml;

Write the following code in your Save button Click:

private void btnsave_Click(object sender, EventArgs e)

        {

            string path = "Expences.xml";

            XmlDocument doc = new XmlDocument();

            //If there is no current file, then create a new one

            if (!System.IO.File.Exists(path))

            {

                //Create neccessary nodes

                XmlDeclaration declaration = doc.CreateXmlDeclaration("1.0", "UTF-8", "yes");

                XmlComment comment = doc.CreateComment("This is an XML Generated File");

                doc.AppendChild(declaration);

                doc.AppendChild(comment);

            }

            else //If there is already a file

            {

                //    //Load the XML File

                doc.Load(path);

            }

            //Get the root element

            XmlElement root = doc.DocumentElement;

            XmlElement Subroot = doc.CreateElement("Expences");

            XmlElement Date = doc.CreateElement("Date");

            XmlElement Amount = doc.CreateElement("Amount");

            XmlElement Purpose = doc.CreateElement("purpose");

            XmlElement Source = doc.CreateElement("Source");

            XmlElement Bank = doc.CreateElement("Bank");

            //Add the values for each nodes

            Date.InnerText = Convert.ToDateTime(dateTimePicker1.Text).ToShortDateString();

            Amount.InnerText = txtAmount.Text;

            Purpose.InnerText = txtPurpose.Text;

            if (radioButton1.Checked)

            {

                Source.InnerText = "Cash";

                Bank.InnerText = " ";

            }

            else

            {

                Source.InnerText = "Bank";

                Bank.InnerText = comboBox1.SelectedItem.ToString();

            }

           

            Subroot.AppendChild(Date);

            Subroot.AppendChild(Amount);

            Subroot.AppendChild(Purpose);

            Subroot.AppendChild(Source);

            Subroot.AppendChild(Bank);

            root.AppendChild(Subroot);

            doc.AppendChild(root);

            //Save the document

            doc.Save(path);

            //Show confirmation message

            MessageBox.Show("Details  added Successfully");

            //Reset text fields for new input

            txtPurpose.Text = String.Empty;

            txtAmount.Text = String.Empty;

        }

       

      Then run your application and see output like below:

To see your saving data in XML file do the following steps:

Select your solution from Solution Explorer

Right click and Select Open Folder in Windows Explorer

Then your application folder will open in that double click on bin folder  then double click debug folder

Then you will see your Expenses XML document file à double click on it then you will see your Saving Data in your browser like below:

Retrieve data from XML file and show in DataGridview :

For showing these saving data into DataGridview, am taking one Show button and DataGridview Control in the form:

Write the following code in show button click:

     private void btnShow_Click(object sender, EventArgs e)

        {

                XmlReader xmlFile;

                xmlFile = XmlReader.Create("Expences.xml", new XmlReaderSettings());

                DataSet ds = new DataSet();

                ds.ReadXml(xmlFile);

                dataGridView1.DataSource = ds.Tables[0];

            }

Then you will see your data binding to DataGridview like below:

save xml format in c#

To show XML data into DataGridView , First am designing one form with some fields , one Save button and one DataGridView Control.

The Designed form is :

In this article am showing following steps:

1. Save data into XML file .
2. Retrieve data from XML file and bind that data to DataGridview.
3. Add two EDIT and DELETE columns to DataGridView.
4. Write edit,delete coding in dataGridView1_CellContentDoubleClick.

Save data into XML file:

For using XML add the following namespace:

                  using System.Xml;

Write the following code in Save button Click:

private void btnSave_Click(object sender, EventArgs e)

        {

       

                  string path = "AccountDetails.xml";

                XmlDocument doc = new XmlDocument();

                ////If there is no current file, then create a new one

                if (!System.IO.File.Exists(path))

                {

                    //Create neccessary nodes

                    XmlDeclaration declaration = doc.CreateXmlDeclaration("1.0", "UTF-8", "yes");

                    XmlComment comment = doc.CreateComment("This is an XML Generated File");

}

                else //If there is already a file

                {

                    //    //Load the XML File

                    doc.Load(path);

}

                    //Get the root element

                    XmlElement root = doc.CreateElement("BankAccount_Details");

                    XmlElement Subroot = doc.CreateElement("BankAccount");

                    XmlElement BankName = doc.CreateElement("BankName");

                    XmlElement AccountNumber = doc.CreateElement("AccountNumber");

                    XmlElement BankType = doc.CreateElement("BankType");

                    XmlElement Balance = doc.CreateElement("Balance");

                    //Add the values for each nodes

                    BankName.InnerText = comboBox1.SelectedItem.ToString();

                    AccountNumber.InnerText = txtAccNumber.Text;

                    if (rbtnCurrent.Checked)

                        BankType.InnerText = rbtnCurrent.Text;

                    else if (rbtnSaving.Checked)

                        BankType.InnerText = rbtnSaving.Text;

                    else

                        BankType.InnerText = rbtnOther.Text;

                    Balance.InnerText = txtBalance.Text;

                    //Construct the document

                    doc.AppendChild(declaration);

                    doc.AppendChild(comment);

                    doc.AppendChild(root);

                    root.AppendChild(Subroot);

                    Subroot.AppendChild(BankName);

                    Subroot.AppendChild(AccountNumber);

                    Subroot.AppendChild(BankType);

                    Subroot.AppendChild(Balance);

                    doc.Save(path);

                //Show  message

                MessageBox.Show("Records added Successfully");

                //Reset text fields for new input

                txtBalance.Text = String.Empty;

                txtAccNumber.Text = String.Empty;

                comboBox1.SelectedIndex = 0;

                                //To show added record in Gridview call LoadGrid() method which I show below

LoadGrid();

}

Retrieve data from XML file and bind  to DataGridview:

For  retrieve XML data  and bind to Gridview call the following method:

protected void LoadGrid()

        {

            DataSet xmlds = new DataSet();

            string path = "AccountDetails.xml";

            if (System.IO.File.Exists(path))

            {

                xmlds.ReadXml(path);

                if (xmlds.Tables.Count > 0)

                {

                    dataGridView1.DataSource = xmlds.Tables[0].DefaultView;

                   

                }

            }

       

        }

Call the above method in form page load also

private void Account_Details_Load(object sender, EventArgs e)

        {

            LoadGrid();

        }

       

Add  EDIT and DELETE columns to DataGridView:

For Editing and Deleting add two columns to DataGridView with Suitable Images. I am adding Delete Image in 1^st  column and Edit in 2^nd column.

For deleting and editing am taking account number as a parameter.

write the following code in dataGridView1_CellContentDoubleClick event:

private void dataGridView1_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)

        {

            if (e.RowIndex != -1)

            {

              

//For Deleting following code

                if (e.ColumnIndex == 0)

                {

                    DataGridViewRow row = dataGridView1.Rows[e.RowIndex];

                    string acnum = row.Cells[3].Value.ToString();

                    string path = "AccountDetails.xml";

                    XmlDocument doc = new XmlDocument();

                    doc.Load(path);

                    XmlNode node = doc.SelectSingleNode("/BankAccount_Details/BankAccount[AccountNumber='" + acnum + "']");

                    node.ParentNode.RemoveChild(node);

                    doc.Save(path);

                    MessageBox.Show("Selected Record Deleted Successfully");

                }  

                  

          

          //For Editing following code

                if (e.ColumnIndex == 1)

                {

                    DataGridViewRow row = dataGridView1.Rows[e.RowIndex];

                    int acnum = Convert.ToInt32(row.Cells[3].Value);

                    string path = "AccountDetails.xml";

                    XmlDocument doc = new XmlDocument();

                    doc.Load(path);

                    XmlNode node = doc.SelectSingleNode("/BankAccount_Details/BankAccount[AccountNumber='" + acnum + "']");

                    node.ParentNode.RemoveChild(node);

                    doc.Save(path);

                  

                    

                    ////If there is no current file, then create a new one

                    if (!System.IO.File.Exists(path))

                    {

                        //Create neccessary nodes

                         XmlDeclaration declaration  = doc.CreateXmlDeclaration("1.0", "UTF-8", "yes");

                     XmlComment comment = doc.CreateComment("This is an XML Generated File");

                       

                        doc.AppendChild(declaration);

                        doc.AppendChild(comment);

                    }

    //If there is already a file

                         else 

                        {

                        //    //Load the XML File

                        doc.Load(path);

                        }

                        XmlElement root = doc.CreateElement("BankAccount_Details");

                        XmlElement Subroot = doc.CreateElement("BankAccount");

                        XmlElement BankName = doc.CreateElement("BankName");

                        XmlElement AccountNumber = doc.CreateElement("AccountNumber");

                        XmlElement BankType = doc.CreateElement("BankType");

                        XmlElement Balance = doc.CreateElement("Balance");

                        //Add the values for each nodes

                        BankName.InnerText = row.Cells[2].ToString();

                        AccountNumber.InnerText = row.Cells[3].ToString();

                        BankType.InnerText = row.Cells[4].ToString();

                        Balance.InnerText = row.Cells[5].ToString();

                        //Construct the document

                        doc.AppendChild(root);

                        root.AppendChild(Subroot);

                        Subroot.AppendChild(BankName);

                        Subroot.AppendChild(AccountNumber);

                        Subroot.AppendChild(BankType);

                        Subroot.AppendChild(Balance);

                        doc.Save(path);

                        MessageBox.Show("Selected Record Edited Successfully");

                    }

                                        

                                         LoadGrid();                

                }

                   

           

                  

                }

       

Then run your application and see output :

Industrial Training in jaipur for MCA or btech student : Chipsoul Web Solution

message box , alert box in c#

To show alert MessageBox in Windows forms:

            MessageBox.Show("Welcome to DotNet");

To show Confirm MessageBox with Yes No buttons in Windows forms:

             DialogResult result;

            result = MessageBox.Show("Are You sure want to Delete?", "Conformation",  MessageBoxButtons.YesNo);

            if (result == System.Windows.Forms.DialogResult.Yes)

            {

                MessageBox.Show("Records Deleted Successfully");

            }

            else

            {

                MessageBox.Show("No action");

            }

                     

                   

From second message box if you click Yes :

If you click No :    

Live training jaipur

how to change image mousehover

To change image and cursor when mousehover and mouseleave in windows forms  dotnet application follow the below steps:

1.First design one test form with one button name as btnIncome.

2. Change button properties and import two images (mousehover image and mouseleave image) from your system.

In this I am taking two income images with the name income_btn_hover and income_btn_normal.

Then write the following code in btnIncome_MouseHover and btnIncome_MouseLeave event.

To change cursor symbol also I am writing code in mousehover and mouseleave events

private void btnIncome_MouseHover(object sender, EventArgs e)

        {

            this.btnIncome.Image = Properties.Resources.income_btn_hover;

            this.Cursor = Cursors.Hand;

        }

private void btnIncome_MouseLeave(object sender, EventArgs e)

        {

            this.btnIncome.Image = Properties.Resources.income_btn_normal;

            this.Cursor = Cursors.Arrow;

        }

Then run your application then you will get the following output form with one Income normal button .

If you mousehover on Income  button then it will change to Income hover button like below: