I have a weird issue in a VB.Net Windows Forms application I cannot work out.
I have a simple Issues Register Application with a text [Status] Field that uses the variables Open, Closed and On Hold bound to a Textbox Control (TextBox_Status ).
If I manually type in the new variable (Open, Closed and On Hold) into the control when the call the Update procedure the Datatable updates the SQL database and all is good.
It falls apart when I want to use a button to update the TextBox (TextBox_Status) using the following;
Me.TextBox_Status.Text = "Open"
At Runtime when I click the button I can see on the form that the text in TextBox_Status has changed but when I call the Update procedure the Datatable does not try to update the database. No error is raised and through SQL Profiler I can see that no attempt is made to update the SQL database. Its as if the bindingsource does not recognise that the text in the textbox has changed unless I directly type the string into the control.
This seems to be working fine elsewhere in the application so if anyone has any suggestions I would really appreciate it.
PS: Update Procedure I am using;
Me.IssuesTableAdapter.Connection.ConnectionString = My.Settings.SQLConnectionstring
Catch ex As Exception