http://www.c-sharpcorner.com/forums/fill-datagridview-using-datareader
while (dr.Read())
{
lpogridview.Rows[i].Cells[0].Value = Convert.ToString(dr[0]);
lpogridview.Rows[i].Cells[1].Value = Convert.ToString(dr[1]);
lpogridview.Rows[i].Cells[2].Value = Convert.ToString(dr[2]);
lpogridview.Rows[i].Cells[3].Value = Convert.ToString(dr[3]);
lpogridview.Rows[i].Cells[4].Value = Convert.ToString(dr[4]);
lpogridview.Rows[i].Cells[5].Value = Convert.ToString(dr[5]);
lpogridview.Rows[i].Cells[6].Value = Convert.ToString(dr[6]);
lpogridview.Rows[i].Cells[7].Value = Convert.ToString(dr[7]);
}