Programmatically change data value
<p>Using C#, I have a windows form bound to a table on SQL Server.  When the user creates a new record I want to update the guid column programmatically.  Unfortunately, I cannot put a default value on the back end so I need to do this from a form.  I'm guessing I need to put my code in the BindingNavigatorSaveItem_Click().  Is this the best place to put the code?  How do I change the data in for the column in the tableadapter?</p>

<p>Thanks...</p>
