VB.net 2008 Problem properly closing a form.

  • Thread starter Thread starter Markei54545
  • Start date Start date
M

Markei54545

Hi all,

I have a form with a databound datagridview. I close the form using
'me.close'.

Elsewhere I then directly update the SQL data.

If I then return to my form it doesn't reflect the change (unless I
restart the program first).

The form is populated in the load event using
Me.JOBSTableAdapter.Fill(Me.DataSet2.JOBS) but even when this is run
the change isn't reflected.

I presume I must refresh the datasource somehow. Any ideas?

Thanks

Mark
 
Markei54545 said:
Hi all,

I have a form with a databound datagridview. I close the form using
'me.close'.

Elsewhere I then directly update the SQL data.

If I then return to my form it doesn't reflect the change (unless I
restart the program first).

The form is populated in the load event using
Me.JOBSTableAdapter.Fill(Me.DataSet2.JOBS) but even when this is run
the change isn't reflected.

I presume I must refresh the datasource somehow. Any ideas?

Thanks

Mark
Click to expand...

You should firstly check that your data has been saved to the database -
using Enterprise Manager, or whatever (you don't say what sort of
database you're using).

Assuming you're not using caching of some kind, then there should be no
reason why you can't fetch a dataset containing recently saved data.

However, you don't say what your datasource is. More details might help
a diagnosis.
 
Markei54545 said:
Hi all,

I have a form with a databound datagridview. I close the form using
'me.close'.

Elsewhere I then directly update the SQL data.

If I then return to my form it doesn't reflect the change (unless I
restart the program first).

The form is populated in the load event using
Me.JOBSTableAdapter.Fill(Me.DataSet2.JOBS) but even when this is run
the change isn't reflected.

I presume I must refresh the datasource somehow. Any ideas?

Thanks

Mark
Click to expand...

You should firstly check that your data has been saved to the database -
using Enterprise Manager, or whatever (you don't say what sort of
database you're using).

Assuming you're not using caching of some kind, then there should be no
reason why you can't fetch a dataset containing recently saved data.

However, you don't say what your datasource is. More details might help
a diagnosis.
 
Back
Top