'=========================================================================================
' 郎 frmDataEnv.frm
'
' 舦戈癟 ⊿Τ舦度ㄑ把σノ硚
'
' ミら戳 2001/06/12
'
' Spencer Yang
'
' ヘ 礚 Data Environment ぇ顶糷Α厨
'
' 秈 翴 Sub Form_Load()
'
' ㄌ ぃ続ノ
'
' 拜肈 ぃ続ノ
'
' ㄏノよ猭 ぃ続ノ
'
' 把σゅ膍
'
'-ず场ゅン ぃ続ノ
'
'-MSDNゅン ぃ続ノ
'
'-呼隔ゅン ぃ続ノ
'
'* 爹 瓃夹肈爹秆兜ヘ種竡叫把綷ゅ㎝呼VB呼ぇ阑瘆虫じ
' 393 夹肈爹秆(Header-style Comment)
'=========================================================================================Option Explicit'=========================================================================================
' ヘ 厨箇凝
'
' ら 戳 By COMMENT
' ---------- ---- -------
' 2001/06/12 SY ミ
'=========================================================================================
Private Sub cmdShow_Click() Dim objCon As ADODB.Connection
Dim objRst As ADODB.Recordset
Dim strShape As String ' 砞﹚ Shape
strShape = "SHAPE {SELECT GRPID, GRPNAME, MRKTYPENAME FROM qryStockGroup} " & _
"APPEND ({SELECT * FROM STKNAME} " & _
"RELATE GRPID TO GRPID) AS cmmStockDetail"
' ン跑计--ADODB
Set objCon = New ADODB.Connection
Set objRst = New ADODB.Recordset
' 矗ㄑ砞﹚
With objCon
.Provider = "MSDataShape"
.Open gstrConn_Shape
End With
' 戈ㄓ方砞﹚
With objRst
.CursorLocation = adUseClient
.Open strShape, objCon
End With
' 厨戈ㄓ方砞﹚
Set rptDataRpt7.DataSource = objRst
' 竤舱琿
With rptDataRpt7.Sections("StockGroup")
.Controls("txtGRPID").DataField = "GRPID"
.Controls("txtGRPNAME").DataField = "GRPNAME"
.Controls("txtMRKTYPE").DataField = "MRKTYPENAME"
End With
' 冈灿戈琿
With rptDataRpt7.Sections("StockDetail")
.Controls("txtSTKID").DataMember = "cmmStockDetail"
.Controls("txtSTKID").DataField = "STKID" .Controls("txtSTKNAME").DataMember = "cmmStockDetail"
.Controls("txtSTKNAME").DataField = "STKNAME" .Controls("txtLASTUPD").DataMember = "cmmStockDetail"
.Controls("txtLASTUPD").DataField = "LASTUPD"
.Controls("txtLASTPRICE").DataMember = "cmmStockDetail"
.Controls("txtLASTPRICE").DataField = "LASTPRICE"
End With
' 陪ボ厨
rptDataRpt7.Show vbModal
End Sub
' 郎 frmDataEnv.frm
'
' 舦戈癟 ⊿Τ舦度ㄑ把σノ硚
'
' ミら戳 2001/06/12
'
' Spencer Yang
'
' ヘ 礚 Data Environment ぇ顶糷Α厨
'
' 秈 翴 Sub Form_Load()
'
' ㄌ ぃ続ノ
'
' 拜肈 ぃ続ノ
'
' ㄏノよ猭 ぃ続ノ
'
' 把σゅ膍
'
'-ず场ゅン ぃ続ノ
'
'-MSDNゅン ぃ続ノ
'
'-呼隔ゅン ぃ続ノ
'
'* 爹 瓃夹肈爹秆兜ヘ種竡叫把綷ゅ㎝呼VB呼ぇ阑瘆虫じ
' 393 夹肈爹秆(Header-style Comment)
'=========================================================================================Option Explicit'=========================================================================================
' ヘ 厨箇凝
'
' ら 戳 By COMMENT
' ---------- ---- -------
' 2001/06/12 SY ミ
'=========================================================================================
Private Sub cmdShow_Click() Dim objCon As ADODB.Connection
Dim objRst As ADODB.Recordset
Dim strShape As String ' 砞﹚ Shape
strShape = "SHAPE {SELECT GRPID, GRPNAME, MRKTYPENAME FROM qryStockGroup} " & _
"APPEND ({SELECT * FROM STKNAME} " & _
"RELATE GRPID TO GRPID) AS cmmStockDetail"
' ン跑计--ADODB
Set objCon = New ADODB.Connection
Set objRst = New ADODB.Recordset
' 矗ㄑ砞﹚
With objCon
.Provider = "MSDataShape"
.Open gstrConn_Shape
End With
' 戈ㄓ方砞﹚
With objRst
.CursorLocation = adUseClient
.Open strShape, objCon
End With
' 厨戈ㄓ方砞﹚
Set rptDataRpt7.DataSource = objRst
' 竤舱琿
With rptDataRpt7.Sections("StockGroup")
.Controls("txtGRPID").DataField = "GRPID"
.Controls("txtGRPNAME").DataField = "GRPNAME"
.Controls("txtMRKTYPE").DataField = "MRKTYPENAME"
End With
' 冈灿戈琿
With rptDataRpt7.Sections("StockDetail")
.Controls("txtSTKID").DataMember = "cmmStockDetail"
.Controls("txtSTKID").DataField = "STKID" .Controls("txtSTKNAME").DataMember = "cmmStockDetail"
.Controls("txtSTKNAME").DataField = "STKNAME" .Controls("txtLASTUPD").DataMember = "cmmStockDetail"
.Controls("txtLASTUPD").DataField = "LASTUPD"
.Controls("txtLASTPRICE").DataMember = "cmmStockDetail"
.Controls("txtLASTPRICE").DataField = "LASTPRICE"
End With
' 陪ボ厨
rptDataRpt7.Show vbModal
End Sub
' 郎 basPath.bas
'
' 舦戈癟 ⊿Τ舦度ㄑ把σノ硚
'
' ミら戳 2001/06/12
'
' Spencer Yang
'
' ヘ 俱盡隔畖ぇ砞﹚
'
' 秈 翴 gstrConnectionString
'
' ㄌ ぃ続ノ
'
' 拜肈 ぃ続ノ
'
' ㄏノよ猭 gstrDBFile_Test 祘砞﹚戈畐 Test.mdb
'
' 把σゅ膍
'
'-ず场ゅン 眏絪帝Visual Basic 6 戈畐秨祇竧竒ISBN 957-8471-34-3
'
'-MSDNゅン ぃ続ノ
'
'-呼隔ゅン ぃ続ノ
'
'=========================================================================================Option Explicit'=========================================================================================
' ヘ : 砞﹚硈絬
'
' ら 戳: BY COMMENT
' ---------- ---- -------
' 2001/06/12 SY ミ
'=========================================================================================
Public Function gstrDBFile_Test() As String gstrDBFile_Test = App.Path & "\DataRpt7.mdb"
End Function'=========================================================================================
' ヘ : 砞﹚戈畐隔畖
'
' ら 戳: BY COMMENT
' ---------- ---- -------
' 2001/06/12 SY ミ
'=========================================================================================
Public Function gstrConn_Test() gstrConn_Test = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & gstrDBFile_Test
End Function'=========================================================================================
' ヘ : 砞﹚戈畐隔畖--Data Shapeぇノ
'
' ら 戳: BY COMMENT
' ---------- ---- -------
' 2001/06/12 SY ミ
'=========================================================================================
Public Function gstrConn_Shape() gstrConn_Shape = "Data Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & gstrDBFile_Test
End Function