Datagrid print (???)

private void Form1_Load(object sender, EventArgs e)

{

string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Lunasoft.Research\Documents\Windows_Application_Samples\DataGridViewTestApplication\WindowsFormsApplication1\bin\Debug\customers.mdb;Persist Security Info=False";

string sql = "SELECT * FROM customers";

OleDbConnection connection = new OleDbConnection(connectionString);

OleDbDataAdapter dataadapter = new OleDbDataAdapter(sql, connection);

DataSet ds = new DataSet();

connection.Open();

dataadapter.Fill(ds, "customers");

connection.Close();

dataGridView1.DataSource = ds;

dataGridView1.DataMember = "customers";

dataGridView1.CurrentCell = dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[0];

}

private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)

{

try

{

//Set the left margin

int iLeftMargin = e.MarginBounds.Left;

//Set the top margin

int iTopMargin = e.MarginBounds.Top;

//Whether more pages have to print or not

bool bMorePagesToPrint = false;

int iTmpWidth = 0;

//For the first page to print set the cell width and header height

if (bFirstPage)

{

foreach (DataGridViewColumn GridCol in dataGridView1.Columns)

{

iTmpWidth = (int)(Math.Floor((double)((double)GridCol.Width /

(double)iTotalWidth * (double)iTotalWidth *

((double)e.MarginBounds.Width / (double)iTotalWidth))));

iHeaderHeight = (int)(e.Graphics.MeasureString(GridCol.HeaderText,

GridCol.InheritedStyle.Font, iTmpWidth).Height) + 11;

// Save width and height of headers

arrColumnLefts.Add(iLeftMargin);

arrColumnWidths.Add(iTmpWidth);

iLeftMargin += iTmpWidth;

}

}

//Loop till all the grid rows not get printed

while (iRow <= dataGridView1.Rows.Count - 1)

{

DataGridViewRow GridRow = dataGridView1.Rows[iRow];

//Set the cell height

iCellHeight = GridRow.Height + 5;

int iCount = 0;

//Check whether the current page settings allows more rows to print

if (iTopMargin + iCellHeight >= e.MarginBounds.Height + e.MarginBounds.Top)

{

bNewPage = true;

bFirstPage = false;

bMorePagesToPrint = true;

break;

}

else

{

if (bNewPage)

{

//Draw Header

e.Graphics.DrawString("Customer Summary",

new Font(dataGridView1.Font, FontStyle.Bold),

Brushes.Black, e.MarginBounds.Left,

e.MarginBounds.Top - e.Graphics.MeasureString("Customer Summary",

new Font(dataGridView1.Font, FontStyle.Bold),

e.MarginBounds.Width).Height - 13);

String strDate = DateTime.Now.ToLongDateString() + " " +

DateTime.Now.ToShortTimeString();

//Draw Date

e.Graphics.DrawString(strDate,

new Font(dataGridView1.Font, FontStyle.Bold), Brushes.Black,

e.MarginBounds.Left +

(e.MarginBounds.Width - e.Graphics.MeasureString(strDate,

new Font(dataGridView1.Font, FontStyle.Bold),

e.MarginBounds.Width).Width),

e.MarginBounds.Top - e.Graphics.MeasureString("Customer Summary",

new Font(new Font(dataGridView1.Font, FontStyle.Bold),

FontStyle.Bold), e.MarginBounds.Width).Height - 13);

//Draw Columns

iTopMargin = e.MarginBounds.Top;

foreach (DataGridViewColumn GridCol in dataGridView1.Columns)

{

e.Graphics.FillRectangle(new SolidBrush(Color.LightGray),

new Rectangle((int)arrColumnLefts[iCount], iTopMargin,

(int)arrColumnWidths[iCount], iHeaderHeight));

e.Graphics.DrawRectangle(Pens.Black,

new Rectangle((int)arrColumnLefts[iCount], iTopMargin,

(int)arrColumnWidths[iCount], iHeaderHeight));

e.Graphics.DrawString(GridCol.HeaderText,

GridCol.InheritedStyle.Font,

new SolidBrush(GridCol.InheritedStyle.ForeColor),

new RectangleF((int)arrColumnLefts[iCount], iTopMargin,

(int)arrColumnWidths[iCount], iHeaderHeight), strFormat);

iCount++;

}

bNewPage = false;

iTopMargin += iHeaderHeight;

}

iCount = 0;

//Draw Columns Contents

foreach (DataGridViewCell Cel in GridRow.Cells)

{

if (Cel.Value != null)

{

e.Graphics.DrawString(Cel.Value.ToString(),

Cel.InheritedStyle.Font,

new SolidBrush(Cel.InheritedStyle.ForeColor),

new RectangleF((int)arrColumnLefts[iCount],

(float)iTopMargin,

(int)arrColumnWidths[iCount], (float)iCellHeight),

strFormat);

}

//Drawing Cells Borders

e.Graphics.DrawRectangle(Pens.Black,

new Rectangle((int)arrColumnLefts[iCount], iTopMargin,

(int)arrColumnWidths[iCount], iCellHeight));

iCount++;

}

}

iRow++;

iTopMargin += iCellHeight;

}

//If more lines exist, print another page.

if (bMorePagesToPrint)

e.HasMorePages = true;

else

e.HasMorePages = false;

}

catch (Exception exc)

{

MessageBox.Show(exc.Message, "Error", MessageBoxButtons.OK,

MessageBoxIcon.Error);

}

}

private void printDocument1_BeginPrint(object sender, System.Drawing.Printing.PrintEventArgs e)

{

try

{

strFormat = new StringFormat();

strFormat.Alignment = StringAlignment.Near;

strFormat.LineAlignment = StringAlignment.Center;

strFormat.Trimming = StringTrimming.EllipsisCharacter;

arrColumnLefts.Clear();

arrColumnWidths.Clear();

iCellHeight = 0;

iCount = 0;

bFirstPage = true;

bNewPage = true;

// Calculating Total Widths

iTotalWidth = 0;

foreach (DataGridViewColumn dgvGridCol in dataGridView1.Columns)

{

iTotalWidth += dgvGridCol.Width;

}

}

catch (Exception ex)

{

MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

}