Follow on... DataGrid partial update

[toon10]

I'm going to get more complex now! I have a datagrid with a SQL table, joined to various views. Is is possible to update any changes made to any fields from the table in the datagrid but lock down the fields in the views?

i.e. Name and Quantity fields come from my table and the other fields on the datagrid come from views. I want to be able to let the user update the Name and Quantity fields if required but either not let them make changes to the view data or have the datagrid just disregard any changes to the view data!

Not sure if I'm making myself clear?

Thanks
Andrew

 

[toon10]

Sorry folks, forget that idea. I have a better solution, I was just being a bit of a muppet! Ignore the above post!

Thanks

 

[rb11291978]

Are you using a dataset as a datasource for your datagrid?
If so then access the has changes property of the dataset.