C#手动填充DataSet

最新推荐文章于 2024-04-26 15:30:27 发布

Chenzhigang_002

最新推荐文章于 2024-04-26 15:30:27 发布

阅读量1.3k

点赞数 1

分类专栏： C#开发篇文章标签： c# servlet java

本文链接：https://blog.csdn.net/gang148375/article/details/126668613

版权

C#开发篇专栏收录该内容

12 篇文章 0 订阅

订阅专栏

1、创建DataSet

2、创建DataTable

3、将DataTable加入到DataSet

4、创建列

5、创建行、并加入到DataTable

以下是Demo 代码

DataSet ds = new();
DataTable dt = new DataTable("MyTable");//创建一个名为MyTable的DataTalbe
ds.Tables.Add(dt);
dt.Columns.Add(new DataColumn("BillCode", typeof(string)));
dt.Columns.Add(new DataColumn("OrderNo", typeof(string)));
dt.Columns.Add(new DataColumn("SellerName", typeof(string)));
dt.Columns.Add(new DataColumn("GoodsName", typeof(string)));

dt.Columns.Add(new DataColumn("Pcs", typeof(Int32)));
dt.Columns.Add(new DataColumn("ClaimReason", typeof(string)));
dt.Columns.Add(new DataColumn("Weight", typeof(float)));
dt.Columns.Add(new DataColumn("Price", typeof(float)));

dt.Columns.Add(new DataColumn("Amount", typeof(float)));
dt.Columns.Add(new DataColumn("Remark", typeof(string)));
dt.Columns.Add(new DataColumn("ApplyTime", typeof(string)));
dt.Columns.Add(new DataColumn("TakePartsDate", typeof(string)));

foreach(TData data in MainDataList)
{
DataRow dr = dt.NewRow();
dr["BillCode"] = data.BillCode;
dr["OrderNo"] = data.OrderNo;
dr["SellerName"] = data.SellerName;
dr["GoodsName"] = data.GoodsName;

dr["Pcs"] = data.Pcs;
dr["ClaimReason"] = data.ClaimReason;
dr["Weight"] = data.Weight;
dr["Price"] = data.Price;

dr["Amount"] = data.Amount;
dr["Remark"] = data.Remark;
dr["ApplyTime"] = data.ApplyTime;
dr["TakePartsDate"] = data.TakePartsDate;
dt.Rows.Add(dr);
}