unbound textbox database update

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Can anyone please help with the following fix:-
In the following sub i am updating the bound data with the tableadapter which works perfectly, however im trying to update the ritchtextbox.rtf to the database before the rest of the record information is saved as unbound if you like, but i am having a problem with the correct syntax.

Private Sub SaveInformation()
a)'-------------------------------------------------------------------------------
'have tried the following but creates exceptions
'InfoTableAdapter.InfoBindingSource.Item("FIELD_NAME") = RichTextBox1.Rtf
'InfoBindingSource.Item("FIELD_NAME") = RichTextBox1.Rtf
'----------------------------------------------------------------------------------


b)' the following all works fine for the bound controls
Me.Validate()
Me.InfoBindingSource.EndEdit()
Me.InfoTableAdapter.Update(Me.InfoDataSet.Info)
End Sub

Can anybody offer some help to section a) please?

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Not a major guru in programnming here but in most languages i've seen you have to quote things like teh filename....

e.g. "RichTextBox1.Rtf"

 

you dont need to do that. encasing it in quotes denotes it as a string, not an object. The reference for the field entry isnt a filename, its the name of a richtextbox on the form that the OP is trying to pull the contents out of, and put into the SDA.

Can you post the error details? encase the line of code in a try/catch and put debug.writeline(ex.message) into the catch section. then set a breakpoint on the debug line, and you can capture the ex details (message, innermessage, etc).

 

ummm. correct me if im wrong here, but I dont think InfoTableAdapter.InfoBindingSource.Item would work. As i recall, items in a binding source refer to the record, not the field in question.