Connecting to Sql on Visual Studio,Sql with C sharp

Connecting Visual Studio C charp with Sql.

Download Sample Project

Download Sample Project2

Prerequisites:

Vs2013, Sql Server 

Sample Create table Script.

CREATE TABLE country (
  Code varchar(100) NOT NULL DEFAULT '0',
  BranchCode varchar(100) DEFAULT NULL,
  Country varchar(50) DEFAULT NULL,
  ShortDescription varchar(20) DEFAULT NULL
  PRIMARY KEY (Code)
)

Insert table Script.

insert into country (Code,BranchCode,Country,ShortDescription)values(1,1,'INDIA','IN');
insert into country (Code,BranchCode,Country,ShortDescription)values(2,1,'PAK','PA');
insert into country (Code,BranchCode,Country,ShortDescription)values(3,2,'CHINA','CHI');

Select Query

select * from country

Result:

Visual Studio connected with sql: