How Can I Change The Format Of Date In A Dataset

Question

0.00/5 (No votes)

See more:

Hi frnds,
I want to change the format of date field to any desired format after filling the data into a DataSet. Anyone can say a simple way to achieve this.

C#

mySQLConnection = new SqlConnection(S"Data Source=(local);Initial Catalog=myDb;User Id=user;Password=pw;");
mySQLConnection->Open();
myDataSet = new DataSet("Sample");

myDataAdapter = new SqlDataAdapter(S"select * from SampleTable",mySQLConnection);
myDataAdapter->Fill (myDataSet,"SampleTable");

dt = myDataSet->Tables->Item["SampleTable"];

dt->Columns->get_Item("DateField")->Format("mm/dd/yyyy hh:mi:ss") // this is not availabe now

Is there any idea to change the format in this way?? or any other way without having an iteration through all fields??

Posted 18-Nov-14 18:27pm

Member 11168418

Add a Solution

Comments

Sinisa Hajnal 19-Nov-14 2:36am

Is this date field or string? If it is a string then you have no choice but to iterate through and change each one OR format it before it fills the dataset. If it is a date, leave it as is and format it just in time for presentation layer (that is, when you're showing it to the user.

In general, holding dates as string is TERRIBLE design that should be changed as soon as possible.

Member 11168418 19-Nov-14 2:45am

This is date field actually. I want to save it to an xml (say, sample.xml) file, but before that the format should be changed. How can i achieve this.?
When i use, myDataSet->WriteXml("sample.xml");, the date is displayed like, <datetime>2014-04-22T09:37:18+05:30. But i want to display it in other format too like mm/dd/yyy hh:mi:ss or dd/mm/yyyy hh:mi:ss. I am not changing the data type to String, it resides as DateTime.

Sinisa Hajnal 19-Nov-14 3:55am

Hmmm...options
1. Write your own WriteXML? Then you can change the data as you see fit.
2. Add new column to the dataset and return string in suitable format from the datasource.
3. Add new computed column to the dataset in your code - with computed being formatted string
4. Not sure if there are properties to affect output format on the dataset column, try it.

I cannot help you more unless I re-create the situation and play with it (sorry, no time for that) :(

Member 11168418 19-Nov-14 4:04am

ok, thats fine. Thank you for ur information. Let me try these options. :)

Sinisa Hajnal 19-Nov-14 4:09am

Try 2 first, it is the fastest one and simplest. Then 3.

Member 11168418 20-Nov-14 6:52am

I just started using C++.Net, dont know much about this. I tried the following,

<pre lang="sql">column = new DataColumn("NewColumn",System::DateTime);
dt->Columns->Add(column);
row = dt->NewRow();
row("NewColumn") = "Test";
dt->Rows->Add(row);
myDataSet->Tables->Add(dt);</pre>
I tried to add a column like this, but i got the following runtime exception.

System.ArgumentNullException: 'dataType' argument cannot be null.
Parameter name: dataType
at System.Data.DataColumn..ctor(String columnName, Type dataType, String expr
, MappingType type)
at System.Data.DataColumn..ctor(String columnName, Type dataType)

Sinisa Hajnal 20-Nov-14 7:01am

Please use Improve question link instead of posting code into comments. Thank you.

Member 11168418 20-Nov-14 7:10am

I wasn't knowing about it, sorry.

Sinisa Hajnal 20-Nov-14 7:03am

You need to specify column datatype, your datatype should be String, not datetime...this assumes you don't want to use option #2

yYou shouldn't add empty row with new column...you just add the column to datatable and you're done. Now you have to fill it.

Member 11168418 20-Nov-14 7:12am

I got same error when i give String datatype. Should i mention the data type? is there any error in my code in mentioning that?

Sinisa Hajnal 20-Nov-14 7:28am

I'm not familiar enough with C++ (it was long time ago) to say definitely, but you cannot just pass System::String, you need to pass Typeof( System::String) or GetType or however else you get instance of System::Type in C++

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)