Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old May 31st, 2007, 01:08 PM
Authorized User
 
Join Date: Feb 2007
Location: Binghamton, NY, USA.
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.

Reply With Quote
  #2 (permalink)  
Old May 31st, 2007, 04:48 PM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
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
Reply With Quote
  #3 (permalink)  
Old June 4th, 2007, 07:21 AM
Authorized User
 
Join Date: Feb 2007
Location: Binghamton, NY, USA.
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?

Reply With Quote
  #4 (permalink)  
Old June 4th, 2007, 08:16 AM
Authorized User
 
Join Date: Feb 2007
Location: Binghamton, NY, USA.
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

Reply With Quote
  #5 (permalink)  
Old June 4th, 2007, 08:57 AM
Authorized User
 
Join Date: Feb 2007
Location: Binghamton, NY, USA.
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.

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 08:49 AM.


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