Cancelling new record in Data Grid

[Binish]

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

[jkcontra]

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

[Binish]

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

[jkcontra]

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

[Binish]

That works!! Thanks a lot!!!

[jkcontra]

No Problem

[tpfkanep]

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.

[Binish]

With recordset, .CancelUpdte should probably work

[tpfkanep]

rs.CancelUpdate does not work.

I am busy recoding using FlexGrid.