Cancelling new record in Data Grid

Hi,

I'm using a data grid to display data. If i want to cancel a new record, how do i do this?

Thanks in advance

Are you using the grid simply for displaying data, or are you using it to edit and add records as well?

Option to edit is given using textboxes which are bound to the same data control. This works fine... but i'm not able to cancel after AddNew

Ok If you are adding a new record and you want to cancel, Just refresh your ado data control. If you click on your grid at the section where you add a new record, adjust set your settings in your Datagrid's properties to Not to allow add new

That works!! Thanks a lot!!!

No Problem

Will this only work with adodc datacontrol???

I tried doing something similar but with coded recordset and datagrid.

I just could not cancel an .AddNew.

With recordset, .CancelUpdte should probably work

rs.CancelUpdate does not work.

I am busy recoding using FlexGrid.