Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > XML > How to Display xml from a Database Column

Reply
Thread Tools

How to Display xml from a Database Column

 
 
teknowledgy
Guest
Posts: n/a
 
      11-04-2006
Hi All,

This is my first post to this group and I have a very specific
question.

My SQL database has has four tables. A couple of the columns in these
tables use the xml data type which receive data from custom asp.net 2.0
user controls. Now I am trying to display the data from my tables in
formviews that are bound to Object Data Sources. The problem is that
the xml data is displaying as one long unbroken string. For instance,
my contact user control lets the users enter their address, city,
state, telephone and email in different text boxes but when it displays
it comes out
2121234567654MNEveryTown3312PineStreet

and data from check boxes displays as
falsefalsetruefalsetruetrue


I can't use the XmlDatasource because my data is not in an.cml file.
but instead was collected from the webpage, serialized and deserialized
as xml and sent directly to the database.

Is there a way to separate and label the different parts of the xml
data.

 
Reply With Quote
 
 
 
Reply

Thread Tools

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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: How include a large array? Edward A. Falk C Programming 1 04-04-2013 08:07 PM
Database Database Database Database scott93727@gmail.com Computer Information 0 09-27-2012 02:43 AM
DataBase DataBase DataBase DataBase scott93727@gmail.com Computer Information 0 09-26-2012 09:40 AM
1 Gridview. Dropdown A is column from database, Dropdown B is column from database, Data in A and B must be from same row. anonymoushamster@gmail.com ASP .Net 2 11-07-2007 12:40 PM
HOWTO: display database without refresh web page to query database =?Utf-8?B?U1M=?= ASP .Net 3 05-15-2005 08:22 PM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57