cmd.Comman
dText &= ", b.FEntryID as Sn,b.FItemID As SerNo,b.FQty As 数量,b.FNote As 备注,b.FDate 交货日期,b.FStockQty as 入库数量"
tb.DataTable.DataCols.Add("未进仓数量",Gettype(Double),"[数量] - [入库数量]")
我现在是加载了数据之后再增加列的,能不能在CommandText代码中完成
cmd.Comman dText &= ", b.FEntryID as Sn,b.FItemID As SerNo,b.FQty As 数量,b.FNote As 备注,b.FDate 交货日期,b.FStockQty as 入库数量,[入库数量] - [数量] as 未进仓数量"
cmd.Comman dText &= ", b.FEntryID as Sn,b.FItemID As SerNo,b.FQty As 数量,b.FNote As 备注,b.FDate 交货日期,b.FStockQty as 入库数量,[b.FStockQty] - [b.FQty] as 未进仓数量"
以上代码出错。
[此贴子已经被作者于2019/1/7 15:32:39编辑过]