Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
|
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 31st, 2007, 01:08 PM
Authorized User
 
Join Date: Feb 2007
Posts: 88
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to toddw607 Send a message via Yahoo to toddw607
Default Xml from SQL Server into ASP.NET

    I have a table in SQL Server which I uploaded an entire xml file into. The table has 2 columns, Col001, Col002. Col001 holds all the xml text. Each row has one line of the xml file uploaded . Col002 holds the titles of sections contained in the xml, if no title is in the line of xml then a <NULL> is placed in Col002.
    I am looking for a way to extract all the xml lines in between titles to display in an ASP.NET webform. For instance, if a title is located in Col002 then it should gather all info up to, but not including, the next title and output that information to the browser through ASP.NET. Does anyone know of a good tutorial that relates to this subject. Any help will be appreciated. Thank you all.

 
Old May 31st, 2007, 04:48 PM
planoie's Avatar
Friend of Wrox
 
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

It sounds like you need to look into the xpath querying capabilities of SQL 2005.

-Peter
 
Old June 4th, 2007, 07:21 AM
Authorized User
 
Join Date: Feb 2007
Posts: 88
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to toddw607 Send a message via Yahoo to toddw607
Default

I'm working with 2000. I've noticed that 2005 has much more of these capabilities. Is there any way I could do this in 2000?

 
Old June 4th, 2007, 08:16 AM
Authorized User
 
Join Date: Feb 2007
Posts: 88
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to toddw607 Send a message via Yahoo to toddw607
Default

    ok, I have another relatively simple question which should solve all my problems: The xml document that is being stored in the SQL Server DB works fine when opened as is from it's file location. However, when I attempt to open it from SQL Server it displays but not correctly formatted. To my understanding this is due to the xsl it is referencing.
    When I open it from it's original file location then it opens in IE which is compatible with the xsl stylesheet. When I attempt to open it from ASP.NET, which opens in Firefox then the formatting is not correct. As I understand it, you must include a reference to a .css from the xml file, correct? Is there any way I could solve this problem by having it always open in IE instead of Firefox? I set my internet properties back to their default and tried to set the dropdown box in ASP.NET to different browsers to attempt to find something that works but the same thing happens. Is there an easier way to fix this? Thanks

 
Old June 4th, 2007, 08:57 AM
Authorized User
 
Join Date: Feb 2007
Posts: 88
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to toddw607 Send a message via Yahoo to toddw607
Default

I figured it out. All I had to do was open File, go down to "browse with.." and select "internet Explorer" and set it to default. This may solve stylesheet problems if you are using .xsl, just in case anyone else has this problem. Thanks.






Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP.NET 1.1,VB.NET,crystal reports, SQl server gvi Crystal Reports 1 September 11th, 2008 02:55 AM
Server to Server XML Problem (ASP.NET to ASP) Enwood XML 7 April 26th, 2006 03:22 AM
xml/sql and asp.net collie General .NET 0 October 31st, 2004 03:12 AM
xml/sql and asp.net collie XML 0 October 31st, 2004 03:10 AM
inser xml data to sql server from asp ak Classic ASP Databases 7 February 25th, 2004 01:05 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.