I use ExecuteCommand in data context in linq to pass update command like this
_context.ExecuteCommand("update tb_ExpList set exp_name = '" & TextBox8.Text & "',exp_desc = '" & TextBox7.Text & "',exp_limit = '" & TextBox4.Text & "',exp_type = '" & TextBox3.Text & "' where Expl_id= '" & x.Expl_id & "'")
It works well and updates my database directly. My question is: how do reflect the new data that I updated on my textbox objects on vb.net form.
I used 'Refresh' like this, each line separately, but it doesn't work.emphasized text
_context.Refresh(Data.Linq.RefreshMode.OverwriteCurrentValues).
_context.Refresh(Data.Linq.RefreshMode.KeepChanges).
_context.Refresh(Data.Linq.RefreshMode.KeepCurrentValues)