Datagrid print (???)

Question

Hi! I need a great tutorial that can help me to make print with datagrid data. I do try some tutorial on the Net. But doesnt result. Please anyone can say show me something. Thanx Cefora.

Cefora Kaja · Answer

Please anyone can explain to me why appear these errors

Cefora Kaja · Answer

Hi Sujeet! The link you gave to me its good. But Ido try it step by step. But I get a serious problem (error message) : The name 'arrColumnLefts' does not exist in the current context The name 'arrColumnLefts' does not exist in the current context The name 'arrColumnLefts' does not exist in the current context The name 'arrColumnLefts' does not exist in the current context The name 'arrColumnLefts' does not exist in the current context The name 'arrColumnLefts' does not exist in the current context The name 'arrColumnLefts' does not exist in the current context The name 'arrColumnWidths' does not exist in the current context The name 'arrColumnWidths' does not exist in the current context The name 'arrColumnWidths' does not exist in the current context The name 'arrColumnWidths' does not exist in the current context The name 'arrColumnWidths' does not exist in the current context The name 'arrColumnWidths' does not exist in the current context The name 'bFirstPage' does not exist in the current context The name 'bFirstPage' does not exist in the current context The name 'bFirstPage' does not exist in the current context The name 'bNewPage' does not exist in the current context The name 'bNewPage' does not exist in the current context The name 'bNewPage' does not exist in the current context The name 'bNewPage' does not exist in the current context The name 'iCellHeight' does not exist in the current context The name 'iCellHeight' does not exist in the current context The name 'iCellHeight' does not exist in the current context The name 'iCellHeight' does not exist in the current context The name 'iCellHeight' does not exist in the current context The name 'iCellHeight' does not exist in the current context The name 'iCount' does not exist in the current context The name 'iHeaderHeight' does not exist in the current context The name 'iHeaderHeight' does not exist in the current context The name 'iHeaderHeight' does not exist in the current context The name 'iHeaderHeight' does not exist in the current context The name 'iHeaderHeight' does not exist in the current context The name 'iRow' does not exist in the current context The name 'iRow' does not exist in the current context The name 'iRow' does not exist in the current context The name 'iTotalWidth' does not exist in the current context The name 'iTotalWidth' does not exist in the current context The name 'iTotalWidth' does not exist in the current context The name 'iTotalWidth' does not exist in the current context The name 'iTotalWidth' does not exist in the current context The name 'strFormat' does not exist in the current context The name 'strFormat' does not exist in the current context The name 'strFormat' does not exist in the current context The name 'strFormat' does not exist in the current context The name 'strFormat' does not exist in the current context The name 'strFormat' does not exist in the current context Please see what I do: 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 { 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); }

Sujeet Suman · Answer

Csfora can you please share what exactly you want to do? What you have? What problem you are facing? http://www.codeproject.com/Articles/28046/Printing-of-DataGridView