Hi, <BR>I wana delete from databade row by rows looping through all the rows.I called Acceptchanges of Dataset.I also called Update of OledbDataAdapter but changes are not reflected to the database. <BR> ......Dt is DataTable <BR> Dim i as integer <BR>For i=0 to Dt.Rows.Count-1 <BR> Dt.Rows(i).Delete() <BR>dt.AcceptChanges <BR>Next <BR> <BR>adap.update(dtst,"usr") <BR>Please note i wana loop through all the rows also my changes reflect in the database <BR>Thanks. <BR><BR><BR>