Question

asp.net datalist如何动态绑定datatable

Answer 1

//先定义一个DateTable，并自定义列，然后循环list数据，插入即可。给你给例子：
  List<beiPinLingYong> beipinlingyonglist = beiPinLingYongManager.GetBeiPinLingYongInfo(beipinlingyong, datefrom, dateto);
                DataTable myTable = new DataTable();
                myTable.Columns.Add(new DataColumn("序号"));
                myTable.Columns.Add(new DataColumn("组织"));
                myTable.Columns.Add(new DataColumn("类别"));
                myTable.Columns.Add(new DataColumn("库别"));
                myTable.Columns.Add(new DataColumn("物资编号"));
                myTable.Columns.Add(new DataColumn("物资名称及规格"));
                myTable.Columns.Add(new DataColumn("货位"));
                myTable.Columns.Add(new DataColumn("单位"));
                myTable.Columns.Add(new DataColumn("领用数量"));
                myTable.Columns.Add(new DataColumn("领用人"));
                myTable.Columns.Add(new DataColumn("领用日期"));
                myTable.Columns.Add(new DataColumn("备注"));

                //读取beipinlingyonglis,填充到DataTable
                DataRow theRow = null;
                beiPinLingYong beipin = null;
                //theRow = myTable.NewRow();
                for (int i = 0; i < beipinlingyonglist.Count; i++)
                {
                    beipin = new beiPinLingYong();
                    beipin = beipinlingyonglist[i];
                    theRow = myTable.NewRow();
                    theRow["序号"] = (i+1).ToString();
                    theRow["组织"] = beipin.DateType;
                    theRow["类别"] = beipin.LeiBie;
                    theRow["库别"] = beipin.KuBie;
                    theRow["物资编号"] = beipin.WuZiBianHao;
                    theRow["物资名称及规格"] = beipin.WuZiMingChen;
                    theRow["货位"] = beipin.HuoWei;
                    theRow["单位"] = beipin.DanWei;
                    theRow["领用数量"] = beipin.LingYongShu;
                    theRow["领用人"] = beipin.LingYongRen;
                    theRow["领用日期"] = beipin.LingYongDate;
                    theRow["备注"] = beipin.Remark;
                    myTable.Rows.Add(theRow);
                }