How to Create Connection Using SQL Server

In this article I am going to explain about how to create connection string using SQL server.
  • 2616

Introduction

Here I am explaining how to create connection string using SQL server and SQL Server basically used for creating database in .NET . To create connection string using SQL server instance in .NET Framework we need to put instance name, database name and set the state of Trusted connection true .

Syntax  

Server=urServerName\theInstanceName;Database=urDataBase;Trusted_Connection=True;


Example

Server=inst;Database=db;Trusted_Connection=True;


You may also want to read these related articles :

Ask Your Question 

Got a programming related question? You may want to post your question here

Programming Answers here

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.