How to create setup app form C# with SQL Server 2008 R2
I need to deploy an SQL Server 2008 R2 Express Edition database and tables,store-procedure with my app form C# by Visual Studio 2010 project using setup project.
Ii create setup of my project but get me error when installing on another machine
my steps
-
Create new folder in my project root and paste database files and write in app.config file this connection string
add name="conncet" connectionString="Data source=PROBLEMSOLVER\SQLEXPRESS;AttachDbFilename=|DataDirectory|\database\pro_date.mdf;Initial Catalog=test;Integrated Security=True;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient"
-
go to solution my project and add new project and select setup project
Please help me. Step by step deploy my project with SQL Server.