Load XML File Data in DataGridView & Print DataGridView Data

Ghanashyam Nayak

14 Comments

Join the conversation! Your thoughts help the community grow.

Dintwe Africa14y ago
thank you sir, but my problem is to save
Damir Mutap14y ago
I reworked print, so now i can print multipages :)
Ghanashyam Nayak14y ago
Thank you Damir...
Damir Mutap14y ago
Ok u just saved my life :), and i just learned new way to print my data's without using database. U are Awesome!!!
Abhi Kumar14y ago
Very useful article. Thanks for sharing.
- Ghanashyam Nayak14y ago
  Thank you so much Abhi
Sumita Jain14y ago
very nice article.....
- Ghanashyam Nayak14y ago
  Thank you so much sumita...
Jessica Stephen14y ago
seems useful for me. Thank you!!
- Ghanashyam Nayak14y ago
  Thank you Jessica
Monika Arora14y ago
Its a very nice and useful article. I will surely try to implement this.
- Ghanashyam Nayak14y ago
  Thank you so much Monika.. When you will implement then tell me, will it implement successfully or not?
Nitin Singh14y ago
Thanks, It is very valuable
- Ghanashyam Nayak14y ago
  Thank You Nitin

Let us look at the actual form:

Now let us see how to load data into the DataGridView from the XML file.

Use the following namespace for using XML:

using System.Xml;

Use the following namespace for using the DataSet to load the data into the DataSet from the XML file & then from the DataSet to DataGridView.

using System.Data;

Now create the object of the DataSet.

DataSet myDataSet = new DataSet();

When the user clicks on the Load XML button then it will Read the data from the XML file & then store that data into the DataSet.

myDataSet.ReadXml(@"C:\Users\Indus_User\Desktop\books.xml");

Now we have to give that DataSet data to the DataGridView using the DataSource.

myDataGridView.DataSource = myDataSet.Tables[0].DefaultView;

The original Load XML button code:

private void btnLoad_Click(object sender, EventArgs e)
{
myDataSet.ReadXml(@"C:\Users\Indus_User\Desktop\books.xml");
myDataGridView.DataSource = myDataSet.Tables[0].DefaultView;
}

See the following Image:

OK. After this very small & easy code it will load the data from the XML file into the DataGridView.

Now come to print that loaded data into the DataGridView.

Use the following namespace to use the bitmap class.

using System.Drawing;

Now create the object of the PrintDocument.

System.Drawing.Printing.PrintDocument myPrintDocument = new System.Drawing.Printing.PrintDocument();

Create the Event of the PrintPage Of the PrintDocument.

myPrintDocument.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(myPrintDocument_PrintPage);

Now print the data.

myPrintDocument.Print();

The original Print Button Code:

private void btnPrint_Click(object sender, EventArgs e)
{
myPrintDocument.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(myPrintDocument_PrintPage);
myPrintDocument.Print();
}

Let us see how to print the DataGridView.

First of all we have to calculate the Width & Height of the records of the DataGridView.

Find the width :

int myWidth = 0;
for (int i = 0; i < myDataGridView.Columns.Count; i++)
{
myWidth += myDataGridView.Columns[i].Width;
}

From the above code it will calculate the width of each column & then we will get the whole width.

Find the Height :

int myHeight = 0;
myHeight=Convert.ToInt32(myDataGridView.Rows[0].Height * (myDataGridView.Rows.Count));

Now create the object of the Bitmap of calculated Width & Height.

Bitmap myBitmap = new Bitmap(myWidth, myHeight);

Now use the DrawToBitmap function to convert the DataGridView into a bitmap image using the calculated Width & Height.

myDataGridView.DrawToBitmap(myBitmap, new Rectangle(0, 0, myWidth, myHeight));

Finally Draw that bitmap image.

e.Graphics.DrawImage(myBitmap, 0, 0);

The whole code of the PrintPageEventHandler method:

private void myPrintDocument_PrintPage(System.Object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
int myWidth = 0;
int myHeight = 0;
myHeight=Convert.ToInt32(myDataGridView.Rows[0].Height * (myDataGridView.Rows.Count));
for (int i = 0; i < myDataGridView.Columns.Count; i++)
{
myWidth += myDataGridView.Columns[i].Width;
}
Bitmap myBitmap = new Bitmap(myWidth, myHeight);
myDataGridView.DrawToBitmap(myBitmap, new Rectangle(0, 0, myWidth, myHeight));
e.Graphics.DrawImage(myBitmap, 0, 0);
}

See the following image which is the print of the DataGridView:

Hope this is easy to understand for you.