Please I am new to the ADO.NET connected layer. But I have been able to learn how to communicate with my db effectively on the connected layer. But I notice that wen I execute an insert, update or a delete sql. I dont see the changes in the database. I but I am sure that the changes are effected cause if i run a select statement i usually see a difference in the data retrieved. but I confuse on the reason y i dont see the new data inserted when i check the db rows from visual studio. I am using ms sql db or ms sql db compact version. i use either. bt same result on both.