refreshing the Database

Sriram Ramani

Hi there,

I have connected my program to a MS Access database and i have added into the database in the 3rd form..And i have a timer in the first form that compares the data in the database with the system's time,each and every second.Hence the timer runs every minute,...

the problem now is that the timer do not include my new data that i have added in the 3rd form

Can any one please hepl me?

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhimanyu K Vatsa16y ago
very confusing question? refine your question first to get right answer.
rusdy rip17y ago
i think i have same problem with him, but if using timer or button i can show updated database on datagrid. the problem is when A is viewing database from datagrid. then B inserting a new data to database. A still looking datagrid from database before updated if he don't click refresh or using timer how can the datagrid automatically refresh the data from database without using button or timer. i don't like using timer cause it eat resources a lot. thx sorry bad english
Vijaya Kadiyala17y ago
Hi

I mean are you using any Commit or Rollback??

Thanks -- Vijaya Kaidyala
www.DotNetVJ.com
Sriram Ramani17y ago
"are you issuing any transaction properties when you are inserting data from 3rd form??"

I cant understand wat u mean sir.
Vijaya Kadiyala17y ago
Hi

"It is not reading those datails".. means you are querying the database but you are not seeing the chages made in Form3. One quick question..are you issuing any transaction properties when you are inserting data from 3rd form??

Thanks -- Vijaya Kadiyala

http://dotnetvj.blogspot.com
Sriram Ramani17y ago
Here's wat i mean

I have a timer(interval 1 minute) in my program's 1st form that compares the current time with the date in my databese each minute and plays an audio file if they match.

Now i have an insert command, to insert into the database in 3rd form.So the problem now is that when the timer finishing running for 1 minute, and then starts the next 1 minute,it must also read the data that i have added from the 3rd form...

It is not reading those datails i have checked it...Is it more explanatory

Please anyone help me
Vijaya Kadiyala17y ago
Hi

Your question is little confusing. Could u please walk-us-thru with some example.

Thanks -- Vijaya Kadiyala

http://dotnetvj.blogspot.com