sSQL = " - - -- "
WebService.GetDataTable(sSQL, oDt)
With Me.spdData_Sheet1
.RowCount = 0
For i As Integer = 0 To oDt.Rows.Count - 1
.RowCount = .RowCount + 1
.SetText(.RowCount - 1, 0, oDt.Rows(i)("CUSTOMERID").ToString())
.SetText(.RowCount - 1, 1, oDt.Rows(i)("PRODUCTID").ToString())
.SetText(.RowCount - 1, 2, oDt.Rows(i)("WFCSPEC").ToString())
.SetText(.RowCount - 1, 3, oDt.Rows(i)("VOLUME").ToString())
.SetText(.RowCount - 1, 4, oDt.Rows(i)("FORMULA").ToString())
.SetText(.RowCount - 1, 5, oDt.Rows(i)("QCSTAGE").ToString())
.SetText(.RowCount - 1, 6, oDt.Rows(i)("IS_COMP").ToString())
.SetText(.RowCount - 1, 7, oDt.Rows(i)("SHIPTYPE").ToString())
.SetText(.RowCount - 1, 8, oDt.Rows(i)("WFCTYPE").ToString())
.SetText(.RowCount - 1, 9, oDt.Rows(i)("WFCSTOCK").ToString())
.SetText(.RowCount - 1, 10, oDt.Rows(i)("MIDTYPE").ToString())
Next
End With
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/125024.html
標籤：網絡編程
上一篇：撰寫學生學業管理程式，要求可以統計每個知識點的掌握，如何設計資料庫？
下一篇：ACCESS