<div>
Try calling .EndEdit() on your bindingSource before .Update()<br />
<br />

</div>


Try calling .EndEdit() on your bindingSource before .Update()



<div>
If you mean like this :-<br />
<br />
MyDataSet.MyTable.Rows[0].<wbr />EndEdit();<wbr /><br />
<br />
then this doesnt work....<br />
<br />
Anymore thoughts?
</div>


If you mean like this :-

MyDataSet.MyTable.Rows[0].EndEdit();

then this doesnt work....

Anymore thoughts?

<div>
Here is the solution - god that was so much harder than it should have been!<br />
<br />
this.BindingContext[MyData<wbr />Set, &quot;MyTabler&quot;].EndCurrentEdit<wbr />();<br />
<br />
I think it best this question is simply now closed without awarding any points.<br />
<br />
Cheers.<br />
<br />
James.<br />

</div>


Here is the solution - god that was so much harder than it should have been!

this.BindingContext[MyDataSet, "MyTabler"].EndCurrentEdit();

I think it best this question is simply now closed without awarding any points.

Cheers.

James.


<div>
<div class="content wysiwyg-content">
This is related to another question I have outstanding but I will keep this as a new question also.<br />
<br />
I have a data adapter with an associated dataset on my windows form. &nbsp;I also have a text box that has it's &quot;databindings.text&quot; property set to the correct column in my table (all done from the property editor, not code).<br />
<br />
I .fill this dataset and, sure enough, the textbox gets populated. &nbsp;I then simply edit the data in the textbox and in the edtFolder_Leave event i perform a .update but... nothing gets updated. &nbsp;I have checked the update sql server code in the update property and all this looks fine.<br />
<br />
Why does my underlying data in my sql server table not get updated?<br />
<br />
What am I missing?<br />
<br />
Many thanks.<br />
<br />
James.
</div>
</div>


This is related to another question I have outstanding but I will keep this as a new question also.

I have a data adapter with an associated dataset on my windows form.  I also have a text box that has it's "databindings.text" property set to the correct column in my table (all done from the property editor, not code).

I .fill this dataset and, sure enough, the textbox gets populated.  I then simply edit the data in the textbox and in the edtFolder_Leave event i perform a .update but... nothing gets updated.  I have checked the update sql server code in the update property and all this looks fine.

Why does my underlying data in my sql server table not get updated?

What am I missing?

Many thanks.

James.

Databound TextBox not updating underlying database

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).