Display only date not datetime

Question

0.00/5 (No votes)

See more:

in CustomersBusinessObject i have like this.

C#

interface CustomersInterface

{

C#

DateTime joiningdate
        {
            get;
            set;
        }
}

public class Customers : ICustomersInterface
{

C#

public DateTime joiningdate
        {
            get
            {
                return _date;
            }
            set
            {
                _date = value;
            }
        }

}

in DAL

public List<customers> getcustomers()
{

try
{
List<customers> lstcustomers = new List<customers>();
SqlConnection con = new SqlConnection(constring);
cmd = new SqlCommand("SELECT empid, empname,departmentid, joiningdate, locationid, salary, jobid, Isworking from employee", con);
con.Open();
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
Customers cst = new Customers();
cst.employeeid = (int)dr[0];
cst.empname = (string)dr[1];
cst.departmentid = (int)dr[2];
cst.joiningdate = (DateTime)dr[3];
cst.locationid = (int)dr[4];
cst.salary = (int)dr[5];
cst.jobid = (int)dr[6];
cst.isworking = (bool)dr[7];
lstcustomers.Add(cst);
}
}
return lstcustomers;
}
catch (Exception ex)
{
throw;
}
here i want to display only date but it is coming datetime
where i should modify please help me
thank you.

Posted 14-Feb-12 17:47pm

sreekanth12

Add a Solution

7 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Maxxx_ · Answer 1 · 2012-02-14T17:55:00

Solution 1

You don't say HOW you are displaying the data, as a simple string, in some sort of date control?

Assuming it is as a string, then you can use

cst.Joiningdate.toString("dd/mm/yyyy")

for example

Posted 14-Feb-12 17:55pm

_Maxxx_

Sergey Alexandrovich Kryukov · Answer 2 · 2012-02-14T17:57:00

See System.DateTime.String methods: http://msdn.microsoft.com/en-us/library/system.datetime.aspx[^];
first of all, this one: http://msdn.microsoft.com/en-us/library/zdtaw1bw.aspx[^].

Learn format strings:
http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx[^],
http://msdn.microsoft.com/en-us/library/az4se3k1.aspx[^].

That's it.

—SA

Al Moje · Answer 3 · 2012-02-14T18:02:00

Hi,

I think there should no any modification to do in your code. In my opinion you should consider using format to display such...
Example:

C#

DateTime date1 = new DateTime(2008, 4, 10);
Console.WriteLine(date1.ToString("D", 
CultureInfo.CreateSpecificCulture("en-US")));
// Displays Thursday, April 10, 2008                        
Console.WriteLine(date1.ToString("D", 
CultureInfo.CreateSpecificCulture("pt-BR")));
// Displays quinta-feira, 10 de abril de 2008                        
Console.WriteLine(date1.ToString("D", 
CultureInfo.CreateSpecificCulture("es-MX")));
// Displays jueves, 10 de abril de 2008

You may refer into this

VB

Standard Date and Time Format Strings

link

Manish.Insan · Answer 4 · 2012-02-14T18:05:00

Solution 4

you can declare joiningdate as a string and then cast it to datetime when you are inserting in database.

C#

cst.joiningdate= DateTime.Now.ToShortDateString();

or

C#

cst.joiningdate= dr[3].ToString("mm/dd/yyyy");

Hope this will help you.

Posted 14-Feb-12 18:05pm

Manish.Insan

Member 7898423 · Answer 5 · 2012-02-14T18:14:00

Solution 5

You can set the format for retrieving the date in particular format.

C#

cst.joiningdate= dr[3].ToString("mm/dd/yyyy");

Posted 14-Feb-12 18:14pm

Member 7898423

Sudip Saha · Answer 6 · 2012-02-14T18:18:00

Solution 6

cst.joiningdate= string.Format("{0:mm/dd/yyyy}",dr[3])

Posted 14-Feb-12 18:18pm

Sudip Saha

AmitKumar89 · Answer 7 · 2012-02-14T18:31:00

Solution 7

Hi there..
Just replace your existing code
<pre lang="c#">cst.joiningdate = (DateTime)dr[3];</pre>

with

<pre lang="c#">cst.joiningdate = ((DateTime)dr[3]).ToShortDateString();</pre>

Try it.. All the best.. Accept answer if you like it.. :)

Posted 14-Feb-12 18:31pm

AmitKumar89

Comments

sreekanth12 15-Feb-12 1:29am

but it is giving error cannot implicitly convert type 'string' to System.date.time