create .exe of Windows C# App which includes SQl server 2008

Question

Hi all

I have created an application using Visual Studio 2010 c#, Sql server 2010.

i have tried method of publishing, but Its doesn't add databse to my .exe file.I have add all necessary references to .exe file

how to create .exe of my project so that at run time user can save, retrieve data in running application.

NAGARAJU TAMADA · Answer

thanks for your reply Iam working with Windowsform Application project and using MixedMode Authendication. userId:ramesh Password:ramesh

Iftikar Hussain · Answer

please get server ip address as your application will be run from different system. And also it will be required sql authentication i.e. user id and password Regards Iftikar

NAGARAJU TAMADA · Answer

Thanks for Your reply Here Server means ServerName? Database means Catalog name or .mdf file name? Iam using SqlServer2008R2 My serverName: ADMIN-PC my databse .mdf file name: Participant_crystal Please construct App.config file please reply to me regards Raju

Iftikar Hussain · Answer

here it is connectionString=server=SQLEXPRESS;database=YourDataBase;User Id=MyUserId;Password=MyPassword; providerName=System.Data.SqlClient/> Regards Iftikar

NAGARAJU TAMADA · Answer

Thanks for Your reply My project runs fine but database is not added to my project While running. How to include connectionstring property in App.config file? Regards raju

Sanjeeb Lenka · Answer

yes it support

NAGARAJU TAMADA · Answer

Is Windows7 support SqlServer2008R2? Regards NagaRaju T

Iftikar Hussain · Answer

you need to add the app.config file while creating the SETUP file. Please refer the below link http://www.msdotnet.co.in/2012/06/how-to-create-setup-fileexe-file-from.html Regards Iftikar

NAGARAJU TAMADA · Answer

Thanks for Your Answer I Have already added app.config also still database file is not running Here mu app.config file is --> invariant=System.Data.SqlServerCe.3.5> SQL Server Compact Data Provider invariant=System.Data.SqlServerCe.3.5 description=.NET Framework Data Provider for Microsoft SQL Server Compact type=System.Data.SqlServerCe.SqlCeProviderFactory System.Data.SqlServerCe Version=3.5.1.0 Culture=neutral PublicKeyToken=89845dcd8080cc91/> Please Solve this Regards Nagaraju T

Sanjeeb Lenka · Answer

no you can't add web.config in windows form. in windows form you can add app.confg which will work for windows form.

NAGARAJU TAMADA · Answer

Thanks For Your Reply But I working with C# WindowsApplication Project Sir.Can I use Web.config file in my Project.Please Let me Know The process

Iftikar Hussain · Answer

Hi Use web.config file for connection string thus you can change it easily without any modification in code. Use machine-name or IP instead of localhost if you want to connect your database from different system. Note: SQL Server and MySQL Server both are installed as server and it's better to install these application separately. Regards Iftikar