Demonstration of XML and SQL Server
Main Menu
>
XML
Messages Element
VisitorID Element
Text: 2
Title Element
Text: Mr
Surname Element
Text: Mayall
Firstname Element
Text: Robert
Email Element
Text: rmayall2@aol.com
Telephone Element
Text: 01892 524185
Message Element
Text: Try this 3!!
DateOfEntry Element
Text: 2008-05-30T01:11:17.440
Messages Element
VisitorID Element
Text: 4
Title Element
Surname Element
Text: Mayall
Firstname Element
Text: Robert
Email Element
Text: rmayall2@aol.com
Telephone Element
Text: 01892 524185
Message Element
Text: Hello!!
DateOfEntry Element
Text: 2008-06-12T00:12:16.293
Messages Element
VisitorID Element
Text: 5
Title Element
Text: Mr
Surname Element
Text: Mayall
Firstname Element
Text: Robert
Email Element
Text: rmayall2@aol.com
Telephone Element
Text: 01892
Message Element
Text: This one should work!!!
DateOfEntry Element
Text: 2008-06-13T00:31:12.043
Messages Element
VisitorID Element
Text: 6
Title Element
Text: Mr
Surname Element
Text: Mayall
Firstname Element
Text: Robert
Email Element
Text: rmayall2@aol.com
Telephone Element
Text: 01892
Message Element
Text: Hello again!!!
DateOfEntry Element
Text: 2008-06-13T01:35:43.373
Messages Element
VisitorID Element
Text: 7
Title Element
Text: Mr
Surname Element
Text: Brown
Firstname Element
Text: Gordon
Email Element
Text: gordon@downingstreet.com
Telephone Element
Text: 0208 345678
Message Element
Text: Hello! Greetings and welcome.
DateOfEntry Element
Text: 2008-06-20T00:49:27.750
Messages Element
VisitorID Element
Text: 8
Title Element
Text: Mr
Surname Element
Text: sadsad
Firstname Element
Text: asdasd
Email Element
Text: asdasd@sda.com
Telephone Element
Text: asdasd
Message Element
Text: asdasdasdasd
DateOfEntry Element
Text: 2008-06-20T17:12:24.063
Messages Element
VisitorID Element
Text: 9
Title Element
Text: Mr
Surname Element
Text: Cutts
Firstname Element
Text: Allan
Email Element
Text: allan_cutts@Yahoo.co.uk
Telephone Element
Message Element
Text: Nice stuff Rob... Hopefully see you in a few weeks... Allan :-)
DateOfEntry Element
Text: 2008-06-24T09:58:14.437
Messages Element
VisitorID Element
Text: 11
Title Element
Text: Miss
Surname Element
Text: Ralph
Firstname Element
Text: Jill
Email Element
Text: jonathan.calder@btopenworld.com
Telephone Element
Text: 01322 663008
Message Element
Text: Where are all the previous messages from other people? I like the ski pix.
DateOfEntry Element
Text: 2008-06-27T16:19:56.293
Messages Element
VisitorID Element
Text: 13
Title Element
Text: Mrs
Surname Element
Text: dsf''dsf
Firstname Element
Text: rgh
Email Element
Telephone Element
Message Element
DateOfEntry Element
Text: 2008-08-13T16:26:41.380
Messages Element
VisitorID Element
Text: 15
Title Element
Text: Mr
Surname Element
Text: '' GO DELETE * FROM users /*
Firstname Element
Text: c
Email Element
Text: x@y.com
Telephone Element
Text: x
Message Element
Text: x
DateOfEntry Element
Text: 2008-09-22T17:46:04.337
Messages Element
VisitorID Element
Text: 17
Title Element
Text: Mr
Surname Element
Text: ;testest;;et;''4%$
Firstname Element
Text: sdf4543^%$?&@^%&%^?@&
Email Element
Text: werrwe@rwter.com
Telephone Element
Text: ?@^%$^%>?$@^?
Message Element
Text: ''''ttest''set''et^£$%^£%";;;.45.3%$@%£@%£$@
DateOfEntry Element
Text: 2008-10-03T09:22:20.583
Messages Element
VisitorID Element
Text: 21
Title Element
Text: Dr
Surname Element
Text: mayall
Firstname Element
Text: martin
Email Element
Telephone Element
Message Element
Text: hello
DateOfEntry Element
Text: 2008-12-09T21:43:25.790
Messages Element
VisitorID Element
Text: 22
Title Element
Text: Miss
Surname Element
Text: Jackson
Firstname Element
Text: Carol-Anne
Email Element
Telephone Element
Message Element
Text: Hi B Hope you''re ok. Have a great Christmas and New Year!!
DateOfEntry Element
Text: 2008-12-11T23:11:29.590
Messages Element
VisitorID Element
Text: 23
Title Element
Text: Miss
Surname Element
Text: Ralph
Firstname Element
Text: Jill
Email Element
Text: jonathan.calder@btopenworld.com
Telephone Element
Text: 01322 663008
Message Element
Text: Interesting upgrade of your website. Impressive.
DateOfEntry Element
Text: 2008-12-13T12:59:07.237
Messages Element
VisitorID Element
Text: 25
Title Element
Text: Mr
Surname Element
Text: Saunders
Firstname Element
Text: Finbarr
Email Element
Text: finbarrsaunders@virgin.com
Telephone Element
Text: 69
Message Element
Text: Fnarr! Fnarr!
DateOfEntry Element
Text: 2008-12-20T04:01:06.187
Messages Element
VisitorID Element
Text: 26
Title Element
Text: Miss
Surname Element
Text: Nonhebel
Firstname Element
Text: Lucinda
Email Element
Telephone Element
Message Element
Text: Hello Bob! Your website is progressing nicely. Have a great time over the Christmas break and hope to catch up with your in the New Year. Lucinda
DateOfEntry Element
Text: 2008-12-22T14:25:28.107
Messages Element
VisitorID Element
Text: 28
Title Element
Text: Miss
Surname Element
Text: Lisa
Firstname Element
Text: Lisa
Email Element
Telephone Element
Message Element
Text: I like your website, especially the photos!
DateOfEntry Element
Text: 2009-01-26T14:00:59.363
Messages Element
VisitorID Element
Text: 29
Title Element
Text: Mr
Surname Element
Text: Richard
Firstname Element
Text: Chunn
Email Element
Text: richard@corporatefx.co.uk
Telephone Element
Text: 02077437000
Message Element
Text: TEST MESSAGE
DateOfEntry Element
Text: 2009-03-12T12:03:30.253
Messages Element
VisitorID Element
Text: 37
Title Element
Text: Mr
Surname Element
Text: Williams
Firstname Element
Text: Rikki
Email Element
Text: williamsri@parliament.uk
Telephone Element
Text: 07778 527298
Message Element
Text: Great website, you have worked hard on this Kaiser Hoch!
DateOfEntry Element
Text: 2009-07-14T17:58:36.730
Messages Element
VisitorID Element
Text: 38
Title Element
Text: Mr
Surname Element
Text: Testing
Firstname Element
Text: Test
Email Element
Text: aa@aaa.com
Telephone Element
Text: 01111 111111
Message Element
Text: Test
DateOfEntry Element
Text: 2009-08-10T11:28:06.073
Messages Element
VisitorID Element
Text: 39
Title Element
Text: Ms
Surname Element
Text: Muhlemann
Firstname Element
Text: Franziska
Email Element
Telephone Element
Message Element
Text: Well done! Your website looks really fancy... :-)
DateOfEntry Element
Text: 2009-09-25T08:54:03.793
Messages Element
VisitorID Element
Text: 41
Title Element
Text: Miss
Surname Element
Text: Ralph
Firstname Element
Text: Jill
Email Element
Text: jonathan.calder@btopenworld.com
Telephone Element
Text: 01322 663008
Message Element
Text: Love the new website, particularly the exchange rate and conversion etc.
DateOfEntry Element
Text: 2009-10-17T12:47:40.750
Messages Element
VisitorID Element
Text: 56
Title Element
Text: Mr
Surname Element
Text: Jones
Firstname Element
Text: Jack
Email Element
Text: jack@jones.com
Telephone Element
Text: 777
Message Element
Text: Hello!
DateOfEntry Element
Text: 2010-07-27T00:12:23.270
Messages Element
VisitorID Element
Text: 57
Title Element
Text: Mrs
Surname Element
Text: Springett
Firstname Element
Text: Sandra
Email Element
Text: sandra.springett@twac.org.uk
Telephone Element
Text: 01892 522591
Message Element
Text: Hi Bob, could you add a link to the bottom of the independant living service page. The link is http://www.ilsse.org.uk/ Thanks
DateOfEntry Element
Text: 2010-07-29T15:00:31.537
Messages Element
VisitorID Element
Text: 65
Title Element
Text: Miss
Surname Element
Text: Nonhebel
Firstname Element
Text: Lucinda
Email Element
Text: lucinda.nonhebel@gmail.com
Telephone Element
Text: 01372 727 108
Message Element
Text: Spending time with John this weekend. He says 'hello' to both of you. Looked at your photo CD last Sat eve (bring back lovely memories) & passing it on to John to view. Hope to see you in the spring. Hope to drive down to TW to see Simone, and hopefully you both too. Interesting times re Egypt!
DateOfEntry Element
Text: 2011-02-12T15:06:24.847
Messages Element
VisitorID Element
Text: 66
Title Element
Text: Mr
Surname Element
Text: q
Firstname Element
Text: q
Email Element
Text: q@q.com
Telephone Element
Text: q
Message Element
Text: q
DateOfEntry Element
Text: 2011-06-27T14:23:15.023
The data is obtained from the same SQL Server table that holds records of messages left by visitors to this site and are displayed on the form using the XML Reader.