date format should be dd/Jan/2012 in gridview code

 
 i inserted all the record in the database.

database type as

DOB             datetime
Wedding day      datetime

i have one button view.when i click that button all record should be displayed in the Grid View.

Grid view  Button code as follows;

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            [email protected]


but i want the output in 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 dont want like)

i want as
DOB           Wedding
22/dec/1986    22/dec/2009 (iwant like)


Name        DOB               Mobile no        Wedding day               Email
ram        22/dec/1986        9945598565        22/dec/2009            [email protected]


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    [email protected]