Solved

VB.NET Datagrid and Update database

Posted on 2002-05-03
10
458 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 

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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

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 …
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…
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

770 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