Hi,

i sorted the data when i configure the DataAdapter when load into the dataset as follow.

SELECT CustNo, CustFName, CustLName, CustTitle, CustIC, CustDoB, Deposit, JoinDate, CustAdd_1, CustAdd_2, Postcode, City, State, HomePhone, WorkPhone, HandPhone, Email, Gender FROM Customers ORDER BY CustLName.

i am having a problem of doing update and delete of the data in Customers. How do i solved these problems?? Please help.

Thanks in advance,
Viv