Date format of dd/Jan/2012

See more:

C#

I inserted all the records in the database.

database type as

DOB             datetime
Wedding day     datetime

I have a button view and when I click that button all records should be displayed in the Grid View.

Grid view Button code as follows:
SQL

Sql = "select Name,DOB,Mobileno,Weddingday,Email from BIrthDayWish where Active = 'A' ORDER BY Name";
        Dr = SCon.ReadSql(Sql);
        GridView1.DataSource = Dr;
        GridView1.DataBind();
        GridView1.Visible = true;

output in Grid View as follows

Name        DOB               Mobile no        Wedding day               Email
ram       22/12/1986          9945598565       22/12/2009            ram@gm.com

But I would like the output in the grid view related to DOB and Wedding day date month to be shown as in char (Jan,Feb like that)

DOB           Wedding
22/12/1986    22/12/2009 (I don't want like)

I want it as

DOB           Wedding
22/dec/1986    22/dec/2009 (I want like)

Name        DOB               Mobile no        Wedding day               Email
ram        22/dec/1986        9945598565        22/dec/2009            ram@gm.com

SQL

Sql = "select Name,DOB,Mobileno,Weddingday,Email from BIrthDayWish where Active = 'A' ORDER BY Name"

From my above query how to correct the query and get the output as follows

Name    DOB           Mobile no     Wedding day       Email
ram    22/dec/1986    9945598565     22/dec/2009    ram@gm.com