# Re: 大汉堡.又要麻烦你了

Posted by 阿哲 on November 15, 1999 at 12:03:21:

In Reply to: Re: DataEnvironment于执行阶段设定路径后,该如何设定开启资料表 posted by 大汉堡 on November 14, 1999 at 22:51:04:

: : 路径,如:
: : Private Sub Connection1_WillConnect(ConnectionString As String, Userid As String, Password As String, Options As Long, adStatus As ADODB.EventStatusEnum, ByVal pConnection As ADODB.Connection)
: : DataEnvironment1.Connection1.Properties("data source") = Path_str
: : End Sub
: : Path_str资料库下有多个资料表,如何动态设给command1指令

: 这不是很麻烦吗?为何不在DataEnvirontment中就设定
: 好呢??
: 当然设计时需要DataBase Path,但设计完再将Path清
: 空,你还是可执行阶段指定Path
用adodc方式开启是
Adodc1.ConnectionString= "provider=microsoft.jet.oledb.3.51;" & "data source=use\" & datap & ".mdb"

Adodc1.RecordSource = "select * from " & DATANNN
& " "
Adodc1.Refresh
其中,DATANNN是资料表名称变数
用DataEnvironment方式开启是
DataEnvironment1.Connection1.Properties("data source") = "use\" & datap & ".mdb"
再来如何才能开启DATANNN资料表呢?
谢谢" 祝生意兴隆,

Follow Ups:

- Re: 大汉堡.又要麻烦你了 大汉堡 20:36:24 11/17/99 (0)