在迭代datatable并将每个值赋给数据契约列表中的给定属性时,我遇到了一些困难。
因此,我有以下DataContract:
namespace Shared.DataContracts
{
[Serializable]
[DataContract(Name = "DispatchAddress")]
public class DispatchDetails
{
[DataMember(Name = "ShippingAddressCode")]
public string ShippingAddressCode { get; set; }
[DataMember(Name = "ShippingName")]
public string ShippingName { get; set; }
[DataMember(Name = "Address")]
public Address Address { get; set; }
[DataMember(Name = "ContactName")]
public string ContactName { get; set; }
//etc
}
}在我的服务中,我希望返回一个DispatchDetails列表,但我的问题是为每个属性赋值。
public GetDispatchDetailsResponse GetDispatchDetails(string code, string id)
{
GetDispatchDetailsResponse getDispatchDetailsResponse = new GetDispatchDetailsResponse();
List<DispatchDetails> dispatchDetails = new List<DispatchDetails>();
DataTable dt = _dataRetriever.GetDataTable(string.Format(BusinessSqlConstants. DispatchAddress, code, id));
foreach (var row in dt.Rows)
{
foreach (var col in dt.Columns)
{
//The troublesome line of code.
dispatchDetails.Add("ShippingAddressCode") = Convert.ToString(dt.Columns["ShippingAddressCode"]);
//etc
}
}
}我在中添加了我最新的不可靠的代码行,以演示我试图实现的目标。我已经尝试了几种方法,但目前我似乎很难从树丛中看到林子:)
提前感谢您给出的建议。
温馨的问候,克里斯蒂安
发布于 2012-09-20 01:26:58
你是不是想这么做?
foreach (DataRow row in dt.Rows)
{
var item = new DispatchDetails();
item.ShippingAddressCode = Convert.ToString(row["ShippingAddressCode"]);
item.ShippingName = Convert.ToString(row["ShippingName"]);
// etc.
dispatchDetails.Add(item);
}https://stackoverflow.com/questions/12499796
复制相似问题