Click here to Skip to main content
15,896,207 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
How to print the data from the datagridview in csharp ,it's and window application.

I am able to print the datagridview ,with the help printdocument, and Bitmap.

But the problem is that gridview has scroll bar, so means some data is hidden there , so how can i print that.
private void button1_Click(object sender, EventArgs e)
       {
           string connectionString = "Data Source=.;Initial Catalog=pubs;Integrated Security=True";
           string sql = "SELECT * FROM Authors";
           SqlConnection connection = new SqlConnection(connectionString);
           SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
           DataSet ds = new DataSet();
           connection.Open();
           dataadapter.Fill(ds, "Author_table");
           connection.Close();
           dataGridView1.DataSource = ds;
           dataGridView1.DataMember = "Author_table";

       }

       private void button2_Click(object sender, EventArgs e)
       {
           printDocument1.Print();
       }

       private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
       {
           Bitmap bm = new Bitmap(this.dataGridView1.Width, this.dataGridView1.Height);
           dataGridView1.DrawToBitmap(bm, new Rectangle(0, 0, this.dataGridView1.Width, this.dataGridView1.Height));
           e.Graphics.DrawImage(bm, 0, 0);
       }
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900