|
As you probably already know, an XmlNodeList is really a collection XmlNodes. You have mentioned you can read an XML document directly into a DataSet. So, I can give you a some suggestions.
1. You can create an XmlDocument populating it with XmlNodes cloned from the XmlNodeList.
2. You can create an XmlDocument using XSLT with the same criteria you used to create the XmlNodeList.
3. You can create a DataTable (or DataTables) that corresponds to your XmlNodeList and extract data from your XmlNodes into the appropriate rows and columns.
There are certainly other ways of doing this. So, search the web for ideas or just be creative.
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
I tried to apply data islands to ordered list. But it is not working. I checked the data islands in table. It is working correctly. Please let me know why it is not working on ordered list?
Thanks and Regards,
Hogan
|
|
|
|
|
hogan.smith wrote: Please let me know why it is not working on ordered list?
That might be possible Hogan, but at least for me I require more specific information.
What does "apply data island to ordered list" mean?
What does "it is not working" mean?
|
|
|
|
|
Hi mike,
Thanks for reply. I tried to load data into an ordered list from an xml file.
Content of test.xml file.
<?xml version="1.0" encoding="utf-8"?>
<menu>
<node>
<name>Link 1</name>
<link>link1.htm</link>
</node>
<node>
<name>Link 2</name>
<link>link2.htm</link>
</node>
<node>
<name>Link 3</name>
<link>link3.htm</link>
</node>
<node>
<name>Link 4</name>
<link>link4.htm</link>
</node>
<node>
<name>Link 5</name>
<link>link5.htm</link>
</node>
</menu>
Html code
<html>
<head>
</head>
<body>
<xml id="menu" src="test.xml"></xml>
<ol datasrc="#menu">
<li><span datafld="name"></span></li>
</ol>
</body>
</html>
Thanks and regards,
Hogan
|
|
|
|
|
Hi,
could you please recommend me a free XSLT files generator?
Thank you in advance
|
|
|
|
|
Yoyosch wrote: could you please recommend me a free XSLT files generator?
try using Yoyosch
|
|
|
|
|
|
led mike believes you are capable of creating XSLT code after studying XSLT syntax. As far as the existense of free XSLT generator software, I haven't had any reason to look for that. However, XSLT is just XML, and can be created as you would an XML document. IMHO, XSLT generator software would be for a special purpose.
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
Where can i get open source code for Media RSS 2.0 parser?
I want the output to be generated in XML format by passing url of type Media RSS 2.0.
For this where can i get open source code?
Rajshri
|
|
|
|
|
hi everyone ..i m working on one zoo project ..so i need some information .. i want 2 create xml file as a database and i want 2 insert data ,delete data,and update .. in xml database plzz can any one tell how it ll do?? in using C# code..
thanks 2 all..
|
|
|
|
|
Insert and delete are pretty simple methods. U just need to access proper node with the help of Xpath query.
Post ur specific question if u have any...
|
|
|
|
|
can u provide insert and delete code..plz...
thanks 2 all..
|
|
|
|
|
|
Check This Out...It will work out... 
Protected Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GridView1.RowUpdating
Dim i As Integer = GridView1.Rows(e.RowIndex).DataItemIndex
Dim strId As String = CType(GridView1.Rows(e.RowIndex).Cells(2).Controls(0), TextBox).Text
Dim strName As String = CType(GridView1.Rows(e.RowIndex).Cells(3).Controls(0), TextBox).Text
GridView1.EditIndex = -1
BindGrid()
' Update the XML file using the new values
Dim oDs As Data.DataSet = GridView1.DataSource
oDs.Tables(0).Rows(i).Item(0) = strId
oDs.Tables(0).Rows(i).Item(1) = strName
oDs.WriteXml(Request.PhysicalApplicationPath + "books.xml")
BindGrid()
End Sub
Protected Sub GridView1_RowDeleting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewDeleteEventArgs) Handles GridView1.RowDeleting
BindGrid()
Dim oDs As Data.DataSet = GridView1.DataSource
oDs.Tables(0).Rows(GridView1.Rows(e.RowIndex).DataItemIndex).Delete()
oDs.WriteXml(Request.PhysicalApplicationPath + "books.xml")
BindGrid()
End Sub
Protected Sub GridView1_RowCancelingEdit(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCancelEditEventArgs) Handles GridView1.RowCancelingEdit
GridView1.EditIndex = -1
BindGrid()
End Sub
Protected Sub GridView1_RowEditing(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewEditEventArgs) Handles GridView1.RowEditing
GridView1.EditIndex = e.NewEditIndex
BindGrid()
End Sub
Protected Sub GridView1_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles GridView1.PageIndexChanging
GridView1.PageIndex = e.NewPageIndex
BindGrid()
End Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Page.IsPostBack = False Then
BindGrid()
End If
End Sub
Sub BindGrid()
Dim oDs As New Data.DataSet
oDs.ReadXml(Request.PhysicalApplicationPath + "books.xml")
GridView1.DataSource = oDs
GridView1.DataBind()
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
If txtId.Text = "" Or txtName.Text = "" Then
MsgBox("A Value Is Required...!")
Else
BindGrid()
Dim oDs As Data.DataSet = GridView1.DataSource
Dim oDr As Data.DataRow = oDs.Tables(0).NewRow
oDr("Name") = txtId.Text
oDr("Author") = txtName.Text
oDs.Tables(0).Rows.Add(oDr)
oDs.WriteXml(Request.PhysicalApplicationPath + "books.xml")
BindGrid()
txtId.Text = ""
txtName.Text = ""
txtId.Focus()
End If
End Sub
Regards
Abhishek,Nanda
|
|
|
|
|
|
Please try with mozilla firefox.
Regards,
Bala.
|
|
|
|
|
hi guys,
I want to do verify xml file on scema file. For this purpose i've to design xsl file which take two documents as input 1 is xml and 2nd is xsd.
can anyone help me in this regard?
|
|
|
|
|
Is there any built-in classes of ASP.NET 2.0 similar to the ConfigurationManager to be able to access a custom config file (similar to web.config) without having write a process to read in the xml and handle the nodes?
|
|
|
|
|
We have a number of dev and test SQL Servers (2005) and I would like a more structured and manageable way to setup access/security on these test/dev servers. Currently, it's a time-consuming process because I generally have to manually setup whatever Logins/Security the developers want in test/dev on an ad-hoc basis. Sometimes it's a combination of copying Logins from production and creating test specific logins/security. When the test db's get refreshed/restored, I often end up having to start again - although I try to get the developers to script out the test environment specific security stuff.
I was wondering if I could write/buy a utility, like an ASP.NET app that helped developers to input the required Logins, access and so on into a form and have the app save this info as an XML file. The XML file could then in turn be used as in input into another ASP.NET app using SMO to apply the security model defined in the XML file. It would also be necessary to be able to point the app at an existing server, production for example, and generate a template - ie. populate the XML file with that server's Logins, db access, schema info (db owner), db roles, role membership and permissions.
I can code this up if necessary and SMO should gve me what I want. However, given that someone else might have already done this, maybe I could save myself a lot of time and effort. Thoughts or suggestions?
|
|
|
|
|
i want example code for creating table using xml
p.ayyapa swamy
|
|
|
|
|
|
|
Colleagues,
I’m brand new to XML. I’m using VB6 and DOM to write an XML log file. (I have to use VB6, because I’m retrofitting a legacy application.) Each log entry has 3 layers of nesting and about 20 nodes. I want to avoid pain of creating every new entry node-by-node. I’m looking for a way to create a new blank log entry efficiently (in terms of required amount of code). I have some ideas, but how do the big kids do it?
-Nick
P.S. I know Java and C++, so if you have examples in other languages, please post them; I can translate them to VB6.
-- modified at 15:52 Wednesday 21st November, 2007
|
|
|
|
|
Create properties for each node and then serialize it into xml format..
|
|
|
|
|
One page show 4 records. Then the first page should show as follow:
1 w
2 a
3 l
5 z
But in fact, the result like this:
1 w
2 a
3 l
9 n
<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="SortTest.xsl"?>
<Table>
<RecordSet Myid="2" title="a">2 a</RecordSet>
<RecordSet Myid="1" title="w">1 w</RecordSet>
<RecordSet Myid="3" title="l">3 l</RecordSet>
<RecordSet Myid="9" title="n">9 n</RecordSet>
<RecordSet Myid="7" title="m">7 m</RecordSet>
<RecordSet Myid="6" title="k">6 k</RecordSet>
<RecordSet Myid="4" title="z">5 z</RecordSet>
</Table>
<?xml version="1.0" encoding="iso-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:user="http://dotnet.aspx.cc/" exclude-result-prefixes="msxsl user">
<xsl:output method="html" omit-xml-declaration="yes"/>
<xsl:template match="/">
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<xsl:for-each select="./Table/RecordSet[position() < 5]">
<xsl:sort select="./@Myid" data-type="number" order="ascending"/>
<tr>
<td>
<xsl:value-of select="."/>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>
How to resolve it?
=========================================
Make friends with you all.
My Blog, welcome
天气常如二三月，花技不断四时春。
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
