看看这些：

创建设置支持使用VS.NET创建数据库 [ ^ ]

在安装.NET应用程序期间创建数据库 [ ^ ]

部署您的应用程序和数据库 [ ^ ]

hi friends

iam creating one windows application now i want to install that application on client side how can i install? how can i create a setup file with database,tables ans store procedure attach with that how can i change DataSource Name Client Side? and it is necessary client also have sql server database? please guys your answer is very helpful for me.

Have a look at these:
Creating setup With support for database creation Using VS.NET[^]
Create database during installation of a .NET application [^]
Deploy your Application and Database[^]