Steps to create setup file in Visual studio 2012 with database.

In this post i will show the steps to create an setup file in visual studio 2012 with database. I was searching from about month for how to create setup with database but everywhere same thing only i was getting i.e without database. As we know vs2012 and newer version dont have setup and deployment option so we have to use installshield LE to create setup but the setup created with that dont work on client or other pc if it has some database. I have tried and different method to create setup without using it, and it worked for me just give a try and let me know if it works for you or not.

Below are the steps.

STEP 1

Create and empty project in vb or C#. here i have created one form and placed gridview in it.

STEP 2

Then Right click on your project name in solution explorer and select Add > New Item and choose Service-based Database. you can rename your database name with yours or any.

STEP 3

Then Double click on Database1.mdf  and create and table. i have created table and inserted some data into it.

STEP 4

Then i am binding my gridview with database. to do that click on small arrow on gridview > choose other source> database>dataset> choose your database>next>select the table>finish and it will be binded.

STEP 5

Now the main thing about creating setup. Click on Build option and select publish option. now here choose the location where you want to publish the app. here i have selected desktop and selected one folder on desktop and click open.

Note:-please create an folder and select it so all files goes to one place. 

STEP 6

Now select the method from where user can install your application. i have choosen cd-rom option and click on next.

STEP 7

In next step choose whether your application checks for update from some particular location or not and click next.

STEP 8

Now your application is ready to publish click finish and it will create an setup.

It is the simple way to create an setup with database and when you will install this setup file in client pc it will work. i have tested with 3 different pc and it worked in all pc, just make sure client pc must have .net framework 4.0 and above.

Please let me know if its work for you or not in comments. and if it works then please do share this post so other who are facing same problem can see it. if i will get another solution to create setup with database i will make an another post for it.

Thank you.