使用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屋!