如何在返回XML数据的C#中处理Storedprocedure. [英] How to handle Storedprocedure in c# which return xml data.

问题描述

我具有存储过程，该存储过程返回以下xml

i am having stored procedure which return the below xml

<TRR>
<CONTROL>
    <Batch_ID>03/22/2012 20:38:51:527</Batch_ID>
    <Process_Date>03/22/2012</Process_Date>
    <Status>I</Status>
    <Source>sp_MPC_TRR_OutBound</Source>
    <DetailsCount>41</DetailsCount>
  </CONTROL>
 <Detail>
    <RouteId>1</RouteId>
    <OriginProduct>Natural Gasoline</OriginProduct>
    <Segment>
      <SegmentId>3</SegmentId>
      <Orgin>Galena Park, TX - Kinder Morgan Terminal</Orgin>
    </Segment>
    <ToDate>2012-04-30T23:59:00</ToDate>
  </Detail>
   <Detail>
    <RouteId>2</RouteId>
    <OriginProduct>Natural Gasoline</OriginProduct>
    <Segment>
      <SegmentId>4</SegmentId>
      <Orgin>Galena Park, TX - Kinder Morgan Terminal</Orgin>
    </Segment>
    <ToDate>2012-04-30T23:59:00</ToDate>
  </Detail>
  </TRR>

而且我有2个班级，如下所示

and i am have 2 class as below

public class SRADBData
    {
        public virtual int routeId { get; set; }
        public virtual string originProduct { get; set; }
        public virtual Segment segment { get; set; }
        public virtual DateTime toDate { get; set; }
    }

    public class Segment
    {
        public virtual int segmentId { get; set; }
        public virtual string orgin { get; set; }
    }

而且我有一个SRADBData类的列表对象，如下所示

and i am having a list object for SRADBData class as below

List<SRADBData> lstData= new  List<SRADBData> ();

我想做的是
在C#中执行存储的过程并获取xml并将数据分配给lstData对象.

what i want to do is
execute the storedprocedure in c# and get the xml and assign the data to lstData object.

if any help will appreciated.

推荐答案

将xml作为字符串返回，然后创建一个xml文档，您可以根据需要从中反序列化该对象.

Return the xml as a string then create an xml document from which you can deserialize the object as required.

这篇关于如何在返回XML数据的C#中处理Storedprocedure.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！