Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsXMLXMLhelp needed to modify XML modulw to include SQL datahelp needed to modify XML modulw to include SQL data
Previous
 
Next
New Post
1/29/2011 2:28 AM
 
I need help modifying the xml/xsl module... I am new to DNN with community ed 5.6, but proficient in vb.net.
What I'm trying to achieve is to extend the module to include a setting that you can specify a sql stored procedure to call that will return the xml data. This stored procedure also needs to accept a parameter from the querystring to filter the data returned. My aim is to specify sql server as the data source for the xml instead of a file or url.

I have downloaded the xml source and am trying to get to grips with the inner workings of the framework. Any help/pointers will be appreciated.
Thanx
 
New Post
1/29/2011 8:20 AM
 
maybe you want to have a look at SQLGridSelectedView from tressleworks.ca

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
1/29/2011 10:11 AM
 
Another thing to do would be to output xml from the sql db and if you need to use it together with xml data from another source, merge the 2 xml files before using the DNN xml module. I am doing this quite a bit, use a simple aspx file on my server to do the combining of the 2 or more xmls into one before calling the final one in DNN xml.
 
New Post
1/30/2011 2:20 AM
 
Tom Van Wynen wrote:
Another thing to do would be to output xml from the sql db and if you need to use it together with xml data from another source, merge the 2 xml files before using the DNN xml module. I am doing this quite a bit, use a simple aspx file on my server to do the combining of the 2 or more xmls into one before calling the final one in DNN xml.

 Tom, that sounds interesting... tell me more! Where are you hosting the aspx page, inside the dnn virtual directory? And are you using the XMLDocument class to perform merge?

 
New Post
1/30/2011 3:28 AM
 
Sebastian Leupold wrote:
maybe you want to have a look at SQLGridSelectedView from tressleworks.ca

 thanks for the pointer - very nice module indeed!

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsXMLXMLhelp needed to modify XML modulw to include SQL datahelp needed to modify XML modulw to include SQL data


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out