how to integrate SQl and .net framework in window applicatio

Nitin Sharma

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?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sharma11y ago
sorry but its not working
0
Manas Mohapatra11y ago
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.
0
Nitin Sharma11y ago
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 ?
0
Manas Mohapatra11y ago
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
0