Question Windows Application with Web Data

[kgmganesh]

In vb.net how can access data from web. We want access multi location data with desktop application.

 

[jmcilhinney]

Can you be a bit more specific?

 

[kgmganesh]

desktop with web data

like pos(point of sales). I have multi-branches. i want to access Data from Centralised server with asp.net desktop application.

 

[jmcilhinney]

Well, there's not really such thing as an "ASP.NET desktop application". To call it a "desktop application" implies that it is running locally, while ASP.NET applications inherently run on a remote server and are displayed in a browser. Which is it that you want? I can't see anyone running a POS application over the web.

Also, what do you mean by "data". I would now assume you mean a database but from your first post it could have meant anything. If you mean a database then please say that. In future, please don't be so economical with your words. Assume that two brief sentences will never be enough to adequately describe your issue to those who have no prior knowledge of what you're doing. If you'd like us to take the time and make the effort to help you then please do us the courtesy of taking the time and making the effort to post a FULL and CLEAR description of your issue.

If you do mean that you want to connect to a database remotely then you can do it directly by simply specifying the server address in your ADO.NET connection string. It may be a better idea to use a web service though.

 

[kgmganesh]

Hi,

Thanks for your advice. We are developing Accounting package for Small and Medium Business. They have Multi Branches. What we want is share the database or consolidated database for party balance or outstanding instantly. In ASP.net we cant make user friendly like vb.net.

Regards

Ganesh

 

[jmcilhinney]

Like I said, connecting to a database directly using ADO.NET is exactly the same no matter where it is. You simply put the server address in the connection string. If these branches are all on the same WAN then it should just be a matter of using the server name, exactly as you would if the server and clients were on the same LAN. You can also use the server's IP address instead of the name. I suggest that you do some reading on ADO.NET.

 

[Bernie]

Thanks for your advice. We are developing Accounting package for Small and Medium Business. They have Multi Branches. What we want is share the database or consolidated database for party balance or outstanding instantly. In ASP.net we cant make user friendly like vb.net.

Is what your saying that you want to have a desktop application run at the remote site that accesses data from the centralized database?

If so, you will be best off setting up a VPN connection between the remote site and the central site. Then you can access the database with your desktop application like it was on a local drive. You do not want to expose your raw database to the web, especially not an accounting database.

Bernie

 

[kgmganesh]

msflexgrid control like asp.net

Dear sirs

We are developing asp.net. In Gridview we want to know how to use data edit without data bind. We want to use like msflexgrid. For Master and item Details entry.


Thank you.


Regards
Ganesh