How to Update Record

Ramco Ramco

I have below code and i want to update the numberofshift value in records

context.Connection.Open();
context.Transaction = context.Connection.BeginTransaction();
foreach (RepeaterItem item in rptBulkData.Items)
{
    MachineShiftDetail objRecord = new MachineShiftDetail
    {

        NumberOfShift = Convert.ToInt32(txtNoOfShift.Text),

    };
    context.MachineShiftDetails...InsertOnSubmit(objRecord);
    context.SubmitChanges();
    context.Transaction.Commit();
}

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Munib Butt3y ago
Accepted answer
I would suggest to move the below line outside the foreach loop.

context.Transaction.Commit();
+1