|
Hi all,
I have a VB2.0 Winforms app that runs from about 9am until about 11pm every day analysing a live datafeed and then doing certain actions depending on the data. (It's an automated betting system for horse racing in case you're curious).
What I want to be able to do is to have some semblance of control over the app via my web server for when I am not home but need to check on the app's status or feed it a certain command to change it's behaviour. (I don't need to see the app itself so I'm not looking for a VPN/VNC type solution).
Since I also have my own web server I am thinking about building a private/secure web site which can read or write to the various SQL Server 2005 tables the app also uses. In this way I could interrogate data being created by the app (bets and results written to the DB) over the web (via stored procs run by clicking on links) and also issue commands via the website that could be written to another SQL table or XML file that the app could then check for, say every minute or so via a timer.
To give a real example - sometimes the data feed needs a gentle prod to download the latest data (which I can request via an API in the app) so I could have a status page on the web that displays the last time of the downloaded datafeed and a button to tell the winforms app to request an updated datafeed. The app would then check the "Events" table every minute or so, see that a new command to refresh the data had come in and call that method in the datafeed API. (This is a pretty simple example - I have more complex things I want to do with an interface of this sort.)
Given the app, the SQL DB and the web server are all on one machine is this the best way to do this sort of thing? Are there any nice .Net tools I don't know about to assist with this sort of (admittedly strange) type of remote interface? Should I be thinking about web services or just keep it simple and read/write SQL tables and/or XML files from both the app and the web site?
TIA for any input, comments etc - just interested if anyone has any recommendations or can see any problems with doing this sort of thing.
Mike
|
|
|
|
|
The Windows Form Application can query the Web Server at periodic intervals through a WebService right?
|
|
|
|
|
You may want to think about using technologies like SqlDependency or Notification Services in SQL Server 2005. Alternatively, take a look at Windows Communication Foundation or Remoting to exercise more direct control over the application.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Thanks - they both sound like good alternatives... I'll have to do a bit of research.
At the moment I am just doing it very simply where I write an event to a table from the web site then a timer in the app checks the table for any new entries every minute... seems to work well for what I need so far.
|
|
|
|
|
It's very irritating.
I compile the project, go to browser and do the refresh. Server (localhost) takes a long time to respond and sometimes throws a debug window to choose the debugging IDE so I must refresh again, and sometimes it works like nothing happened.
It just happened with no reason.
Everything was OK, and suddenly when I compile it and refreshed it, I get the error.
With almost every compile, I get debbuging windows that tells me to choose the IDE for debug.
Event Viewer logged this:
EventType clr20r3, P1 aspnet_wp.exe, P2 2.0.50727.42, P3 4333aece, P4 eposlovi, P5 1.0.0.0, P6 46d30c6c, P7 a, P8 6, P9 system.nullreferenceexception, P10 NIL.
aspnet_wp.exe (PID: 4456) was recycled because it failed to respond to ping message.
aspnet_wp.exe (PID: 1120) stopped unexpectedly.
An unhandled exception ('System.NullReferenceException') occurred in process #5852. Just-In-Time debugging this exception failed with the following error: The process ID is invalid.
How can I fix this irritating problem?
Thanks a lot.
|
|
|
|
|
I've solved this...
The problem is in destructor in which I closes the DB connection...
When I am done reading, I close the DB conn, and when that conn class disposes, I close the DB in destructor again and that what causes the error...
|
|
|
|
|
i want to make a schedule for distributing employees over a month ,using genetic algorithm & C#
can anyone tell me plz how to proceed ?
|
|
|
|
|
Don't cross post. See the reply in the other forum.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
I had wrote a program in vs 2005(c#). I want to use this program as CD autorun so this program should be executed without installation. as you now such this programs can not be executed without .net framwork but this program should be able of executing without .net framwork.
is there any solution to solve my problem?
GoOd LuCk
|
|
|
|
|
amin_joon wrote: this program should be able of executing without .net framwork
Then you should have thought of that before committing yourself to a dependency on the .NET framework.
amin_joon wrote: is there any solution to solve my problem?
There are expensive solutions to allow this, but I don't know of any off the top of my head. You might want to try google.
-- Always write code as if the maintenance programmer were an axe murderer who knows where you live.
Upcoming FREE developer events:
* Glasgow: Agile in the Enterprise Vs. ISVs, Mock Objects, SQL Server CLR Integration, Reporting Services, db4o ...
* Reading: SQL Bits
My website
|
|
|
|
|
I heared that there is some SDK's that install on vs and can compile codes for every platform like win98 win XP etc.
is it right?
|
|
|
|
|
No. It's called Visual C++.
|
|
|
|
|
Realistically, the only way a .NET application can run is if the correct version of the .NET Framewowrk is installed on the target computer. You can still run a .NET application as part of a CD's autorun, but it will still depend on having the .NET Framwork already installed (or you will need to install it yourself before your application runs).
|
|
|
|
|
|
plz can someone help me to get a FREE version of infragistics NetAdbantage for .Net from onother source of "www.infragistics.com" ?
|
|
|
|
|
So, what made you SPAM the forums with 7 copies of this question? It's considered very rude to do so and make collaboration on an answer pretty much impossible.
This[^] is the only place you're going to get the trial version.
|
|
|
|
|
Especially when it seems like he is spamming for a free pirated version...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Yeah, he posted another question, and the spamming continues. Some people just never listen, not even to the answers you give them.
|
|
|
|
|
Dave Kreskowiak wrote: Some people just never listen, not even to the answers you give them.
Either they are really dense or just a stupid bot.
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
Paul Conrad wrote: they are really dense or just a stupid bot.
Adamant attitude. They feel that repeated pings should convince at least some one to succumb to thier 'Mission Piracy'. 
|
|
|
|
|
Vasudevan Deepak Kumar wrote: 'Mission Piracy'
Could always be that.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
|
how do you add a custom component to the toolbox?
I have created a custom control in .net 3.0 and i
can't add it to the toolbox.
thank you...
-- modified at 17:38 Sunday 26th August, 2007
It Is Not That I'm Different!
... I'm Only Making The Difference!
|
|
|
|
|
ferdna wrote: can't added i to the toolbox
What is the error? Shouldn't be any different than anything else being added to the toolbox.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
i don't get an error at all... VS crashes when i drop the component into the form..
thank you
It Is Not That I'm Different!
... I'm Only Making The Difference!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
