ASP.NET - FormView - Datasource update only some of the fields

Question

I have a ASP.NET page that contains a formview and ObjectDataSource. On the page I only have 4 fields that are bound to fields in my datasource. My datasource contains 10 fields. When I call an update it is setting the 6 fields I am not binding to to null. The only way I can find it get around this is to add hidden fields for the 6 unbound fields and bind them to the datasource.

Is there anyway around this without using hidden fields? I would think that it should only update the fields you are binding to and ignore the others.

Any suggestions?

Thanks.

Answer 1

The solution is to just change by hand the Update Code on the datasource of your formview.

Just remove the fields that you do not won to update. Its a simple SQL command.