how to integrate SQl and .net framework in window applicatio

Question

i have create a window application and create its setup. but SQL server database not working in this application and also .net framework install Separately. can we integrate .net framework and SQL server in setup file so that no neet to install it separately ? so that when we install our setup automatic install .net framework and SQL?

Nitin Sharma · Answer

sorry but its not working

Manas Mohapatra · Answer

Step 1: Copy mdf file to your directory. Step 2: Then change app.config connection string(as per my previous answer) and points to directory. Note: If it doesn't resolve your problem copy also ldf file to that directory.

Nitin Sharma · Answer

my App.config file is as below: connectionString=Data Source=.;Initial Catalog=hts;Integrated Security=True providerName=System.Data.SqlClient /> than all page having this coding : SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[con].ConnectionString); i have copy past my MDF or LDF file in same folder with all forms. now what should i do ? or now i just follow the stepto create setup ?

Manas Mohapatra · Answer

As per your need there is a work around: you have to use mdf file in your directory and read update delete from that file. Follow below steps: Step 1: Add mdf file into your project directory using Add new Item option. Step 2: Add connection like below in web.config and you need to set mdf directory file path properly. C:\Development\blahBlah\App_Data\ SomeDataFile.mdf ; Integrated Security=True; Connect Timeout=30; User Instance=True /> Step 3: Follow what ever you are doing now to read data using SQLConnection object