使用Visual Web Developer 2010 Express填充来自asp.net Web服务中DB的子元素 [英] Fill child elements from DB at asp.net webservice with visual web developer 2010 express

问题描述

你好

我以前有一个关于Web服务响应中子元素的主题；

I had a previous thread about child elements in web service response;

https://social.msdn.microsoft.com/Forums/vstudio/zh-CN/f75a2a34-80c1-43a6-a1e8-10b5bb96724a/child-elements-for-aspnet-webservice-with-visual-web-developer -2010-express?forum = wcf

https://social.msdn.microsoft.com/Forums/vstudio/en-US/f75a2a34-80c1-43a6-a1e8-10b5bb96724a/child-elements-for-aspnet-webservice-with-visual-web-developer-2010-express?forum=wcf

我得到了我所问的问题，即如何构建这样的结构，这很棒，但是结构中充满了硬编码"的内容.价值观.我想使用来自DB的数据来构建Web服务响应.响应可能是短的还是长的，具体取决于数据库查询结果. 如果我们使用该示例，那么我之前在上一个线程和示例数据中使用的示例将是这样；

I got answer what I asked, how to build a such structure, that was great, but structure was filled with "hardcoded" values. I would like to build web service response with data from DB. Response might be short or long, depending of DB query results. If we use that example what I used earlier in previous thread and example data would be something like this;

响应就像在下面的上一个线程中一样.制造商可以是1-n，模型可以是1-n.

<状态>确定</状态>
< cars>
    < car>
       <制造>标致</制造>
       <模型>
           < model>
                             < name> 405</name>
                             < engine> 1,6</engine>
                             < doors> 4</doors>
                             < color>黑色</color>
                             < price> 1000</price>
           </model>
           < model>
                             < name> 306</name>
                             < engine> 1,4</engine>
                             < doors> 3</doors>
                             < color>红色</color>
                             < price> 500</price>
           </model>
           < model> ...</model>
       </models>
    </car>
    < car>
       <制造>大众</制造>
       < models>
           < model>
                             < name>高尔夫球</name>
                             < engine> 1,4</engine>
                             < doors> 5</doors>
                             < color>白色</color>
                             < price> 5000</price>
           </model>
       </models>
    </car>
    < car>
    ...
    </car>
</cars>

And response like it was on previous thread like below. Manufactures can be 1-n, Models can be 1-n.

<status>OK</status>
<cars>
    <car>
        <manufacture>Peugeot</manufacture>
        <models>
            <model>
                <name>405</name>
                <engine>1,6</engine>
                <doors>4</doors>
                <color>black</color>
                <price>1000</price>
            </model>
            <model>
                <name>306</name>
                <engine>1,4</engine>
                <doors>3</doors>
                <color>red</color>
                <price>500</price>
            </model>
            <model>...</model>
        </models>
    </car>
    <car>
        <manufacture>Volkswagen</manufacture>
        <models>
            <model>
                <name>Golf</name>
                <engine>1,4</engine>
                <doors>5</doors>
                <color>white</color>
                <price>5000</price>
            </model>
        </models>
    </car>
    <car>
     ...
    </car>
</cars>

推荐答案

您好，Juuso，

对于您的要求，我认为您可以将此要求分为两部分.首先，从SQL Server获取数据，并将其存储在DataTable中.其次，将DataTable转换为类对象.

我建议您参考以下链接:

#将数据表转换为嵌套对象

http://stackoverflow .com/questions/28252197/converting-a-data-table-to-nested-object

最好的问候

爱德华

这篇关于使用Visual Web Developer 2010 Express填充来自asp.net Web服务中DB的子元素的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！