[How Do I:] Create XML Documents from SQL Data?http://asp.netTue, 20 Apr 2010 09:52:35 GMTumbracoComments for [How Do I:] Create XML Documents from SQL Data?enComment Posted by danivinhttp://asp.net/web-forms/videos/data-access/linq-videos-from-the-vb-team/how-do-i-create-xml-documents-from-sql-dataMon, 26 May 2008 09:05:32 GMT00000000-0000-0000-000000006774Thanks Miss.Massi .. Its very clear and cool to understand

Its really worth to listen this ....Those who want to

migrate to VS2008 and easy generation of XML ..Just go thru

this .......  

דזעסוס

]]>Comment Posted by storm_vbshttp://asp.net/web-forms/videos/data-access/linq-videos-from-the-vb-team/how-do-i-create-xml-documents-from-sql-dataFri, 06 Jun 2008 12:51:58 GMT00000000-0000-0000-000000006775Thanks for the nice tutorial. Do you know if it is possible to do the same things using C#? I mean doing them using similar simple syntax without using XDocument and XElement

regards

]]>Comment Posted by cv_vikramhttp://asp.net/web-forms/videos/data-access/linq-videos-from-the-vb-team/how-do-i-create-xml-documents-from-sql-dataMon, 18 Aug 2008 10:58:11 GMT00000000-0000-0000-000000006776thanks for the video.

]]>Comment Posted by Aksarhttp://asp.net/web-forms/videos/data-access/linq-videos-from-the-vb-team/how-do-i-create-xml-documents-from-sql-dataThu, 16 Oct 2008 10:30:06 GMT00000000-0000-0000-000000006777Its Amazing Video, But can I get same thing using C# code?

Thanks!

]]>Comment Posted by djibril_chimere_DIAWhttp://asp.net/web-forms/videos/data-access/linq-videos-from-the-vb-team/how-do-i-create-xml-documents-from-sql-dataFri, 24 Oct 2008 05:10:44 GMT00000000-0000-0000-000000006778Thanks !Jërëjëf!

]]>Comment Posted by angela_chinahttp://asp.net/web-forms/videos/data-access/linq-videos-from-the-vb-team/how-do-i-create-xml-documents-from-sql-dataWed, 27 May 2009 03:15:21 GMT00000000-0000-0000-000000006779XDocument and XElement?

storm_vbs

]]>Comment Posted by mklsmrhttp://asp.net/web-forms/videos/data-access/linq-videos-from-the-vb-team/how-do-i-create-xml-documents-from-sql-dataWed, 08 Jul 2009 21:25:09 GMT00000000-0000-0000-000000006780Excellent video. Can someone tell me how to do this in vwd 2008. This demo is using a console application in vb 2008 and I'm confused how to do it.

Thank you

]]>Comment Posted by mklsmrhttp://asp.net/web-forms/videos/data-access/linq-videos-from-the-vb-team/how-do-i-create-xml-documents-from-sql-dataThu, 09 Jul 2009 00:57:12 GMT00000000-0000-0000-000000006781Excellent video. Can someone tell me how to do this in vwd 2008. This demo is using a console application in vb 2008 and I'm confused how to do it.

Thank you

]]>Comment Posted by vik20000inhttp://asp.net/web-forms/videos/data-access/linq-videos-from-the-vb-team/how-do-i-create-xml-documents-from-sql-dataFri, 21 Aug 2009 08:28:29 GMT00000000-0000-0000-000000006782many thanks for the video

]]>Comment Posted by zeyzonehttp://asp.net/web-forms/videos/data-access/linq-videos-from-the-vb-team/how-do-i-create-xml-documents-from-sql-dataSun, 11 Oct 2009 17:56:27 GMT00000000-0000-0000-000000006783Goodwork massi

]]>Comment Posted by chokeihttp://asp.net/web-forms/videos/data-access/linq-videos-from-the-vb-team/how-do-i-create-xml-documents-from-sql-dataThu, 05 Nov 2009 12:20:56 GMT00000000-0000-0000-000000006784thanks for this cool video!

]]>Comment Posted by jwagenhttp://asp.net/web-forms/videos/data-access/linq-videos-from-the-vb-team/how-do-i-create-xml-documents-from-sql-dataWed, 27 Jan 2010 17:59:28 GMT00000000-0000-0000-000000006785I am recieving an error on my xml file: The XML page cannot be displayed

Invalid at the top level of the document

Any ideas what I did wrong.

Dim ordersXML = <Orders>

<%= From orders In db.Orders _

Select <Order>

<FirstName><%= orders.FirstName %></FirstName>

</Order> %>

</Orders>

ordersXML.Save("C:\Data\orders.xml")

]]>Comment Posted by luis_m_martinezhttp://asp.net/web-forms/videos/data-access/linq-videos-from-the-vb-team/how-do-i-create-xml-documents-from-sql-dataFri, 12 Mar 2010 09:06:58 GMT00000000-0000-0000-000000006786Hi jwagen,

Add at the beginning of your XML this tag <?xml version="1.0"?>

cheers!

]]>Comment Posted by slsaterzhttp://asp.net/web-forms/videos/data-access/linq-videos-from-the-vb-team/how-do-i-create-xml-documents-from-sql-dataTue, 23 Mar 2010 17:04:55 GMT00000000-0000-0000-000000006787I'm following Beth Massi's Namespaces video. When I add to a tag <CATALOG xmlns="..:..:..:..."> in my XML file , I get the following message: The ..... element not declared.

Can you Help?

]]>Comment Posted by sovannahttp://asp.net/web-forms/videos/data-access/linq-videos-from-the-vb-team/how-do-i-create-xml-documents-from-sql-dataSat, 17 Apr 2010 21:54:04 GMT00000000-0000-0000-000000006788The XML page cannot be displayed

Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

--------------------------------------------------------------------------------

Whitespace is not allowed at this location. Error processing resource 'www.bellafindings.com/ Line 1, Posit...

<br><item>1666<title>10MM 3.5CT 4 PRONG SETTING WITH PEG</title>32.62</item><br><item...

]]>Comment Posted by sovannahttp://asp.net/web-forms/videos/data-access/linq-videos-from-the-vb-team/how-do-i-create-xml-documents-from-sql-dataSat, 17 Apr 2010 21:57:44 GMT00000000-0000-0000-000000006789Here is my erro page in browser

The XML page cannot be displayed

Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

--------------------------------------------------------------------------------

Whitespace is not allowed at this location. Error processing resource 'www.bellafindings.com/ Line 1, Posit...

<br><item>1666<title>10MM 3.5CT 4 PRONG SETTING WITH PEG</title>32.62</item><br><item...

I want to creat xml using asp code for google base.

can help me to fix it please, here is my asp page:

<%

Response.ContentType = "text/xml"

'declare the variables

Dim Connection

Dim Recordset

Dim SQL

'declare the SQL statement that will query the database

SQL = "SELECT * FROM findin.products"

'create an instance of the ADO connection and recordset objects

Set Connection = Server.CreateObject("ADODB.Connection")

Set Recordset = Server.CreateObject("ADODB.Recordset")

'open the connection to the database

Connection.Open "DSN=sovanna;UID=vanna;PWD=vann111;Database=products"

'Open the recordset object executing the SQL statement and return records

Recordset.Open SQL,Connection

Response.write("<?xml version='1.0' encoding='ISO-8859-1'?>")

Response.write ("<channel>")

'first of all determine whether there are any records

If Recordset.EOF Then

Response.Write("No records returned.")

Else

'if there are records then loop through the fields

Do While NOT Recordset.Eof

Response.write ("<item>")

Response.write Recordset("idProduct")

Response.write ("<title>")

Response.write Recordset("description")

Response.write ("</title>")

Response.write Recordset("price")

response.write ("</item>")

Response.write "<br>"

Recordset.MoveNext

Loop

End If

'close the connection and recordset objects to free up resources

Response.Write ("</channel>")

Recordset.Close

Set Recordset=nothing

Connection.Close

Set Connection=nothing

%>

]]>Comment Posted by vvvvvdevhttp://asp.net/web-forms/videos/data-access/linq-videos-from-the-vb-team/how-do-i-create-xml-documents-from-sql-dataTue, 20 Apr 2010 09:52:35 GMT00000000-0000-0000-000000006790thanx my dear

]]>