How to connect database SQL server 2008 with visual studio 2010
SQL server very critical function for every online server server provider. In computer software development , The database create and database design is most important part .Any software must have database , It has to design and connect it with a interfacing IDE (Integrated Development Environment) . Desktop based software development and web based software development must have to connect database . Database connection is the major issue and a problem in computer software programming . In this session we have described about database connection with Visual Studio 2010 in C sharp language .If we can not connect database properly , it must be create problem in the time while we want to create an EXE file for installing the database software in our real application .
Here the database name is DUCT.mdf and it saved in drive D and the folder of the database name is db. A Gateway class is used for handling the connection string . Here also a Gateway constructor for initialize the class. It is format of object oriented programming and also used for tips and tricks for software development using computer.
public class Gateway
string connectionString = @”server = .\D:\db\DUCT.mdf; integrated security = SSPI;”;
public string GetConnection()