Private Sub Command1_Click()
Adodc_index.RecordSource = "select * from table1 where ID = '1000022'"
Adodc_index.refresh
set datagrid1.datasource=adodc_index.recordset
DataGrid1.Refresh
End Sub
Adodc_index.RecordSource = "select * from table1 where ID = '1000022'"
Adodc_index.refresh
set datagrid1.datasource=adodc_index.recordset
DataGrid1.Refresh
End Sub
如果设置成1 - adcmdtext 命令文本里面应该怎样写呢??
命令文本内就写:select * from table1 where ID = '1000022'