Date data type in Asp.net using C#

Question

Hi
I'm doing my project in asp.net using C# and sql server 2008.
when i display the information in grid view by default it show the time value as 04/19/2014 12:00:00 AM how to change it to current system time, Or i no need to display the time in that grid view. please help me.
My Table created format is
create table sigup(id int, name varchar(20), date date, address varchar(50));
pls share the solution in for this
my mail id [email protected]
thank you
karthigeyan.S

Ranjit Powar · Answer

Hi Convert date in select query as follows convert(varcharColumn name101) As Column name

Jignesh Trivedi · Answer

hi try... dataformatstring={0:MMMM d yyyy} htmlencode=false /> also refer http://www.codeproject.com/Tips/44103/Data-formatting-in-GridView hope this will help you.

Abhay Shanker · Answer

Add the record in database as below:- System.DateTime.Now.ToString() Display the date in Gridview as below:- ' >

Munesh Sharma · Answer

If you want to show time or date as current system then use it.. Protected void Page_Load(object sender EventArgs e) { textbox1.text = System . DateTime . Now . ToString () // for complete time and date textbox2.text = System . DateTime . Now . ToShortDateString (); // for showing date textbox3.text = System . DateTime . Now . ToShortTimeString (); // for showing Time } If you Don't want to show time in grid view then you have to write query select id name  address from tablename