Re: 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

13-Nov-09 9:53

Thankyou that helped Big Grin | :-D

Thread Abort

manustone13-Nov-09 7:06

manustone

13-Nov-09 7:06

Hi all
I want to handle the ThreadAbortException on my thread when some call to Abort happens.
Is there some ThradState where this cannot be possible ?
Right now I am thinking that only UNSTARTED state because Start method was not called.
Any guess?
Mn

Re: Thread Abort

Eddy Vluggen13-Nov-09 7:13

Eddy Vluggen

13-Nov-09 7:13

manustone wrote:
Any guess?

Better verify it with the list of ThreadStates in the documentation[^] than ask for guesses. Smile | :)

I are Troll Suspicious | :suss:

Again...Again...Again...

Xelalem13-Nov-09 6:19

Xelalem

13-Nov-09 6:19

I ve posted this message 3 times and noone said anything, if the question is not clear ask me please just someone help me
***********************************

am working on a large vocabulary continious speech recognition project for Amharic( Ethiopian) language using SAPI . i used the grammer class to bullid the neccesery grammer for the command mode and it worked with good accuarcy. the problame is with dectation mode. b/c there is no amharic SR engine, i want to adapt the english SR engine for amharic. my question is is there any way to capture the recognized phoneme of the speech using SAPI. not the recognized words... iwant to map the recognized phenomes to there equivalent amharic charcters. ..

Paulo Zemek13-Nov-09 6:32

Paulo Zemek

13-Nov-09 6:32

I think there is no answer because the people who see this don't know the answer.

I am an example. I had never used SAPI.

Not Active13-Nov-09 6:34

Not Active

13-Nov-09 6:34

Xelalem wrote:
I ve posted this message 3 times and noone said anything

That should give you the hint to stop posting it then.

We are not required to answer any question posted here. If there was a need for clarification someone would have asked for it. Most people here will not respond unless they have something to contribute.

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

Saksida Bojan13-Nov-09 6:58

Saksida Bojan

13-Nov-09 6:58

This forum is for windows OS. I don't know witch os Your mobile uses, but Here I doubt if anyone could help you, because very few would go that far to write for Mobile. Since when you said SAPI(Speech Application Programming Interface). I probably know what it is, but never used. But I don't know anything about "amharic SR engine".