My dgv doesn't update immidiately

See more:

C#

LINQ

Hi

I'm using windows form & I have a dgv on my form that I fill it menualy and I use linq to sql in my project(c# project) but when I execute my update_sp and fill the dgv again, my dgv isn't updated and I should close the dgv container form and reopen it to see my updated tbl ...

What can I do for solving this problem?

my sp_update calling codes:

DataClassesDataContext dc = new DataClassesDataContext();
dc.sp_tblbooks_update(radif, txttitle.Text, txtauthor.Text, txttranslator.Text, txtsubject.Text, txtpublicator.Text, txtpublicatonyear.Text, bool.Parse(cmbavailable.Text), txtdescription.Text);
dc.SubmitChanges();
this.Close();

and when my form is closed,I call a linq select command to get data from db and refill the dg:

var showbooksquery =
               from books in db.tblbooks
               select books;
           dataGridView1.DataSource = showbooksquery;

Note* select(search) & insert command work properly but update doesn't..
I think it is because of locking the table when an operation is running... but I don't know how to deal with this problem...
plzz help