|
Hi,
Without going into the complexity of Schema you could do the following:
INSERT INTO TableName values('lt root /gt')
lt = <
gt = >
Note: the value should be a valid XML documents or XML fragment (e.g. an XML document that doesn't have a root)
for more information about XML, you can try this website http://jameleon.sourceforge.net/xmlBasics.html[^]
about getting XML from datagrid, sorry I didn't understand your question, please explain it more.
Hope this helps 
|
|
|
|
|
i want to insert data from textbox into xml datatype column in database.
i tried the coding for this... But it accepts the data with tags( Root> ).If we enter without the tag, it is showing error.
|
|
|
|
|
hello,
I am new to both the xml and C#.net technologies. I am generating a xml file in c#.net.I am trying to generate a xml file whose first/root node should look like this:
<tns:schedule xmlns:tns="http://www.sample.com/Schedule" xmlns:dt="http://www.sample.com/DataTypes" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.sample.com/Schedule Schedule.xsd" scheduleType="Playback" version="1.0" creationTime="2006-01-29T00:00:00" originator="sample">
<scope startTime="2006-01-29T04:00:00" stopTime="2006-01-29T06:00:00" />
I am using the xmlWriter class to generate the xml. The data for xml is taken from the structure which is filled by the program itself.
<u>My code is as follows:</u>
private void generateXml()
{
TreeNode tempNode,selectedNode;
frmFindByProgram.stProgram stTemp = new frmFindByProgram.stProgram();
selectedNode=new TreeNode();
tempNode = new TreeNode();
XmlTextWriter writer = new XmlTextWriter("E:\\Projects\\Project1\\July\\26\\ScheduleDemo\\NewXML.xml", new System.Text.UTF8Encoding());
//Write the header information
writer.WriteStartDocument();
//Write the root node
writer.WriteStartElement("tns", "schedule","http://www.sample.com/Schedule");
//use the record structure
int i = 0, count;
count = xmlSlotNodes.Count;
// sort the slots according to there callSign
xmlSlotNodes.Sort(0,count,new Sorting ());
string[] prgmTime = new string[2];
stTemp = (frmFindByProgram.stProgram)xmlSlotNodes[i];
selectedNode=getClickedNode();
writer.Formatting = Formatting.Indented;
writer.WriteStartElement("CruiseLine");
// writer.WriteAttributeString("Id", selectedNode.Text );
writer.WriteAttributeString ("Name",selectedNode.Parent.Text);
writer.WriteStartElement("Ship");
writer.WriteAttributeString("Name", selectedNode.Text );
writer.WriteStartElement("Channel");
writer.WriteStartElement("CallSign");
writer.WriteAttributeString("Value", stTemp.CallSign);
prgmTime = stTemp.Duration.Split('-');
do
{
stTemp = (frmFindByProgram.stProgram)xmlSlotNodes[i];
prgmTime = stTemp.Duration.Split('-');
writer.WriteStartElement("Program");
writer.WriteAttributeString("Id", stTemp.ProgramID);
writer.WriteAttributeString("Title", stTemp.Title);
writer.WriteAttributeString("AssetName", stTemp.AssetName);
writer.WriteAttributeString("StartTime", prgmTime[0].ToString());
writer.WriteAttributeString("EndTime", prgmTime[1].ToString());
writer.WriteEndElement();
//Write some white space between nodes
writer.WriteWhitespace("\n");
tempNode =selectedNode;
selectedNode = getClickedNode();
-----
-----
---
writer.close();
}
<u>my output file, NewXML.xml file contains the following </u>:
<?xml version="1.0" encoding="utf-8" ?>
- <tns:schedule xmlns:tns="http://www.sample.com/Schedule" >
- <CruiseLine Name="Carnival">
- <Ship Name="Celebration">
- <Channel>
- <CallSign Value="ABC">
<Program Id="104" Title="assde4" AssetName="asset4" StartTime="01:30" EndTime="02:00" />
</CallSign>
......
</tns:schedule>
<u>In order to modify the root/first node's information as given in the my sample file....</u>
i added new line to the code that is at:
//Write the root node
writer.WriteStartElement("tns", "schedule","http://www.sample.com/Schedule");
writer.WriteAttributeString("dt",null,"http://www.sample.com/DataTypes");
- <tns:schedule d1p1:dt="" xmlns:d1p1="http://www.sample.com/DataTypes" xmlns:tns="http://www.sample.com/Schedule">
i don't know from where this d1p1 got inserted and also why this attribute instead of getting appended is becoming the first attribute of the root element.
Please can anyone help me out.I am trying it from last 4 days.. please try to help me soon.
Thank you.
Anee
<u></u>
Anee
|
|
|
|
|
I am writing the following code for creating the XML file.
HRESULT hr;
IXMLDOMDocumentPtr pXMLDoc = NULL;
CoInitialize(NULL);
hr=pXMLDoc.CreateInstance("msxml2.domdocument");
IXMLDOMNodePtr pRootNode= NULL;
IXMLDOMNodePtr pRecNode= NULL;
IXMLDOMNodePtr pRecNode1= NULL;
IXMLDOMElementPtr pElement=NULL;
_variant_t varNodeType((short)MSXML2::NODE_ELEMENT);
hr= pXMLDoc->createNode(varNodeType,
_T("RTCS"), _T("Remote Target Control System"),&pRootNode);
hr=pXMLDoc->createElement(_T("Connection"),&pElement);
IXMLDOMAttributePtr pRecIdAttr = NULL;
IXMLDOMNamedNodeMapPtr pattributeMap;
hr=pXMLDoc->createAttribute(_T("connect"),&pRecIdAttr);
hr=pRecIdAttr->put_nodeTypedValue(_variant_t(_T("connect_val")));
hr=pElement->get_attributes(&pattributeMap);
hr=pattributeMap->setNamedItem(pRecIdAttr,&pRecNode);
hr=pXMLDoc->appendChild(pRootNode,&pRecNode);
but i am not able to see the child node created in the xml file.Only root node is created:
The xml file i want to create is:
?xml version="1.0"?>
<rtcs name="Remote Target Control System">
<Connection connect= "connectval" ipaddress = "ip_addresss" Port = "port_number"/>
<Logging Directory="path" Level="level" ComPort="port_number" Maxsize="max_size"/>
<Video BitRate="bitrate" InputType="input_type" Preview="preview" FrameDrop="frame_drop" Dumping ="dump"/>
<IR directory_path="dir_path"/>
</rtcs
|
|
|
|
|
I have the following webservice which gets a xml payload I would like to take that payload validate it against a schema then send it to websphere MQ. I have a good portion working but when I write the payload to MQ its empty almost like I am not able to get the information being sent in. Here is the code I am using and any help would be great as I have hit a road block and still pretty new to all this.
/// <remarks>
[System.Web.Services.Protocols.SoapHeaderAttribute("payloadManifest", Direction=System.Web.Services.Protocols.SoapHeaderDirection.InOut)]
[System.Web.Services.WebMethodAttribute()]
[System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://arknet.arkona.com/wsTransport/service/ProcessMessage", RequestNamespace="http://www.starstandards.org/webservices/2005/10/transport", ResponseNamespace="http://www.starstandards.org/webservices/2005/10/transport", Use=System.Web.Services.Description.SoapBindingUse.Literal, ParameterStyle=System.Web.Services.Protocols.SoapParameterStyle.Wrapped, Binding="starTransport")]
public virtual void ProcessMessage([System.Xml.Serialization.XmlElementAttribute(ElementName="payload")] ref Payload payload)
{
//Here is the Code that reads the XML Payload Stream and Validates it to the correct Schema before sending the message forward.
//System.Xml.XmlElement xe = payload.content[0].Any;
//XmlDocument xmlDoc = xe.OwnerDocument;
//xmlDoc.Schemas.Add(null, "http://localhost/wsTransport/ProcessCRM.xsd");
//xmlDoc.Validate(delegate(object sender, ValidationEventArgs vargs)
//{
// Console.WriteLine("{0}: {1}", vargs.Severity, vargs.Message);
//}, xe);
System.Xml.XmlElement xe = payload.content[0].Any;
XmlDocument xmlDoc = xe.OwnerDocument;
string qManager = "ARKDEV.QUEUE.MANAGER";
string channel = "SYSTEM.ADMIN.SVRCONN";
string hostName = "arkdev.arkona.com";
string qName = "ROB.IN.QUEUE";
MQEnvironment.Hostname = (hostName);
MQEnvironment.Channel = (channel);
MQEnvironment.Port = 1414;
try
{
MQQueueManager qMgr = new MQQueueManager(qManager);
MQQueue queue = qMgr.AccessQueue(qName, MQC.MQOO_OUTPUT);
MQMessage msgData = new MQMessage();
msgData.WriteString(xmlDoc.OuterXml);
MQPutMessageOptions pmo = new MQPutMessageOptions();
queue.Put(msgData, pmo);
queue.Close();
qMgr.Close();
}
catch (MQException e)
{
Console.WriteLine("Error: {0}", e.ToString());
}
}
Thanks for taking the time to look at this and any help would be great
|
|
|
|
|
Hi Guys,
I am not that good with xPath, so please don't laugh at my question 
Trying to query an XmlNode to find a given element's parent's attribute...
For example:
<root>
<parent name="Mom">
<kid>Mike</kid>
<kid>Rose</kid>
</parent>
</root>
Basically, I'm trying to find the name of "Mike's" parent (Mom). If you can help me out, thank you so much... thousand kisses to you!
Grapes
|
|
|
|
|
You use parent::node():
using namespace System;
using namespace System::Xml;
int main(array<System::String ^> ^args)
{
String^ xmlString =
"<root>"
" <parent name=\"Mom\">"
" <kid>Mike</kid>"
" <kid>Rose</kid>"
" </parent>"
"</root>";
XmlDocument^ xmlDoc = gcnew XmlDocument;
xmlDoc->LoadXml(xmlString);
XmlNodeList^ children = xmlDoc->SelectNodes("/root/parent/kid");
for each (XmlNode^ child in children)
{
XmlNode^ parent = child->SelectSingleNode("parent::node()");
if (parent != nullptr)
{
Console::WriteLine("{0}'s parent is good old {1}.", child->InnerText,
parent->Attributes->GetNamedItem("name")->Value);
}
}
return 0;
}
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
Thanks alot George!!
Grapes
|
|
|
|
|
Hello,
I got the following in my XML Settings file:
<configuration>
<appSettings>
<add key="CAPTURE_DEVICE" value="@device:pnp:\\? pci#ven_109e&dev_036e&subsys_13eb0070&rev_11#4&1b02cb0b&0&10f0#{65e8773d-8f56-11d0-a3b9-00a0c9223196}\global" />
</appSettings>
</configuration>
I want to read the value of the capture device from the xml file into a string variable. But due to the "&" the value = "...." doesnt seem to be a valid string. Is there a way to handle this?
thx in advance,
best regards
dominik
|
|
|
|
|
& has to be escaped as &
|
|
|
|
|
It's a good thing he came here to find that out. It's not like there is a freely available documented standard on the internet that contains that information... wait 
|
|
|
|
|
Thanks for your answer!
But is there a way to get a valid string without manually editing the original string and replacing every & with &amp;?
regards
Dominik
-- modified at 4:29 Friday 27th July, 2007
|
|
|
|
|
No because having an unescaped & is what makes it invalid XML.
|
|
|
|
|
Hi,
I am a newer to XML and Visual C++.
Could You please say, How is the Data from XML file is read/ or written to through Visual C++ program??
Gyan
|
|
|
|
|
There are two Microsoft solutions: MSXML and XmlLite. You can find documentation and samples on http://msdn2.microsoft.com/en-us/default.aspx[^] or just use a search engine such as Google.
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
Can Some please help me.
How can we update a value which has the same parameter name in the same section using vc++
<rootelement>
<param1>Param Value
<param1>Param Value
<rootelement>
Now i want to update both the param values but both the parameters has the same parameter name. So how can we update these values??
Thanks
|
|
|
|
|
You can use document order. To locate the first "Param1" element, the XPath is: /RootElement/Param1[1] and the second is: /RootElement/Param1[2].
George
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
Hi,
well I\m a completely newbie in XML and I've been given a task to put a filtering capability on an XML document in .NET application. So I'm looking at XPath for that. Now I wanna populate a combo box with all the names of the XML elements i.e tags so that I can populate the treeView on that basis.
Now to populate that combobox I was thinking if I can make an XPath Query that can give me the unique namesof the tags. Is this possible that way or do I have to get all teh elements first and then filter out the unique ones
thanks in advance
Rocky
|
|
|
|
|
Say I have this XML Document:
<?xml version="1.0" encoding="UTF-16"?>
<?xml-stylesheet type="text/xsl" href="MyXsl.xsl"?>
<page>
<para>
Test paragraph.
</para>
<para>
Test <link href="codeproject.com">link</link>.
</para>
</page>
In XSLT, how would you change <link href into <a href?
I have this so far...
<xsl:template match="/">
...
<xsl:for-each select="//para">
<xsl:call-template name="paragraph"/>
</xsl:for-each>
...
</xsl:template>
<xsl:template match="//para" name="paragraph">
<p>
<xsl:value-of select="."/>
</p>
</xsl:template>
Thanks! I've tried Google, but couldn't find anything useful.
|
|
|
|
|
I hope the following will give you some ideas:
<?xml version="1.0"?>
<page>
<para>
Test paragraph
</para>
<para>
A good place to find source code is <link href="http://www.codeproject.com">CodeProject</link>
</para>
</page>
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/page">
<xsl:apply-templates select="para"/>
</xsl:template>
<xsl:template match="para">
<p><xsl:apply-templates select="child::text() | link"/></p>
</xsl:template>
<xsl:template match="text()">
<xsl:value-of select="."/>
</xsl:template>
<xsl:template match="link">
<a href="{@href}"><xsl:value-of select="."/></a>
</xsl:template>
</xsl:stylesheet>
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
|
Hi,
Is it possible to read a xml schema file (.xsd) and generate the xml file based on that schema file? if so, could you please give me the sample code in VB.NET that can do this?
Thanks,
sridhar.
|
|
|
|
|
I have extracted some Outlook contacts to Access table and I now I want to create a xml document that has the below structure.
I'm thinking of loading the data to a recordset and then to stream it to an XML document. The problem is how could I define the structure I need for my xml document. Could the xml Microsoft XMLDOM object have as parameter a xml style sheet file....or what?
Thank you
Leonidas Kallis
KundenListe>
Kunde>
KundenDaten>
Anschrift>
AdrAnrede s="Κύριος"/>
AdrName s="Παππας"/>
AdrVorname1 s="Ιωάννης"/>
AdrStadt s="Δρυός"/>
AdrPostfach s="234242"/>
AdrTel1 s="210 4428686"/>
AdrLand s="GR"/>
AdrPlz s="84400"/>
/Kunde>
/KundenDaten>
Kunde>
KundenDaten>
Anschrift>
AdrAnrede s="Κυρία"/>
AdrName s="Τρίμμη"/>
AdrVorname1 s="Αγαθή"/>
AdrStrasse s="Γαμβέττα 43"/>
AdrStadt s="Θεσσαλονίκη"/>
AdrTel1 s="2310 677933"/>
AdrTel2 s="697 χχχ χχχχχ"/>
AdrTelefax s="2310 988290"/>
AdrLand s="GR"/>
/Kunde>
/KundenDaten>
/KundenListe>
-- modified at 4:15 Tuesday 24th July, 2007
|
|
|
|
|
Hi guys - i have a schema which i would like to use to generate an empty node hierachy. Currently the way the system operates is to have an initial hierachy, and the first node in each collection is the template node, which is then cloned and the result used as the new instance. This approach is causing maintainability problems however.
I have the schema, so i know what should be in the node. I just want to create a node from it.
Does anyone know how this can be done?
cheers
Tris
-------------------------------
Carrier Bags - 21st Century Tumbleweed.
|
|
|
|
|
Hi,
How can i create XML file using MSXML DOM node.
Regards
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
