i inserted all the record in the database.
i have one button view.when i click that button all record should be displayed in the Grid View.
Grid view Button Query 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 12:00:00 AM 9945598565 22/12/2009 12:00:00 AM ram@gm.com
but i want the output in grid view related to DOB and Wedding day date to be shown as
Name DOB Mobile no Wedding day Email
ram 22/12/1986 9945598565 22/12/2009 ram@gm.com
Not needed a
DOB Wedding Day
12:00:00 AM 12:00:00 AM
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 outputvvas follows
Name DOB Mobile no Wedding day Email
ram 22/12/1986 9945598565 22/12/2009 ram@gm.com