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