Formatting Dates From XML file - C# Discussion Boards

13-Nov-09 8:02

I am reading an XML file into a dataset to be used by the Report Viewer control.   Trouble is that I can't seem to format the date that is in the dataset.
Here is what I'm trying.   The date is the second column of the data table.

            private DataTable LoadData()
            {
                  // Load data from XML file
                  DataSet ds = new DataSet();
                  DataTable tbl;
                  string myFilePath = (Application.StartupPath + "\\bin\\" + "trd.xml");
                  ds.ReadXml(myFilePath);
                  tbl = ds.Tables[0];
                  foreach (DataRow row in tbl.Rows)
                  {
                        //reformat date
                        row[1] = String.Format("{0:g}", row[1].ToString());
                  }
                        return tbl;
            }

Any help is greatly appreciated
rafone

Statistics are like bikini's...
What they reveal is astonishing ...
But what they hide is vital ...

Not Active13-Nov-09 8:19

Not Active

13-Nov-09 8:19

Rafone wrote:
Trouble is that I can't seem to format the date that is in the dataset.

That's because you've failed to read the documentation[^]

G is general. What you want is d for the short format or D for the long format.

I know the language. I've read a book. - _Madmatt

Rafone13-Nov-09 8:33

13-Nov-09 8:33

Well having read the documentation numerous times it really does not mater how I format it the data row is not changing it remains with the formatting from the XML file

(d) Short date: . . . . . . {0 Big Grin | :-D

}
is for just the date

(g) General date/short time:. {0:g}
is for the date and time

the date in the XML is

<DateTime>2009-11-07T08:10:00-07:00</DateTime>

and remains even after trying to format it...?

thx
rafone

Statistics are like bikini's...
What they reveal is astonishing ...
But what they hide is vital ...

Not Active13-Nov-09 9:08

Not Active

13-Nov-09 9:08

You have to do a little more work, and understand the tools and language you are working with.

XML stores everthing as a string, the d formatting option however expects to work with DateTime.

row[1] = String.Format("{0:d}", DateTime.Parse(row[1].ToString() ));

It isn't even ncessary to use String.Format

row[1] = DateTime.Parse(row[1].ToString()).ToShortDateString();

I know the language. I've read a book. - _Madmatt

Rafone13-Nov-09 9:26

13-Nov-09 9:26

THX Mark that did the trick and turned on the lights

thx
rafone

Statistics are like bikini's...
What they reveal is astonishing ...
But what they hide is vital ...

Richard MacCutchan13-Nov-09 9:25

Richard MacCutchan

13-Nov-09 9:25

I wish, I really wish, I had a pound (or even a rupee) for every question like this. Someone, somewhere, is breeding a generation of coders who do not have the remotest idea of what a DateTime is. Try reading the documentation once more.

Rafone13-Nov-09 9:28

13-Nov-09 9:28

Richard;
Maybe we just don't have as much experience as some of you guys...

THX for all feedback
rafone

Statistics are like bikini's...
What they reveal is astonishing ...
But what they hide is vital ...

Richard MacCutchan13-Nov-09 9:55

Richard MacCutchan

13-Nov-09 9:55

Rafone wrote:
Maybe we just don't have as much experience as some of you guys...

Maybe you don't spend enough time reading the documentation first!

PIEBALDconsult13-Nov-09 12:50

PIEBALDconsult

13-Nov-09 12:50

(It's ISO 8601) Look at the o format.

Window forms

Morgs Morgan13-Nov-09 7:10

13-Nov-09 7:10

Hey people need some, have a 'main form' which calls a new form at some point and I don't want the 'new form'
to disappear when I click any where on the main form until I supply what is needed on the 'new form' - more
like what a MessageBox does, it produces the beep sound. How can I do this? Confused | :confused:

Xelalem13-Nov-09 7:19

Xelalem

13-Nov-09 7:19

for example --- to create a form when the MainForm loads
private void FormMain_Load(object sender, EventArgs e)
            {
                  Form2 NewForm = new Form2();
                  NewForm.Show(this);
            }

Morgs Morgan13-Nov-09 9:59

13-Nov-09 9:59

Thank you that was helpful... Wink | ;)

Eddy Vluggen13-Nov-09 7:20

Eddy Vluggen

13-Nov-09 7:20

Add a button on your main form, double-click on it, and put something like this in the eventhandler;

Form1 form1 = new Form1();
form1.ShowDialog(this);

Form1 should be the classname of your new form. You can edit that name in the properties-window.

form1 is a temporary variable that holds an instance of the class Form1.

Hope this helps Smile | :)

I are Troll Suspicious | :suss:

Paulo Zemek13-Nov-09 7:33

Paulo Zemek

13-Nov-09 7:33

To be more simple:
Use ShowDialog() instead of Show().

Morgs Morgan13-Nov-09 7:44

13-Nov-09 7:44

Thank you that helped!!! Laugh | :laugh:

Shameel13-Nov-09 7:39

Shameel

13-Nov-09 7:39

Form2.ShowDialog();

This will prevent you from using the main form until the second form is closed. If you want to work with both forms at the same time and keep the second form on top of the main form, use this:

Form2.Show(this);

Morgs Morgan13-Nov-09 9:53