建立一个DATA控件,一个条件输入框,一个MSFLEXGRID控件和一个COMMAND按扭。
将MSFLEXGRID与DATA控件建立连接,再使用如下程序即可。
Private Sub Command1_Click()
Dim sql1 As String
sql1 = CStr(Text1.Text)
DoSql (sql1)
Data1.Refresh
End SubSub DoSql(sql1)
Dim mysql$
mysql$ = "SELECT "
mysql = mysql & " * from 系别 where id="
mysql = mysql & sql1
Data1.RecordSource = mysql
End Sub
将MSFLEXGRID与DATA控件建立连接,再使用如下程序即可。
Private Sub Command1_Click()
Dim sql1 As String
sql1 = CStr(Text1.Text)
DoSql (sql1)
Data1.Refresh
End SubSub DoSql(sql1)
Dim mysql$
mysql$ = "SELECT "
mysql = mysql & " * from 系别 where id="
mysql = mysql & sql1
Data1.RecordSource = mysql
End Sub
Dim adoConnection as New ADODB.Connection
Dim adoRecordset as New ADODB.Recordset
adoConnection.Open "Data Provider=MSDASQL.1;User ID=;Password =;driver=MySQL;host=localhost;database=test"
adoRecordset.Open "SELECT * FROM TableName",adoConnection