Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 17, 2012 01:44 AM by Decker Dong - MSFT
Member
58 Points
144 Posts
Apr 15, 2012 01:36 PM|LINK
if i use xml as database how i can apply any query on it.... does the querry will be like a sql querry?
like select * from xml_asd where user_id=123
can i put security on xml database?
xquery Database
Contributor
5514 Points
810 Posts
Apr 15, 2012 02:43 PM|LINK
Refer this
http://weblogs.asp.net/scottgu/archive/2007/08/07/using-linq-to-xml-and-how-to-build-a-custom-rss-feed-reader-with-it.aspx
Star
9767 Points
1930 Posts
Apr 16, 2012 07:55 AM|LINK
@exbond,
You can try this example explain in my blog post -
http://kavstech.blogspot.com/2009/08/create-xml-after-querying-on-table.html
All-Star
118619 Points
18779 Posts
Apr 17, 2012 01:44 AM|LINK
Hello exbond：）
In fact to deal with xml file，you can：
1）Suppose your xml contents can be serialized into DataTable，you can use something like DataTable.Select method to deal with the problem。
2）If you want to filter with xml contents directly，just use XDocument（LINQ-TO-XML）。Here's the sample：
http://msdn.microsoft.com/en-us/vstudio/bb738050#filtwhere
exbond
Member
58 Points
144 Posts
query xml
Apr 15, 2012 01:36 PM|LINK
if i use xml as database how i can apply any query on it.... does the querry will be like a sql querry?
like select * from xml_asd where user_id=123
can i put security on xml database?
xquery Database
Vipindas
Contributor
5514 Points
810 Posts
Re: query xml
Apr 15, 2012 02:43 PM|LINK
Refer this
http://weblogs.asp.net/scottgu/archive/2007/08/07/using-linq-to-xml-and-how-to-build-a-custom-rss-feed-reader-with-it.aspx
xquery Database
kavita_khand...
Star
9767 Points
1930 Posts
Re: query xml
Apr 16, 2012 07:55 AM|LINK
@exbond,
You can try this example explain in my blog post -
http://kavstech.blogspot.com/2009/08/create-xml-after-querying-on-table.html
I would love to change the world, but they wont give me the source code.
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: query xml
Apr 17, 2012 01:44 AM|LINK
Hello exbond：）
In fact to deal with xml file，you can：
1）Suppose your xml contents can be serialized into DataTable，you can use something like DataTable.Select method to deal with the problem。
2）If you want to filter with xml contents directly，just use XDocument（LINQ-TO-XML）。Here's the sample：
http://msdn.microsoft.com/en-us/vstudio/bb738050#filtwhere
xquery Database