Connecting to Mysql on Visual Studio,Mysql with C sharp

Connecting Visual Studio C charp with Mysql.

Download Sample Project

Prerequisites:

Vs2013, Mysql 

Sample 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,
  isActive tinyint(1) DEFAULT 0,
  CreatedBy varchar(100) DEFAULT '0',
  CreatedOn datetime(6) DEFAULT NULL,
  LastUpdatedBy varchar(100) DEFAULT NULL,
  LastUpdatedOn datetime(6) DEFAULT NULL,
  CanceledBy varchar(100) DEFAULT NULL,
  CanceledOn datetime(6) DEFAULT NULL,
  IsCanceled tinyint(1) DEFAULT 0,
  PRIMARY KEY (Code)
)

Mysql Table.

Visual Studio: