法1:
引用 Microsoft Script Control 1.0 (也可用控件)
objects: Form1、Command1、Text1
Code:
Private Sub Form_Load()
Text1.Text = "1+2+sqr(3)"
End Sub
Private Sub Command1_Click()
Dim s As New MSScriptControl.ScriptControl
s.Language = "VBScript"
s.AddObject "Form1", Me
s.AddCode "a=" & Trim(Text1.Text)
s.ExecuteStatement "Form1.Caption = a"
End Sub
法2:
Dim c As New ADODB.Connection
c.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\NWind2K.mdb;Persist Security Info=False"
Dim r As New ADODB.Recordset
Text1.Text=sqr(1*1+1)
r.Open "Select DISTINCT " & Trim(Text1.Text) & " From YourTable", c
'YourTable为任意已存在的表名 (Ms SQL Server 可不用 From 子句)
MsgBox r.Fields(0).Value