VB9 and LINQ to SQL: Need to programmatically update the value in a bound textbox

Question

I’m working in VS2008 using LINQ-to-SQL and have bound fields to a windows form.  I can update the field values manually, navigate to another record, navigate back to the record and the field value change sticks.  However when I update a field value programmatically (i.e. I change the value in Textbox1.Text for example). The value change doesn’t stick when I navigate away to and come back to that record. 

 

I have a field that I need to calculate and populate programatically but that same field can be updated if the user wants to go with a different amount value.

 

Now in VS 2003 I used to have to update the value in the underlying table that was bound to the field.  But using LINQ-to-SQL, I don’t think I have access to table adapters and datasets like with ADO .Net. 

 

How can I update a bound field’s value programmatically in the Linq-to-SQL environment and also update the underlying bound value too?

 

Thank you in advance for your help.

 

Sincerely,

Paul.

 

Answer 1

Hi, just checking back to see if anyone had any thoughts on this one.  I'm sure that my question is very basic in nature so if there's another post or website addressing this I apologize in advance for any redundancy.

 

Any suggestions or advice would be greatly appreciated !!!

 

Thank you in advance for your time and your help.

 

Sincerely,

Paul Grossman

PAULGRO Consulting LLC.

Answer 2

I found it: 

http://windowsclient.net/blogs/faqs/archive/2006/05/30/how-do-i-ensure-that-programmatic-changes-to-the-value-of-a-bound-control-get-updated-in-the-datasource.aspx

 

Thank you George !