Asp .Net Solution

put your format in dataformatstring  < asp : BoundField DataField = "Date" HeaderText = "Date" dataformatstring = "{0:dd-M-yyyy}" />

Put below script in sql Editor and change Database_Name to your Database name IF (NOT EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE ('[' + name + ']' = 'Database_Name' OR name = 'Database_Name'))) Begin CREATE DATABASE [Database_Name] ALTER DATABASE Database_Name MODIFY FILE ( NAME = N'Database_Name' , SIZE = 3048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) ALTER DATABASE Database_Name MODIFY FILE ( NAME = N'Database_Name' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) End