try
        {
            SqlConnection con = new SqlConnection(str);
            con.Open();
            SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM Purchase_Order Order By Invoice_no", con);
            DataTable dt = new DataTable();
            sda.Fill(dt);

            foreach (DataRow dr in dt.Rows)
            {
                int n = dgv.Rows.Add();
                dgv.Rows[n].Cells["Column1"].Value = dr["Invoice_no"].ToString();
                dgv.Rows[n].Cells["Column2"].Value = dr["Date_of_Purchase"].ToString();
                dgv.Rows[n].Cells["Column3"].Value = dr["Item_Name"].ToString();
                dgv.Rows[n].Cells["Column4"].Value = dr["Seller_Name"].ToString();
                dgv.Rows[n].Cells["Column5"].Value = dr["Company_Name"].ToString();
                dgv.Rows[n].Cells["Column6"].Value = dr["Quantity"].ToString();
                dgv.Rows[n].Cells["Column7"].Value = dr["Price"].ToString();
                dgv.Rows[n].Cells["Column8"].Value = dr["Discount"].ToString();
                dgv.Rows[n].Cells["Column9"].Value = dr["Paid_Amount"].ToString();
                dgv.Rows[n].Cells["Column10"].Value = dr["Remaining"].ToString();
                dgv.Rows[n].Cells["Column11"].Value = dr["Sub_Total"].ToString();
                dgv.Rows[n].Cells["Column12"].Value = dr["Total"].ToString();
            }
            con.Close();
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message);
        }