Setup & Deployment process for Windows application.

Posted by ttarakarajesh-8732 under C# on 8/30/2011 | Points: 10 | Views : 3596 | Status : [Member] | Replies : 3
Hi,

I am using Visual Studio 2010 and I need to create a windows application. That windows application just interacts with the database. That means we can add new records to the table from windows form and we can retrieve the specific record from database table. I am using SQL SERVER as backend. Could you tell me how to follow setup & deployment process for our windows application? And how do we use tables & Stored Procedures of SQL SERVER database in Client's machine?

Thanks,
Tarak




Responses

Posted by: T.saravanan on: 8/30/2011 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi,

My suggestion is using webservice in your project for connecting database.What ever you want like insert or select do it in that webservice then create setup file for your project send it to your client.In case if any changes in query means just change in your webservice then publish your webservice.
For creating setup...
Video: http://www.youtube.com/watch?v=SXBlIxHaV1I
http://msdn.microsoft.com/en-us/library/19x10e5c.aspx
https://balanagaraj.wordpress.com/tag/create-setup-in-visual-studio-2010/

Know about webservice refer the below links...you get an idea...
http://www.codeproject.com/KB/webservices/myservice.aspx
http://www.codeproject.com/KB/webservices/WebserviceWinFormsWebForm.aspx
http://www.codeproject.com/KB/cs/webservice.aspx

Thanks,
T.Saravanan

ttarakarajesh-8732, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: ttarakarajesh-8732 on: 8/31/2011 [Member] Starter | Points: 25

Up
0
Down
Thanks for your response Saravanan. Primarily i am worrying with DB maintenance for Windows application. How do we export our DB to client machine? Our client doesn't having SQL SERVER or anything. And My client has only MS OFFICE in his machine. I didn't find anything more than that.

Thanks,
Tarak

ttarakarajesh-8732, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: T.saravanan on: 9/1/2011 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi Tarak,

Sorry for the delay.
There's no need to export the DB in to your client place.Just access your db to using webservice what ever you need like export to excel,insertion,etc.,

Webservice is a web method then only i suggest using webservice to access your db from your client side.Try this...
About webservice refer my prevoius answer....

Thanks,
T.Saravanan

ttarakarajesh-8732, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response