Solved

VB.NET Datagrid and Update database

Posted on 2002-05-03
10
459 Views
Last Modified: 2010-05-02
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
Comment
Question by:FrederikBonte
  • 5
  • 5
10 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 6988255
>>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
 

Author Comment

by:FrederikBonte
ID: 6993070
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
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 6993563
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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

Author Comment

by:FrederikBonte
ID: 6993633
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
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 6993642
you should add a button to your form that will update the database and refresh by the same time.
0
 

Author Comment

by:FrederikBonte
ID: 6993664
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
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 6993811
your dataset is not supposed to be bounded. So you don't lock anything!
0
 

Author Comment

by:FrederikBonte
ID: 6993840
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
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 250 total points
ID: 6993854
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
 

Author Comment

by:FrederikBonte
ID: 6993897
thanks thats a great link

points are flying first class to you

Thanks again for your time and effort

Frederik
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question