Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

VB.NET Datagrid and Update database

Posted on 2002-05-03
10
Medium Priority
?
464 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
Industry Leaders: 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!

 

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 1000 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Suggested Courses

972 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