C# Discussion Boards - CodeProject

2-Sep-09 23:03

Hi all,

I am trying to make use of XElement instead of XmlWriter, but I am experiencing some hickups ... Sigh | :sigh:

The XmlWriter code works perfectly .. here it is:

// write the controller element and attributes
foreach (var controller in ControllerList)
{
    w.WriteStartElement("controller");
    w.WriteAttributeString("name", controller.Value.ControllerName);
    w.WriteAttributeString("description", controller.Value.ControllerDescription);
    w.WriteAttributeString("area", controller.Value.ControllerArea);
    w.WriteAttributeString("startdate", DateTimeClass.DateTimeYearMonthDay(controller.Value.StartDate));
    w.WriteAttributeString("enddate", DateTimeClass.DateTimeYearMonthDay(controller.Value.EndDate));
    w.WriteAttributeString("updatemode", controller.Value.UpdateMode);

    // write the reader element and attributes
    foreach (var reader in controller.Value.ReaderList)
    {
        w.WriteStartElement("reader");
        w.WriteAttributeString("name", reader.Value.ReaderName);
        w.WriteAttributeString("readergroup", reader.Value.ReaderGroup);
        w.WriteAttributeString("host", reader.Value.ReaderHost);
        w.WriteAttributeString("type", reader.Value.ReaderType);
        w.WriteAttributeString("startdate", DateTimeClass.DateTimeYearMonthDay(reader.Value.StartDate));
        w.WriteAttributeString("enddate", DateTimeClass.DateTimeYearMonthDay(reader.Value.EndDate));
        w.WriteAttributeString("description", reader.Value.ReaderDescription);
        // end the reader element
        w.WriteEndElement();
    }
    // end the controller element
    w.WriteEndElement();
}

-- XmlWriter Output --
	  <building plant="Rosslyn" name="0.20/0.90.11.9/plant2/HQ" description="Plant2" X="206" Y="209" Width="67" Height="56">
		<controller name="Za12436" description="Test Controller" area="D" startdate="20090902" enddate="99981231" updatemode="D">
		  <reader name="A123" readergroup="GFT" host="Za12436" type="C" startdate="20090902" enddate="99981231" description="Test reader 1" />
		  <reader name="A345" readergroup="DRG" host="Za12436" type="C" startdate="20090902" enddate="99981231" description="Test Reader 2" />
		  <reader name="A567" readergroup="HYG" host="Za12436" type="C" startdate="20090902" enddate="99981231" description="Test redscsc 3" />
		</controller>
		<controller name="ZA324578" description="Controller 2" area="F" startdate="20090902" enddate="99981231" updatemode="D">
		  <reader name="B235" readergroup="BGYT" host="ZA324578" type="C" startdate="20090902" enddate="99981231" description="JJjksjcklsljcl" />
		  <reader name="B658" readergroup="hjkhkk" host="ZA324578" type="C" startdate="20090902" enddate="99981231" description="khkhk" />
		  <reader name="B730" readergroup="GFT" host="ZA324578" type="C" startdate="20090902" enddate="99981231" description="khkhkh" />
		</controller>
	  </building>

but the XElement code does not produce the same results .. It appends the data to the first controller node OMG | :OMG:

... here is the code:

foreach (var controller in ControllerList)
{
    xElement.Element("plant").Element("building").Add(new XComment(String.Format("Controller: {0} Declaration", controller.Key)));
    xElement.Element("plant").Element("building").Add(new XElement("controller",
        new XAttribute("name", controller.Value.ControllerName),
        new XAttribute("description", controller.Value.ControllerDescription),
        new XAttribute("area", controller.Value.ControllerArea),
        new XAttribute("startdate", DateTimeClass.DateTimeYearMonthDay(controller.Value.StartDate)),
        new XAttribute("enddate", DateTimeClass.DateTimeYearMonthDay(controller.Value.EndDate)),
        new XAttribute("updatemode", controller.Value.UpdateMode)
        ));
    // write the reader element and attributes
    foreach (var reader in controller.Value.ReaderList)
    {
        xElement.Element("plant").Element("building").Element("controller").Add(new XElement("reader",
            new XAttribute("name", reader.Value.ReaderName),
            new XAttribute("readergroup", reader.Value.ReaderGroup),
            new XAttribute("host", reader.Value.ReaderHost),
            new XAttribute("type", reader.Value.ReaderType),
            new XAttribute("startdate", DateTimeClass.DateTimeYearMonthDay(reader.Value.StartDate)),
            new XAttribute("enddate", DateTimeClass.DateTimeYearMonthDay(reader.Value.EndDate)),
            new XAttribute("description", reader.Value.ReaderDescription)
            ));
    }
}

-- xElement Output --
	  <building plant="Rosslyn" name="0.20/0.90.11.9/plant2/HQ" description="Plant2" X="206" Y="209" Width="67" Height="56">
		<controller name="Za12436" description="Test Controller" area="D" startdate="20090902" enddate="99981231" updatemode="D">
		  <reader name="A123" readergroup="GFT" host="Za12436" type="C" startdate="20090902" enddate="99981231" description="Test reader 1" />
		  <reader name="A345" readergroup="DRG" host="Za12436" type="C" startdate="20090902" enddate="99981231" description="Test Reader 2" />
		  <reader name="A567" readergroup="HYG" host="Za12436" type="C" startdate="20090902" enddate="99981231" description="Test redscsc 3" />
		  <reader name="B235" readergroup="BGYT" host="ZA324578" type="C" startdate="20090902" enddate="99981231" description="JJjksjcklsljcl" />
		  <reader name="B658" readergroup="hjkhkk" host="ZA324578" type="C" startdate="20090902" enddate="99981231" description="khkhk" />
		  <reader name="B730" readergroup="GFT" host="ZA324578" type="C" startdate="20090902" enddate="99981231" description="khkhkh" />		  
		</controller>
		<controller name="ZA324578" description="Controller 2" area="F" startdate="20090902" enddate="99981231" updatemode="D" />
	  </building>

What am I doing wrong??

Many thanks in advance.
Kind regards,

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

Keith Barrow2-Sep-09 23:28

Keith Barrow

2-Sep-09 23:28

xElement.Element("plant").Element("building") is returning the 1st building tag in the XML. Similarly xElement.Element("plant").Element("building").Element("controller") returns the 1st controller, so all readers will be added to the first controller element in the XML.

You will be better off creating the controller element in the foreach (var controller in ControllerList) loop, adding it to the building. Adding the reader elements to the controller element you have just created inside the foreach (var reader in controller.Value.ReaderList) should fix your problem.

Programm3r2-Sep-09 23:37

2-Sep-09 23:37

Hi Keefb,

Thanks for the response and the input.

keefb wrote:
You will be better off creating the controller element in the foreach (var controller in ControllerList) loop, adding it to the building.

Makes sense ... thanks, lets see what I can do

Kind regards,

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

Keith Barrow2-Sep-09 23:43

Keith Barrow

2-Sep-09 23:43

No probs. You should also find that, by creating the elements in the loop, you will be able to Factor out somthing like MakeControllerElement and MakeReaderElement methods. This will help the readability / maintainability of the code (always a problem when creating classes to build XML in my experience).

Programm3r3-Sep-09 0:31

3-Sep-09 0:31

Will keep that in mind... thanks again.

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

Programm3r3-Sep-09 1:42

3-Sep-09 1:42

--- XElement Code ---

foreach (var controller in ControllerList)
{
    xElement.Element("plant").Element("building").Add(new XComment(String.Format("Controller: {0} Declaration", controller.Key)));

    XElement con = new XElement("controller",
        new XAttribute("name", controller.Value.ControllerName),
        new XAttribute("description", controller.Value.ControllerDescription),
        new XAttribute("area", controller.Value.ControllerArea),
        new XAttribute("startdate", DateTimeClass.DateTimeYearMonthDay(controller.Value.StartDate)),
        new XAttribute("enddate", DateTimeClass.DateTimeYearMonthDay(controller.Value.EndDate)),
        new XAttribute("updatemode", controller.Value.UpdateMode)
        );
    // write the reader element and attributes
    foreach (var reader in controller.Value.ReaderList)
    {
        con.Add(new XElement("reader",
            new XAttribute("name", reader.Value.ReaderName),
            new XAttribute("readergroup", reader.Value.ReaderGroup),
            new XAttribute("host", reader.Value.ReaderHost),
            new XAttribute("type", reader.Value.ReaderType),
            new XAttribute("startdate", DateTimeClass.DateTimeYearMonthDay(reader.Value.StartDate)),
            new XAttribute("enddate", DateTimeClass.DateTimeYearMonthDay(reader.Value.EndDate)),
            new XAttribute("description", reader.Value.ReaderDescription)
            ));
    }

    xElement.Element("plant").Element("building").Add(con);
}

 <br />
<br />
<div class="ForumSig"><br />
<table width="100%" align="center"><tbody><tr><td>  <font color="#FF9900">The only programmers that are better C# programmers, are those who look like this -> :bob:</font></td></tr></tbody></table> <br />
<br />
  <font color="#429DFF"><br />
:java: Programm3r</font><br />
My Blog: <a href="http://www.codeproject.com/script/profile/whos_who.asp?msg=1917620&id=2823228#xx1917620xx">^_^</a></div>

Keith Barrow3-Sep-09 2:15

Keith Barrow

3-Sep-09 2:15

How about:

XElement CreateReaderElement(ReaderType reader)
{
    return new XElement("reader",
            new XAttribute("name", reader.ReaderName),
            new XAttribute("readergroup", reader.ReaderGroup),
            new XAttribute("host", reader.ReaderHost),
            new XAttribute("type", reader.ReaderType),
            new XAttribute("startdate", DateTimeClass.DateTimeYearMonthDay(reader.StartDate)), new XAttribute("enddate", DateTimeClass.DateTimeYearMonthDay(reader.Value.EndDate)),
            new XAttribute("description", reader.ReaderDescription));
}

XElement CreateControllerElement(ControllerType controller)
{
    new XElement("controller",
                new XAttribute("name", controller.ControllerName),
                new XAttribute("description", controller.ControllerDescription),
                new XAttribute("area", controller.ControllerArea),
                new XAttribute("startdate", DateTimeClass.DateTimeYearMonthDay(controller.StartDate)),
                new XAttribute("enddate", DateTimeClass.DateTimeYearMonthDay(controller.EndDate)),
                new XAttribute("updatemode", controller.UpdateMode));
}
        
void AddComment(XElement target, string format, params object[] args)
{
    target.Add(new XComment(String.Format(format, args)));
}

void Foo(string[] args)
{
    //...    
    XElement xElement;
    foreach (var controller in ControllerList)
    {                
        AddComment(xElement.Element("plant").Element("building"), "Controller: {0} Declaration", controller.Key);
        XElement con = CreateControllerElement(controller.Value);
        // write the reader element and attributes
        foreach (var reader in controller.Value.ReaderList)
            con.Add(CreateReaderElement(reader.Value));
        xElement.Element("plant").Element("building").Add(con);            
    }
    //...
}

Where the italicised stuff are types / method names I can't determine.

Programm3r3-Sep-09 3:21

Update the XElement - Question

3-Sep-09 3:21

Great stuff ... Thanks for all your input.

Kind regards,

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

Programm3r3-Sep-09 5:04

3-Sep-09 5:04

Hi all,

I have written all the data to the XML file. Now I read the XML data in to a XElement. I want to add a new controller to the second plant within the XML data, but it keeps adding it to the first plant. I know why ... I just don't know how I can add it to the second plant ... could anyone please help me out with this one?

<root>
  <!--First Plant-->
  <plant>
	<!--First Building in Plant 1-->
    <building>
      <controller>
        <reader/>
      </controller>
      <controller>
        <reader/>
      </controller>
    </building>
	<!--Second Building in Plant 1-->
    <building>     
      <controller>
        <reader/>
      </controller>
      <controller>
        <reader/>
      </controller>
    </building>
  </plant>
  <!--Second Plant-->
  <plant>
	<!--First Building in Plant 2-->
    <building>
      <controller>
        <reader/>
      </controller>
      <controller>
        <reader/>
      </controller>
    </building>
  </plant>	
</root>

Many thanks in advance
Kind regards,

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

PIEBALDconsult3-Sep-09 6:30

PIEBALDconsult

3-Sep-09 6:30

What the heck is an XElement?

Programm3r7-Sep-09 2:20

Navigating Internet Explorer

7-Sep-09 2:20

See XElement Class (System.Xml.Linq)[^] ...

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

Vijay Mudunuri2-Sep-09 22:50

Vijay Mudunuri

2-Sep-09 22:50

Hai friends,

I tried to open IE using the following code,

SHDocVw.InternetExplorer ie = new SHDocVw.InternetExplorerClass();
IWebBrowserApp wb = (IWebBrowserApp) ie;
wb.Visible = false;
object o = null;
wb.Navigate(url, ref o, ref o, ref o, ref o);

My questions is, using similar logic can I move IE to back and Forward.
Please suggest me any method to that.

Re: Navigating Internet Explorer

Jacobb Michael2-Sep-09 23:31

Jacobb Michael

2-Sep-09 23:31

Hey

i can suggest, you can have two stacks for Forward and Backward

using that stack the URLs and navigate programaticaly

thanks

Re: Navigating Internet Explorer

Vijay Mudunuri3-Sep-09 2:00

Vijay Mudunuri

3-Sep-09 2:00

Thanks for your reply jasome,

But I want to use "GoBack()" and "GoForward()" functions of "SHDocVw.InternetExplorer".

connectionstring

sepehr_sepehr2-Sep-09 22:13

sepehr_sepehr

2-Sep-09 22:13

I want to connect to a DataBase and then add table to this database in runtime,
my code is:
private void button1_Click(object sender, EventArgs e)
{
string strsql = "create table tbl_" + textBox1.Text + "(tbl_id bigint identity(1,1) primary key)";
SqlConnection connection = new SqlConnection(@"Data Source=YOUR-6BBD24890A\Q;Initial Catalog=sepehr;Integrated Security=True;User Instance=True");
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = strsql;

connection.Open();
command.ExecuteNonQuery();
connection.Close();
toolStripStatusLabel1.Text = "Table Added To DataBase";

}
what's this error???
A user instance was requested in the connection string but the server specified does not support this option.
Changed database context to 'master'.
Changed language setting to us_english.

please help me as soon as possible Frown | :(

Re: connectionstring

Mohammad Dayyan2-Sep-09 22:22

http://www.dofactory.com/Connect/Connect.aspx[^]

2-Sep-09 22:22

An issue in windows service ?

Mohammad Dayyan2-Sep-09 21:59

2-Sep-09 21:59

Hi.

I've created a windows service and installed it. ( I saw it in Computer Management -> Services )
Then I've started it with following code :

static void StartService(string serviceName, int timeoutMilliseconds)
{
    ServiceController service = new ServiceController(serviceName);
    try
    {
        TimeSpan timeout = TimeSpan.FromMilliseconds(timeoutMilliseconds);

        service.Start();
        service.WaitForStatus(ServiceControllerStatus.Running, timeout);
    }
    catch (Exception ex)
    {
        Console.WriteLine(ex.Message);
    }
}

There are two methods in my windows service :

protected override void OnStart()
{
    // Create a text file C:\temp\mcb.txt 
    FileStream fs = new FileStream(Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + @"\mds.txt", FileMode.OpenOrCreate, FileAccess.Write);
    StreamWriter m_streamWriter = new StreamWriter(fs);
    m_streamWriter.BaseStream.Seek(0, SeekOrigin.End);
    m_streamWriter.WriteLine(" mcWindowsService: Service Started \n");
    m_streamWriter.Flush();
}

protected override void OnStop()
{
    // Create a text file C:\temp\mcb.txt 
    FileStream fs = new FileStream(Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + @"\mds.txt", FileMode.OpenOrCreate, FileAccess.Write);
    StreamWriter m_streamWriter = new StreamWriter(fs);
    m_streamWriter.BaseStream.Seek(0, SeekOrigin.End);
    m_streamWriter.WriteLine(" mcWindowsService: Service Stopped \n");
    m_streamWriter.Flush();
}

But nothing is done !!!
I mean when I start it OnStart() doesn't execute.
What's wrong with it ?
Could you please guide me ?

Thanks.

Re: An issue in windows service ? [modified]

N a v a n e e t h3-Sep-09 0:23

N a v a n e e t h

3-Sep-09 0:23

Is this service installed? Are you able to start it from service control manager? Are you getting any error?

Navaneeth

How to use google | Ask smart questions

Mohammad Dayyan3-Sep-09 1:22

3-Sep-09 1:22

N a v a n e e t h wrote:
Is this service installed?

Yeah, It was installed currently, I can see it in Computer Management -> Services but I can't start it from there. I don't know why and I don't getting any errors !
BTW : I've set StartType property to Automatic .

modified on Thursday, September 3, 2009 7:30 AM

Re: An issue in windows service ? [modified]

N a v a n e e t h3-Sep-09 5:43

N a v a n e e t h

3-Sep-09 5:43

Try to wrap the file writing code in try/catch and write the exception in to event log. Also try with a hardcoded path something like C:\mcb.txt. I guess problem will be with the line Environment.GetFolderPath(Environment.SpecialFolder.Desktop). You may need to turn Allow service to interact with Desktop option. Right click on your service and choose Properties -> Logon Tab -> Allow service to interact with desktop.

Your file writing code can also be improved. Here is an improved version.

string path = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Desktop), "\mds.txt")
using(StreamWriter writer = File.CreateText(path))
{
    writer.WriteLine("mcWindowsService: Service Started \n");
}

Navaneeth

How to use google | Ask smart questions

Mohammad Dayyan4-Sep-09 0:49

4-Sep-09 0:49

Great, It works.
Thanks a lot N a v a n e e t h

I've test with C drive.

N a v a n e e t h wrote:
You may need to turn Allow service to interact with Desktop option. Right click on your service and choose Properties -> Logon Tab -> Allow service to interact with desktop.

~~Where is Logon Tab ?~~
I've found it. Can we do it programmatic ?

modified on Friday, September 4, 2009 6:56 AM

N a v a n e e t h4-Sep-09 5:57

N a v a n e e t h

4-Sep-09 5:57

Mohammad Dayyan wrote:
I've found it. Can we do it programmatic ?

Not sure.

Navaneeth

How to use google | Ask smart questions

Mohammad Dayyan4-Sep-09 6:32

4-Sep-09 6:32

Thanks anyway