how to create a setup for window form application including the related sql database?

If a second computer uses Windows OS, then you don't need to install your application on that computer. Just copy executable file ;)

If you use SQL server database and want to connect it via LAN, you need to enable SQL Server TCP/IP connections[^].

Remember to check connection string as Murugan Kolanji mentioned.

Next time, please be more specific and provide more details.

Attach sql database file to creating .exe setup in c# :-

We can implement auto attach database just use the connection string following.

1) Add a folder named ”DB” to the project, and copy the database file into it after you detach it from your sql server.
2) Change your connection string like this:
<connectionstrings>
<add name="WindowsFormsApplication1.Properties.Settings.BabakConnectionString">
connectionString="Data Source=.;AttachDbFilename=|DataDirectory|\DB\Babak.mdf;Initial Catalog=test;Integrated Security=True"
providerName="System.Data.SqlClient" />


3) After these, the database file will auto attach to the sql server when you run your application, and the database name is “test”, you can open the sql server management studio to find it.

In addition, you can find the connection in the app.config file through the solution explorer in vs2010. And you also can find this file under your project. With these information, you can find it and modify it.

You need to get the connection string right, as others have said. Really, you should not expect to find it automatically, but rather to allow a user to configure it ( although you can guess what it might be ) and install your database from an admin console in your app.

Your other option is to use SQL Server Compact Edition, which does not require SQL Server to be installed and thus makes deployment much easier.