Re: What's going on with ClickOnce

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

GaryDean wrote:
Matt,
Thanks for the reply and I'm glad to hear that your have had success with ClickOnce deployed Forms Apps....

Since any application of substance would need to connect to a backend database can you tell me how you make the connect? Have you a way to do remote binding to a datagrid or objectdatasource? How do you update the database tables back on the server? How do you call stored procedures on the backend database?

Comicster maintains personal collection files (which are just DataSets serialized to XML) on the user's hard drive, so no back-end database is necessary.

Having said that, I ended up building in a server-side database so that users could share data, and I connect to that via web services.

Anyway - like someone else said: ClickOnce is just a deployment mechanism. How you talk to a back-end database has nothing to do with how you choose to deploy your exe. Doesn't matter if you're doing direct calls to a SQL Server instance or if you're doing business objects over carrier pigeon - ClickOnce doesn't enter into it.
.

Relevant Pages

  • Re: updating an application
    ... very careful of clickonce and data. ... The program can check for the presence of the directory and database under Application Data and use ... Upon first run of a clickonce install, you would do something like this: ... Another way of updating is the Update application block, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: updating an application
    ... If you are planning to use "clickonce" as a deployment model I would recommend this book. ... NOT database updating...but more on how to get to the files, how clickonce works and stuff like that. ... this case, there is no simple way to collect old data and process it into the new database - in any case, such a transfer might not be simple because it appears that you are updating the data tables. ... Upon first run of a clickonce install, you would do something like this: ...
    (microsoft.public.dotnet.languages.vb)
  • Re: VS 2005 Deployment issue
    ... database and a different setup without the database for updates. ... Resources about ClickOnce ...
    (microsoft.public.vsnet.general)
  • Re: Database problems
    ... If you have this database on your own machine and are sharing it with other ... corrupted and it needs repairing. ... Split the database into a 'front-end and back-end database. ... Put the back-end database on a server running Windows 2000/2003 ...
    (microsoft.public.access.externaldata)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)