Adodc1.RecordSource = "select 位置,位置 from (select sum(数量) as 数量,位置 from SMT_DATA group by 位置)"
用MDB 数据库就可以,使用 SQL Server报")"附件原语法错误
以下是代码 还请各位大伽帮忙看看
谢谢
Private Sub Command1_Click()
Adodc1.RecordSource = "select 位置,位置 from (select sum(数量) as 数量,位置 from SMT_DATA group by 位置)" 'MDB 数据库ok SQL Server报")"附件原语法错误
Adodc1.Refresh
Set MSChart1.DataSource = Adodc1
End Sub
Private Sub Form_Load()
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\db_medicine.mdb;Persist Security Info=False" 'MDB 数据库
Adodc1.ConnectionString = "Provider=SQLOLEDB;server=" & "192.168.0.220" & ";uid=sa;pwd=" & "6600" & ";Initial Catalog=PE" ' SQL Server
End Sub