printing datagrid and textbox context in windowsform c#

Hi,

What you need to do is: Add a PrintDocument control and a PrintDialog control. Then in the PrintPage event, write the following code. Call PrintDocument1.Print() when you want to actually begin printing.

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

int x=10, y=10; // coordinates where to print

Font font= new Font("Times New Roman", 12.0F); //set the font

Graphics g = e.Graphics;

SolidBrush brush = new SolidBrush(Color.BlueViolet);

// print the date time and text

g.DrawString(dateTimePicker1.Text, font, brush, new Point(x, y));

g.DrawString(textBox1.Text,font, brush, new Point(x, y));

// retrieve data from the data grid cell by cell

BindingSource bs = (BindingSource) dataGridView1.DataSource;

DataSet ds = (DataSet)bs.DataSource;

DataTable dt = ds.Tables[0];

int originalx;

foreach (DataRow dr in dt.Rows)

x = originalx; // so that each row starts at the same left coordinates

foreach (DataColumn dc in dt.Columns)

g.DrawString(dr[dc].ToString(), font, brush, new Point(x, y));

SqlCommand cmd = new SqlCommand("select a.precision from sys.all_columns a INNER JOIN sys.tables b ON a.object_id=b.object_id and b.name='Products' and a.name='"+ dc.ColumnName+"'");

SqlConnection conn = new SqlConnection();

conn.ConnectionString = Properties.Settings.Default.AdventureWorksConnectionString;

int size = Convert.ToInt32(cmd.ExecuteScalar());

if (size != 0)

x += dr[dc].ToString().Length + Convert.ToInt32(size * font.Size);

else

y += 25; // for the next column