Hi there,
I have an access database that is used on an online ASP system to book holidays, now I'm wanting to create a VB application that can look at the database and as soon as a new record appears have the display update and a message window appear.
Problem is that I can get the program to look at the database and display the content, but I don't know how to get it update and refresh the screen automatically, or even to get a message depending on whether or not a new entry appears.
Any help would be appreciated.
Polling Access Database
DroopyMsdn
How are you initially populating the DataGrid from your data source
nscripta
Well mini. . . I hope you are still here. . .
I posted the solution here:
HOW-TO: Use Enterprise Services to notify Windows app of ASP.NET
cheers
peancor
Hey Blair.... Iv'e Been Hit Way Harder than That Buddy and I'm Still Standin Tall...... What the Hell are you Hangen around Here for You are Wasten Your Valuable Time.... You were Exactly Right about everything you said about VBE and C#..... Give Me a couple of Weeks and I'll be Raisen Hell in the C# Forum..... Thanks and Cheers..... I'm Autta Here!!!!
Now Playing: Hounddog Elvis
Dips123
faiz ahmed
sniggihts
Goodness, that's an unusual profile.
A message can be
msgbox("You have a new Entry", MsgBoxStyle.Information, "New Entry")
Or message.show
Wwhen you say, "update the screen" do you mean the form for this program If so what kind of display controls does it have
the_grove_man
Hey Blair..... Did you see the Post about C# or VBE.... The one Guy said VBE is like Smoken.... If you haven't started Don't Start.... If you already are then QUIT Now.....
Man I've been doin C# First day... all Day.... I Love It.... I read The C# Reference and Understood it All.... C# is Very Powerful And Elegant... The Whole Language is a Big Friggen string of Nested Calls.... The Way it Should Be..... Cheers
mqsash
If you are able to switch to using sql server 2005 or sql express you can use the sqldependancy class for this. I have a sample on my vb-tips website.
http://www.vb-tips.com/default.aspx ID=97f5073b-4c42-4215-b71c-3503c15fd46e
Eric Latham
I presume there is a dataadapter or table adapter
I think you have to refill the table.
I'd need more information as to what file objects you are employing
DAO, ADO, ADOX, ADO.NET
Andrew Thorpe
Hey there mini. . .
the proper approach for doing this is to implement a "COM+ Loosely Coupled Event" and Enterprise services.
Is your Web application in ASP or ASP.NET
Basically the idea is your asp will instance the event.
Your Windows app registers as a sink.
when the asp page instances the event, COM+ services notifies registered sinks that the event has occurred. It is rather straight forward.
CAVEAT EMPTOR!!! DO NOT TRY THIS USING A VBSUX WINDOWS APPLICATION!!!! USE .NET!!!!
Is this needed right now You can search MS for examples. If you can wait until this weekend I will show you how to do this.
So don't let this stop you from working on other aspects of the program.
Colvic
hey mini. . you still there
I am working on your problem and its not working correctly - I think VS 6 corrupted my COM services. I have a post here asking for help. I've done this many times in VBSUX and Delphi. Give it a couple of days for someone to look at my code and confirm my logic and/or errors. . . but a "Loosely Coupled Event" is what you are looking for. Do a google on that term. It really is not very hard once you know how to do it. As I said, something is telling me my COM+ services are buggered.
If I get time tomorrow I will remote desktop to my work computer and see if it works there.
In the mean time, watch this thread to see if someone responds:
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=256521&SiteID=1
Here is a newsgroup post on the same. I have "priority service" and they should get back in two days:
http://msdn.microsoft.com/newsgroups/default.aspx query=COM%2B+LC+Event+-+Transient+Subscription&dg=microsoft.public.dotnet.framework.interop