Question

vb中adodc1 动态确定recordsourse

vb中adodc1 需要绑定到不同的表上，如何用代码实现adodc1动态绑定表，即动态确定recordsourse？
上次报“[adodc]没有指定记录源。[ado]没有为命令对象设置命令。”时我没用代码设置ConnectionString属性，现设置如Private Sub Form_Load()
Adodc1.ConnectionString = "provider=sqloledb.1;persist security info=false;user id=sa;pwd=136;initial catalog=gongzidb;data source=127.0.0.1"

Adodc1.recordsourse = "select * from " & gongzibiao
Set DataGrid1.DataSource = Adodc1

End Sub
ok，多谢大侠 秋也坤和 指教。也谢谢anpsp帮忙！

Answer 1

Adodc1.RecordSource="select * from 不同的表名"

Answer 2

Adodc1.recordsourse = "select * from " & gongzibiao ‘改为：

Adodc1.recordsourse = "select * from gongzibiao"