news portal using xml

May 6th, 2008, 1:06 am

how can i create news website admin part for news website like rediff . com ?

once i will add news it will going as his news category and also pages linked automatic and pages created automatic.

how can i make this using XML ?

bcoz my server is windows base and i have not much database space.

----------------------------------------------------------------------

exactly i want this.

I want use xml as data base in my website.
But how to insert, update,Delete in XML data base using ASP.NET.

and also how to run select query from XML data base on condition.

like my SQL query is "Select top 5 * from xyztable where xyzfield=1"

so how to run this query on xml databse...

[righteous_trespasser]

May 7th, 2008, 2:33 am

what I usualy do is the following: I add the XML into a dataset with the following:

Code: [ Download ] [ Select ]

dim ds as New Dataset
ds.ReadXML("path+filename")

1. dim ds as New Dataset
2. ds.ReadXML("path+filename")

then all the data from your XML document is in a dataset.
Then you can re-write that XML document with the following:

Code: [ Download ] [ Select ]

ds.WriteXML("path+filename")

Usually my XML/dataset structures aren't very complex so I have never really tried to execute queries on it, but I don't think that it's possible anyway. but to go through all the records you can just use a FOR loop ...

Code: [ Download ] [ Select ]

For i as integer = 0 to ds.Tables(0).rows.count - 1
'do something here
Next

1. For i as integer = 0 to ds.Tables(0).rows.count - 1
2. 'do something here
3. Next