How can I deploy the SQL server database with my application

Question

I have a Windows Forms application in Visual Studio 2010 and a database in SQL Server 2008 R2. I have created the setup and deployment project for this application which produces the .exe file and installs the application on a client PC. But it needs to install SQL Server 2008 R2 and create the database with the same name that we have in our pc then we generate the database script from my pc and run on the client pc on SQL Server 2008 R2, change the name of server in app.config file, then it runs successfully.
Here is problem:
this is ok for single user but if I have many clients it will need that I do all the process for all the users. e.g (Install SQL Server on their Pc and configure it for my application)
What I want :
I want to add my data base in set up so that I no need to install the SQL Server on client system and do all the steps.
Could anybody please help me in doing this as I am new to C#, I have already spent many days on it.
Thanks in advance

Gowtham Rajamanickam · Answer

How to Embed SQL Server Express in an Application[^]

Sibeesh Venu · Answer

Check this links  it will definitely help you .NET Installer that Automatically Installs SQL 2005 Express [ ^ ] Create database during installation of a .NET application - Version 2 [ ^ ] Deploy your Application and Database [ ^ ] FYI Embedding SQL Server Express into Custom Applications [ ^ ] How to: Deploy a SQL Server Compact 4.0 Database with an Application [ ^ ] How to Embed SQL Server Express in an Application [ ^ ]