date data type how to read

Question

0.00/5 (No votes)

See more:

C#

dateFrom = Convert.ToDateTime(dr["DateFrom"]).ToString("dd/MM/yyyy");

I store my variable as string

Posted 5-Feb-14 23:21pm

Member 10574155

Add a Solution

Comments

CPallini 6-Feb-14 5:24am

What you need to do? It is not clear to me, please elaborate.

Member 10574155 6-Feb-14 6:08am

retrieve my data to a gridview, but my date is stored as a date data type, I declare it as string variable

agent_kruger 8-Feb-14 4:01am

what do you want us to do with this code, sir?

2 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)

Member 10322562 · Answer 1 · 2014-02-05T23:38:00

Solution 1

DateTime dt = new DateTime();
dt = Convert.ToDateTime(dr["DateFrom"]);
string dateFrom = dt.ToString("dd/MM/yyyy");

Posted 5-Feb-14 23:38pm

Member 10322562

Er. Ajay Chauhan · Answer 2 · 2014-02-05T23:51:00

Solution 2

This is the syntax:

C#

dateFrom = Convert.ToDateTime(dr["DateFrom"].ToString()).ToString("dd/MM/yyyy");

but actually I did not get that what do you want to ask...??

Posted 5-Feb-14 23:51pm

Er. Ajay Chauhan

Updated 5-Feb-14 23:52pm

v2

Comments

Member 10574155 6-Feb-14 6:08am

but this statement is giving me error, I cannot read my values

Er. Ajay Chauhan 6-Feb-14 6:32am

can you elaborate what are you upto....??

Er. Ajay Chauhan 6-Feb-14 7:14am

simply use dr["DateFrom"].ToString();

Member 10574155 6-Feb-14 7:03am

Reading a date value from database

Member 10574155 6-Feb-14 7:21am

How can .ToString() when it is a date data type in the database?

Er. Ajay Chauhan 6-Feb-14 8:08am

because when retrieve from database through DataReader Object, it returns a object and in object any value can be fetched as string... after that we can convert it to any suitable type of DataType...

Member 10574155 6-Feb-14 8:28am

Cannot. Is this the problem also my sql command , my date from is like this cmd.Parameters.AddWithValue("DateFrom", _dateFrom);

Er. Ajay Chauhan 6-Feb-14 8:59am

so whats the different....
are you getting some error, if yes then give error here....