news portal using xml

  • surekhaweb
  • Newbie
  • Newbie
  • surekhaweb
  • Posts: 6

Post 3+ Months Ago

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
  • Scuffle
  • Genius
  • User avatar
  • Posts: 6230
  • Loc: South-Africa

Post 3+ Months Ago

what I usualy do is the following: I add the XML into a dataset with the following:
Code: [ 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: [ 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: [ 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

Post Information

  • Total Posts in this topic: 2 posts
  • Users browsing this forum: No registered users and 37 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.