private void printDocument1_PrintPage(object sender,System.Drawing.Printing.PrintPageEventArgs e)
{
    int kx = 25;
    int ky = 50;
    con.Close();
    con.Open();
    String sql = "SELECT * from cash_bill";
    cmd = new OleDbCommand(sql,con);
    dr1 = cmd.ExecuteReader(CommandBehavior.CloseConnection);

    while (dr1.Read()) 
    {
        e.Graphics.DrawString(dr1[7].ToString(),printFont,brushes.Black,kx + 75,ky + 5);


        if (itemperpage < 29) 
        {
            itemperpage += 1; 
            e.HasMorePages = false; 
            ky = ky + 50;
        }

        else 
        {
            itemperpage = 0; 
            e.HasMorePages = true; 
             return;

        }

    }
    con.Close();
}