I want to create setup file for my project with all prerequisites like framework,sqlserver and .log file/db script.
I want to run DB script during the installation of my setup. On single click i want to install all this .
In your Project solution Right click Add-> New Project-> Other Project Types-> Setup and Deployment Project -> Visual Studio Installer -> Setup project.
Then Name your setup Project. Right click on setup project Add-> primary Output and select your project displayed.
Again Right Click the setup project and select View-> File System -> Application Folder. Now copy what you want to be in installation folder.
Here is the example tutorial for creation of setup file.
To run your DBscript on installation you should assign Custom Actions. View-> Custom Actions.
Here is the step by step tutorial for opening the web page after installation. In the same way you can assign your own custom action during installation, Roll back, commit and uninstall.