Setup & Deployment process for Windows application.

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

0	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

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

Latest Posts