Updating DataGrid (Willing to try other controls if necessary!)

[codegirl]

I have a datagrid tied to an ADODC that only displays some of the columns in my table. I want to update the other columns in code because the user does not know their values. Whenever the user tries to update the datagrid, it saves the changes automatically, then gives me an error because the undisplayed values (which are required) are null. How can I update or add records using a datagrid like this?

I'm also willing to try other controls, such as a flexgrid, if that will make it work. I've heard that datagrids don't work well over networks, and this program will eventually run on a network...

Any suggestions would be great!!!