Loop Didn't Work Properly, 1 Row Only Update From Grid

I attached coding as rar and this is 

 

private void btnUpdate_Click(object sender, EventArgs e)

{

try

{

//Data update into Ledger table

{

string UpdatePur = ("Update [CompanyLedger] set [CompanyInvoice]=" + txtCompInv.Text + ", [CompanyName]='" + cboxCompName.Text + "', [DateTrans]='" + datePurchase.Value.Date.ToString() + "', [Debit]= " + txtTotalAmnt.Text + ", [Credit]=" + txtPayAmount.Text + ", [Balance]=" + txtBalance.Text + ", [CreatedDate]='" + datepicker.Value.Date.ToString() + "', [CreatedBy]='" + lblLoginID.Text + "' where [InvoiceNo]= " + txtInvoice.Text + "");

OleDbDataAdapter da = new OleDbDataAdapter(UpdatePur, con);

DataSet ds = new DataSet();

da.Fill(ds);

}

//Data update into Purchase table

for (int i = 0; i < metroGrid1.Rows.Count; i++)

{

string UpdatePur = ("Update [CompanyPurchase] set [DateofPurchase]='" + datePurchase.Value.Date.ToString() + "', [CompanyName]='" + cboxCompName.Text + "', [CompanyInvoiceNo]='" + txtCompInv.Text + "', [BuiltyNo]=" + txtBuilty.Text + ", [Transport]='" + txtTransport.Text + "', [Product]='" + metroGrid1.Rows[i].Cells["Product"].Value.ToString() + "', [UnitPerCarton]='" + metroGrid1.Rows[i].Cells["Ctn"].Value.ToString() + "', [QtyCtn]=" + metroGrid1.Rows[i].Cells["QtyCtn"].Value.ToString() + ", [QtyPc]=" + metroGrid1.Rows[i].Cells["QtyPc"].Value.ToString() + ", [PurchaseRt_WSal]=" + metroGrid1.Rows[i].Cells["Rate"].Value.ToString() + ", [ValueRs]=" + metroGrid1.Rows[i].Cells["Value"].Value.ToString() + ", [Discount_Distributor]=" + metroGrid1.Rows[i].Cells["DistrDisc"].Value.ToString() + ", [SchemeRs]=" + metroGrid1.Rows[i].Cells["Scheme"].Value.ToString() + ", [FreePc]=" + metroGrid1.Rows[i].Cells["FreePc"].Value.ToString() + ", [Freight]=" + metroGrid1.Rows[i].Cells["Freight"].Value.ToString() + ", [SpeclDisc]=" + metroGrid1.Rows[i].Cells["SpeclDisc"].Value.ToString() + ", [NetAmnt]=" + metroGrid1.Rows[i].Cells["NetAmnt"].Value.ToString() + ", [CreatedDate]='" + datepicker.Value.Date.ToString() + "', [CreatedBy]='" + lblLoginID.Text + "' where [InvoiceNo]=" + txtInvoice.Text + " ");

OleDbDataAdapter da = new OleDbDataAdapter(UpdatePur, con);

DataSet ds = new DataSet();

da.Fill(ds);

}

//Data update into Stock table

for (int i = 0; i < metroGrid1.Rows.Count; i++)

{

string UpdatePur = ("Update [Stock] set [CompanyName]='" + cboxCompName.Text + "', [Product]='" + metroGrid1.Rows[i].Cells["Product"].Value.ToString() + "', [UnitPerCarton]=" + metroGrid1.Rows[i].Cells["Ctn"].Value.ToString() + ", [ItemRate]=" + metroGrid1.Rows[i].Cells["Rate"].Value.ToString() + ", [QtyCtn]=" + metroGrid1.Rows[i].Cells["QtyCtn"].Value.ToString() + ", [QtyPc]=" + metroGrid1.Rows[i].Cells["QtyPc"].Value.ToString() + ", [TotalAmount]=" + metroGrid1.Rows[i].Cells["NetAmnt"].Value.ToString() + ", [CreatedDate]='" + datepicker.Value.Date.ToString() + "', [CreatedBy]='" + lblLoginID.Text + "' where [InvoiceNo]=" + txtInvoice.Text + "");

OleDbDataAdapter da = new OleDbDataAdapter(UpdatePur, con);

DataSet ds = new DataSet();

da.Fill(ds);

}

ClearAll();

MetroMessageBox.Show(this, "Invoice saved successfully", "MAARS Software", MessageBoxButtons.OK, MessageBoxIcon.Information);

cboxCompName.Focus();

}

catch (Exception ex)

{

MetroFramework.MetroMessageBox.Show(this, "Error" + ex, "Stop", MessageBoxButtons.OK, MessageBoxIcon.Stop);

}

}