PDA

View Full Version : سوال: پرینت و صحفه بندی dataGridView



pooriajojo
جمعه 15 اسفند 1393, 19:57 عصر
سلام . من میخوام اطلاعات گرید ویو را پرینت کنم . ولی اطلاعات از یک صحفه بیشتره . من میخوام صحفه بندی کنه و در تعداد صحفه prinpreview تعداد صفحات بیاید و از آنجا یکی یکی چاپ کنم و بزنم صحفه بعد . برام مهمه که صحفه بندی ذث print preview انتقال پیدا کنه
لطفا با c# , print document

golbafan
جمعه 15 اسفند 1393, 20:07 عصر
سلام

لینک های زیر برای کار شما مناسبه:
http://www.codeproject.com/Articles/16670/DataGridView-Printing-by-Selecting-Columns-and-Row
http://www.codeproject.com/Articles/28046/Printing-of-DataGridView

pooriajojo
جمعه 15 اسفند 1393, 22:39 عصر
آقا برنامش مشگل زیاد داره
ایا usig خاصی دارد ؟

این کل برنامش که من نوشتم. خیلی جاخا error میده



using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Globalization;

namespace print
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

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.Mar ginBounds.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.I nheritedStyle.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.Inh eritedStyle.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 button2_Click(object sender, EventArgs e)
{
PrintDialog printDialog = new PrintDialog();
printDialog.Document = printDocument1;
printDialog.UseEXDialog = true;
//Get the document
if (DialogResult.OK == printDialog.ShowDialog())
{
printDocument1.DocumentName = "Test Page Print";
printDocument1.Print();
}
}

private void button1_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
SqlConnection sqlConnection = null;
SqlCommand sqlCommand = null;
SqlDataReader sqlReader = null;

try
{
// SqlConnection str = new SqlConnection();
// str.ConnectionString = @"Data Source=(local);Initial Catalog=khadamat;Integrated Security=True";
// SqlCommand sqlCommand = new SqlCommand("select * from estelam1 ", str);
//str.Open();
string strQuery = "SELECT CompanyName, ContactName, Address, PostalCode,Phone FROM Customers";
sqlConnection = new SqlConnection(strConnectionString);
sqlConnection.Open();
sqlCommand = new SqlCommand(strQuery, sqlConnection);
sqlReader = sqlCommand.ExecuteReader();
while (sqlReader.Read())
{
object[] row = { sqlReader[0], sqlReader[1], sqlReader[2], sqlReader[3],sqlReader[4] };
dataGridView1.Rows.Add(row);
}
}
catch (Exception exc)
{
MessageBox.Show(exc.Message, "Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
finally
{
Cursor.Current = Cursors.Default;
sqlConnection.Close();
if (sqlReader != null)
{
sqlReader.Dispose();
sqlReader = null;
}
if (sqlCommand != null)
{
sqlCommand.Dispose();
sqlCommand = null;
}
}
}


}
}