ExecuteCommand in data linq query

35 views Asked by At

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)
0

There are 0 answers