XElement vs XmlWriter Question - C# Discussion Boards

Cannot save changes to code programatically

rastaVnuce2-Sep-09 23:56

2-Sep-09 23:56

I'm writing a VS add-on which, on activation, is supposed to add a couple of attributes in the App.xaml.
The problem I get is, when App.xaml is opened for editing, everything works fine.
But, if App.xaml isn't opened the changes aren't saved. I went through the code, it still goes through it like it should, it adds the attributes like it should, it even executes the line of code that's supposed to save the changes, except... changes aren't saved Frown | :(

This is an overview of what i do:

<br />
codeState.editPoint.StartOfDocument();<br />
string xmlText = codeState.editPoint.GetText(codeState.textDoc.EndPoint);<br />
<br />
--- add a couple of attributes using XmlDocuments<br />
--- save the changes into a memory stream<br />
<br />
codeState.editPoint.ReplaceText(codeState.textDoc.EndPoint, reader.ReadToEnd(), 0);<br />

Any ideas why?

Where it seems there are only borderlines, Where others turn and sigh, You shall rise!

Re: Cannot save changes to code programatically

stancrm3-Sep-09 0:55

stancrm

3-Sep-09 0:55

I think, you must ask at WPF forum.

Re: Cannot save changes to code programatically

rastaVnuce3-Sep-09 0:59

rastaVnuce

3-Sep-09 0:59

It's not really a WPF issue. The file just happens to be xaml, the problem would persist no matter the file type.
I thought of asking this in the Visual Studio forum, since I am working on a Visual Studio add-on... but, that's more of a "using" forum, than programming.

Where it seems there are only borderlines, Where others turn and sigh, You shall rise!

Re: Cannot save changes to code programatically

Richard MacCutchan3-Sep-09 2:37

Richard MacCutchan

3-Sep-09 2:37

rastaVnuce wrote:
It's not really a WPF issue.

Nor is it a C# issue, please post to the correct forum i.e. Visual Studio.

pass multiplae parameter in crystal report

mjawadkhatri2-Sep-09 23:20

mjawadkhatri

2-Sep-09 23:20

hi,
how pass multiple parameter in crystal report through c#???

Re: pass multiplae parameter in crystal report

Calla3-Sep-09 0:44

Calla

3-Sep-09 0:44

Writing your exact sentence in Google gave this link [^] as the number one hit... You should try it!

Re: pass multiplae parameter in crystal report

OriginalGriff3-Sep-09 1:06

OriginalGriff

3-Sep-09 1:06

Try here [^]- you may find it useful in cases like this...

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

XElement vs XmlWriter Question

Programm3r2-Sep-09 23:03

Programm3r

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: ^_^

Re: XElement vs XmlWriter Question

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.

Re: XElement vs XmlWriter Question

Programm3r2-Sep-09 23:37

Programm3r

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: ^_^

Re: XElement vs XmlWriter Question

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

Re: XElement vs XmlWriter Question

Programm3r3-Sep-09 0:31

Programm3r

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: ^_^

Re: XElement vs XmlWriter Question

Programm3r3-Sep-09 1:42

Programm3r

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>

Re: XElement vs XmlWriter Question

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.

Re: XElement vs XmlWriter Question

Programm3r3-Sep-09 3:21

Programm3r

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: ^_^

Update the XElement - Question

Programm3r3-Sep-09 5:04

Programm3r

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: ^_^

Re: XElement vs XmlWriter Question

PIEBALDconsult3-Sep-09 6:30

PIEBALDconsult

3-Sep-09 6:30

What the heck is an XElement?

Re: XElement vs XmlWriter Question

Programm3r7-Sep-09 2:20

Programm3r

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: ^_^

Navigating Internet Explorer

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

Mohammad Dayyan

2-Sep-09 22:22

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

An issue in windows service ?

Mohammad Dayyan2-Sep-09 21:59

Mohammad Dayyan

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 ?

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

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.