大虾们,我用SQL查询得一个表,如下的代码Dim cmd As New SQLCommand
Dim dt As DataTable
cmd.C
cmd.CommandText = "Select * From {MA14_MRP_Detail} where ([SNo] Not IN(Select [MRPSNo] From {PU02_Order_Detail})) And ([BillNo] In(Select [BillNo] From {MA14_MRP} where [State] = 2)) And [Qty] > 0 And [PurchaseOrProduce] = '采购'"
dt = cmd.ExecuteReader
Tables("SQLTest_Table1").DataSource = dt
然后是
DataTables("SQLTest_Table1").DataCols.Add("备注",Gettype(String)) '窗口名是 SQLTest
增加这个临时列,然后我再这个临时列输入数据,就会老是提示说该窗口表不存在此“备注”列!
请问为什么?很简单的一个问题,琢磨一晚上了,还是弄不懂?请大虾们指点下。
此主题相关图片如下:临时列.jpg
