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(1).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>