• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 467
  • Last Modified:

VB.NET Datagrid and Update database

Hi,

I'm using the standard datagrid in vb.net with an connection to an access database.

I want to start up my program twice, on different PC's.

When changes made with the datagrid in the database, I manage to update my database. But how do I see that in the other window. A refresh button with the command FILL to fill in the grid again fails. When I close the first window and use the refresh button, then it works.

Do i have to close something from my database, connection,...?

Is it possible to auto refresh when changes are made?


Thanks

Frederik
0
FrederikBonte
Asked:
FrederikBonte
  • 5
  • 5
1 Solution
 
Éric MoreauSenior .Net ConsultantCommented:
>>I close the first window and use the refresh button, then it works

DataSet does not automatically update the database. You need an Update statement. Don't forget that everything is disconnected in ADO.Net.

>>Is it possible to auto refresh when changes are made?

You will need something that requires an update (ie a timer)
0
 
FrederikBonteAuthor Commented:
A timer, yes i thought so to, but then what if someone is making changes at that moment.

Can you see if the grid is in editing mode or not?

Thanks

Frederik
0
 
Éric MoreauSenior .Net ConsultantCommented:
You need to trap some KeyPress events to reset the Timer to 0. If you have (because I didn't find one) a sample of a screen saver in .Net, you need to use this way.

Before doing the refresh, I hope that you will call the Update.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
FrederikBonteAuthor Commented:
Maybe, it depends. I one screens timer is activated, then the grid will do a refresh, even if on the other screen the grid is in editing mode.

Is there no way to force the refresh when the data has changed instead of with a timer. It seems like asking for trouble

0
 
Éric MoreauSenior .Net ConsultantCommented:
you should add a button to your form that will update the database and refresh by the same time.
0
 
FrederikBonteAuthor Commented:
I think we are talking next to eachother

My Database is installed on the server

My program is running on 2 different pc's with network connection and are pointing to the same database.

The edit, add and delete are done inside the grid.

If I start editing a record on one pc, and i have a timer who is to refresh each 10 seconds, then i have to make sure I end the editing before the time is up or I can restart.

When done editing the program on the other pc should also refresh.

Btw, an addition prob, is there automatic recordlocking

Thanks,

Fred
0
 
Éric MoreauSenior .Net ConsultantCommented:
your dataset is not supposed to be bounded. So you don't lock anything!
0
 
FrederikBonteAuthor Commented:
Its not bound

I Just create an OLEDBConnection
Then I made an OLEDBDataAdapter
Which I used to create a DataSet
This Dataset is used as datasoure for my datagrid

Do i have to bound stuff to have recordlocking?

And still the first question, how do i know my datagrid is being edited

I will increase points and give you another question while i'm at it :)

Can I set the column width of my grid per column, I don't find such a simple thing that I could in VB6. I know it should be in there but where.

Thanks for all you efforts.

Fred

0
 
Éric MoreauSenior .Net ConsultantCommented:
because you are disconnected from the database, the database does not know what the users are doing so no locking can be done.

have a look at
http://www.syncfusion.com/FAQ/WinForms/default.asp#44
0
 
FrederikBonteAuthor Commented:
thanks thats a great link

points are flying first class to you

Thanks again for your time and effort

Frederik
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now