December 4, 2008 05:18pm pst

1. Fernando... 179,339
2. naspinski 60,700
3. novynov 18,300
4. CarlVerret 17,064
5. sjturner2 14,250
6. Ceiled 12,500
7. BToson 8,000
8. emoreau 7,500
8. TKOTC 7,500
10. PockyMas... 7,452
11. TheLearn... 6,672
12. The_eagle 6,400
13. CMYScott 5,750
14. Praesidium 4,664
15. CodeCruiser 4,450
16. amx 4,200
17. GreenGho... 4,150
18. graye 4,000
18. VBRocks 4,000
20. jaime_oliv... 3,700
21. angelIII 3,600
22. moseack 3,500
23. gardavis 3,000
23. Dhaest 3,000
25. ZachSmith 2,600

1. Fernando... 179,339
2. naspinski 60,700
3. sjturner2 20,250
4. novynov 18,300
5. CarlVerret 17,064
6. Ceiled 12,500
7. BToson 8,000
8. emoreau 7,500
8. TKOTC 7,500
10. PockyMas... 7,452
11. TheLearn... 6,672
12. The_eagle 6,400
13. CMYScott 5,750
14. Praesidium 4,664
15. CodeCruiser 4,450
16. amx 4,200
17. GreenGho... 4,150
18. graye 4,000
18. VBRocks 4,000
20. jaime_oliv... 3,700
21. angelIII 3,600
22. moseack 3,500
23. gardavis 3,000
23. Dhaest 3,000
25. ZachSmith 2,600

10.08.2008 at 07:46AM PDT, ID: 23797491

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.8

LINQ to XML reading binary string from SQL stored procedure

Asked by psuscott in Visual Studio, Language Integrated Query - LINQ

Tags: XML, IE 7

In an attempt to write a program in visual studio 2008 that will build an xml file with po information I have reached a point where I am stuck with trying to call a stored procedure with four lines of code into the xml file. It is reading the stored procedure because it is bringing back Build_XML.gettextResult four times. If there is anyone more experienced at writing this type of code please advise how to correct this code. Thank you for your time. Below is hopefully the information you will need to understand what I am looking at. I have included the stored procedure as gettext in the .dmbl tab in visual studio 2008 as well.

Stored procedure(gettext)

CREATE PROCEDURE gettext AS
select cast(t_text as char) as t_test from ttttxt010500
where t_ctxt = 125421
GO
Start Free Trial

         
             Module Module1
 
 Sub Main()
  Dim db As New BAANDataContext
  Dim orders = <orders>
        <%= From text In db.gettext _
            Select <text>
                      <text><%= text %></text>
                   </text> %>
       </orders>
 
  orders.Save("C:\Users\scsowers\Desktop\orders.xml")
  Process.Start("C:\Users\scsowers\Desktop\orders.xml")
 
 End Sub
 
End Module

Attachments:

sql.jpg (92 KB) (File Type Details)

snapshot of the data on sql server

Keywords: LINQ to XML reading binary string from …

	Title
1	Extract Binary XML data to readable X…
2	XML Reader
3	SQL Server, (FOR) XML, REAL R…
4	BINARY SERIALIZATION vs XML SERIA…
5	Working with Oracle XML data
6	Is XML files a virus threat?

Loading Advertisement...

20081112-EE-VQP-44 / EE_QW_2_20070628

LINQ to XML reading binary string from SQL stored procedure

Asked by psuscott in Visual Studio, Language Integrated Query - LINQ

Tags: XML, IE 7

About this solution