Re: how can i create xml data abd how can i update delete and insert.. - XML / XSL Discussion Boards

??

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

Read the documentation, write your code and, then, ask for help on a specific problem. I provided some links below to get you started:

http://msdn2.microsoft.com/en-us/library/0h7a3akd(VS.80).aspx[^]

http://msdn2.microsoft.com/en-us/library/etdhs5bz(VS.80).aspx[^]

http://msdn2.microsoft.com/en-us/library/1w7dc16f(VS.80).aspx[^]

"We make a living by what we get, we make a life by what we give." --Winston Churchill

Check This Out...It will work out... Smile | :)

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

Hi,

I tried with NLM XML and XSL (http://dtd.nlm.nih.gov/publishing/), but I could not view MathML. Please help..

Regards,
Hariharan C.

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

Here you go, Pete knows best[^]

Please see Example 1 (Figure 3) in below link.

http://cnx.org/content/m14396/latest/#element-967[^]

Regards,
Bala.

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

天气常如二三月，花技不断四时春。

I guess its working properly. U r giving position()<5 so its getting firts four rows-

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

and then sorting it based on myId.

If u want to get desired result u have mentioned u need to change ur condition

<xsl:for-each select="./Table/RecordSet[@Myid < 5]">

First thanks for your reply.
But I don't want to get the RecordSet which Myid <5, I want do this:
First sorted all RecordSet based the Myid, and get 5 Records as first page.
You know, if show 5 RecordSet/page, I need 2 pages to show all RecordSet.

=========================================
Make friends with you all.
My Blog, welcome

天气常如二三月，花技不断四时春。

What you are doing in ur code is first you are selecting first 5 rows and then you are applying sorting...

<?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">
<xsl:sort select="./@Myid" data-type="number" order="ascending"/>
<xsl:if test="position() < 5">
<tr>
<td>
<xsl:value-of select="."/>
</td>
</tr>
</xsdl:if>
</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>

I guess it should work, But how u are u applying paging I am apprehensive whether u can apply it in this way, Lemme me know if have any issue...

Yes, you are right. Thanks very much for your help.

=========================================
Make friends with you all.
My Blog, welcome

天气常如二三月，花技不断四时春。

Hello every one !
How can I display data into repeater control..
for eg. I have to display data in the following format from XML
rediffHomePage(First Repeater)
--HotJobs(Second Repeater)
--Label
rediffHomePage1(Second Repeater)
--Images (Second Repeater)
--Air Tickets

I have to display <Label> of <ScreenToSupport> and below this label I have to display <Label> of

FieldsToSupport/FieldToSupport for each <ScreenToSupport>.
How can I bind repeater..

Following is structure my XML file
--------------------------------------------------------------------------
<ScreensToSupport>
<ScreenToSupport>
<ScreenUniqueId>199d1dfd-63ca-4271-b234-77da0f579e0e</ScreenUniqueId>
<SupportItems>
<ScreenSupportItem>
...
<RefId>1</RefId>
</ScreenSupportItem>
</SupportItems>
<FieldsToSupport>
<FieldToSupport>
...
<Label>HotJobs</Label>
...
<FieldSupportItems />
</FieldToSupport>
<FieldToSupport>
...
<Label>Game</Label>
...
<FieldSupportItems />
</FieldToSupport>
</FieldsToSupport>
<Label>rediffHomePage</Label>

</ScreenToSupport>
<ScreenToSupport>
<ScreenUniqueId>e62abc49-efc7-4a5d-908f-33f2f4df070b</ScreenUniqueId>
<SupportItems>
<ScreenSupportItem>
...
<RefId>2</RefId>
</ScreenSupportItem>
</SupportItems>
<FieldsToSupport>
<FieldToSupport>
..
<Label>Images</Label>
..
<FieldSupportItems />
</FieldToSupport>
<FieldToSupport>
...
<Label>Air Tickets</Label>
...
<FieldSupportItems />
</FieldToSupport>
</FieldsToSupport>
<Label>rediffHomePage1</Label>
</ScreenToSupport>
</ScreensToSupport>
--------------------------------------------------------------------------
and the code written in c# to extract data from XML given below
--------------------------------------------------------------------------
XmlDocument objXmlDocument = new XmlDocument();
objXmlDocument.Load(strAlbumPath + "\\" + strAlbumName + ".linkinfo.xml");
int count = 0;
int intChildCount = 0;
XmlNodeList objList =

objXmlDocument.SelectNodes("/LinkInformation/ScreensToSupport/ScreenToSupport");
string lsString = "";
String strParentLabel = "";
string strChildLabel = "";
foreach (XmlNode objChild in objList)
{
foreach (XmlElement elementParentLabel in objChild)
{
if (elementParentLabel.Name == "Label")
{
strParentLabel = strParentLabel + elementParentLabel.InnerText + ";";
Response.Write("Parent Label :" + strParentLabel + " ");
break;
//This Line gives all Label of <ScreenToSupport> here I have to bind repeater control to display

Label rediffHomePage and rediffHomePage1
}
}
foreach (XmlNode objChild2 in objChild.ChildNodes)
{
if (objChild2.Name == "FieldsToSupport")
{
intChildCount = objChild2.ChildNodes.Count;
XmlNodeList childF2S = objChild2.ChildNodes;
foreach (XmlNode nodeF2SLable in childF2S)
{
foreach (XmlElement elementLabel in nodeF2SLable)
{
if (elementLabel.Name == "Label")
{
strChildLabel = strChildLabel + elementLabel.InnerText + ";";
count++;
if (count == intChildCount)
{
Response.Write("ChildLabel : " + strChildLabel + " ");
break;
//This Line gives all Label of FieldsToSupport/FieldToSupport for respective <ScreenToSupport> Label

here I have to bind repeater control to display Label HotJobs, Game (FieldsToSupport/FieldToSupport)

for rediffHomePage (<ScreenToSupport>) and Images, Air Tickets for rediffHomePage1.
}
}
}
}
}
}
count = 0;
strChildLabel = "";
}
--------------------------------------------------------------------------
How can I bind both repeater to dispaly data in the required format.
--------------------------------------------------------------------------

Hello every one ! How can I display attribute of parent node and corresponding child nodes.Suppose I have to display 'Label' attributes of all <ScreenToSupport>. There can be multiple <ScreenToSupport> inside parent node
<ScreensToSupport>.In this case I have to display Label 'rediffHomePage' and 'rediffHomePage1' of both <ScreenToSupport> node. But I have to display corresponding Label of 'FieldsToSupport/FieldToSupport' of
<ScreenToSupport>..In this case I have to display Label 'HotJobs'and 'Game' for 'rediffHomePage' similarly display Label 'Images' and 'Air Tickets' for 'rediffHomePage1'.
For example on click an Item like rediffHomePage from a repeater/dataList It should display Label like 'HotJobs' and 'Game'of FieldToSupport. How can I display Label of corresponding FieldsToSupport/FieldToSupport on click on
corresponding Label of <ScreenToSupport>..How can I do this ?
following is the structure of XML file, which is not follows an hierarchical structure of XML..
--------------------------------------------------------------------
<ScreensToSupport>
<ScreenToSupport>
<ScreenUniqueId>199d1dfd-63ca-4271-b234-77da0f579e0e</ScreenUniqueId>
<SupportItems>
<ScreenSupportItem>
...
<RefId>1</RefId>
</ScreenSupportItem>
</SupportItems>
<FieldsToSupport>
<FieldToSupport>
...
<Label>HotJobs</Label>
...
<FieldSupportItems />
</FieldToSupport>
<FieldToSupport>
...
<Label>Game</Label>
...
<FieldSupportItems />
</FieldToSupport>
</FieldsToSupport>
<Label>rediffHomePage</Label>

</ScreenToSupport>
<ScreenToSupport>
<ScreenUniqueId>e62abc49-efc7-4a5d-908f-33f2f4df070b</ScreenUniqueId>
<SupportItems>
<ScreenSupportItem>
...
<RefId>2</RefId>
</ScreenSupportItem>
</SupportItems>
<FieldsToSupport>
<FieldToSupport>
..
<Label>Images</Label>
..
<FieldSupportItems />
</FieldToSupport>
<FieldToSupport>
...
<Label>Air Tickets</Label>
...
<FieldSupportItems />
</FieldToSupport>
</FieldsToSupport>
<Label>rediffHomePage1</Label>
</ScreenToSupport>
</ScreensToSupport>
--------------------------------------------------------------------
I am not very familiar with how displaying XML contents.. I tried this way..
But stuck on that point please help me ..
I will very thankful for that..