执行以下代码时出现错误提示(如标题),请高手帮忙,感谢!
Private Sub Command1_Click()
Adodc2.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AIS20061125222715;Data Source=KMWM1"
Adodc2.CommandType = adCmdUnknown
Adodc2.RecordSource = "select sum(t_lockstock.fqty)as sk from t_lockstock group by fitemid"
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AIS20061125222715;Data Source=KMWM1"
Adodc1.CommandType = adCmdUnknown
Adodc1.ReselectcordSource = "select t_icitem.fname,fmodel,sum(icinventory.fqty) from t_icitem right outer join icinventory on t_icitem.fitemid=icinventory.fitemid and t_icitem.fname like " & "'%" & Text1.text& '%"' group by t_icitem.fname,t_icitem.fmodel,icinventory.fitemid order by fname"
Set DataGrid2.DataSource = Adodc2
Set DataGrid1.DataSource = Adodc1
End Sub
Private Sub Command1_Click()
Adodc2.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AIS20061125222715;Data Source=KMWM1"
Adodc2.CommandType = adCmdUnknown
Adodc2.RecordSource = "select sum(t_lockstock.fqty)as sk from t_lockstock group by fitemid"
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AIS20061125222715;Data Source=KMWM1"
Adodc1.CommandType = adCmdUnknown
Adodc1.ReselectcordSource = "select t_icitem.fname,fmodel,sum(icinventory.fqty) from t_icitem right outer join icinventory on t_icitem.fitemid=icinventory.fitemid and t_icitem.fname like " & "'%" & Text1.text& '%"' group by t_icitem.fname,t_icitem.fmodel,icinventory.fitemid order by fname"
Set DataGrid2.DataSource = Adodc2
Set DataGrid1.DataSource = Adodc1
End Sub
解决方案 »
- MM求救2
- 怎么才可以只显示查询记录的前十条呢?
- 麻煩大家給個用存儲過程鏈接其它地方的SQL,並從它讀出記錄在本地SQL創建一個視圖的例子
- ★★★高并发数据库存取如何处理?
- 难,高手请进来指导,菜鸟进来学习!100分
- 不同格式的datetime比较的疑惑
- 帮忙看看这个sql还可以怎么优化
- 求助解决全文检索查询一无效的问题
- 自学SQL Server第一天:一台普通的个人电脑,装上Windows2000 server+SQL Server2000拨号上网,别人怎样从Internet上访问我的SQL Server数据
- 如何删除两张表的相关性,急!!!
- xp下安装sqlserver2000,1433端口打不开,jdbc无法链接
- SQLSERVER2000验证
like " & "'%" & Text1.text& '%"' 改為 like " & "'%" & Text1.text& "%'"
like " & "'%" & Text1.text& '%"' 改為 like " & "'%" & Text1.text& "%'"
Adodc2.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AIS20061125222715;Data Source=KMWM1"
Adodc2.CommandType = adCmdUnknown
Adodc2.RecordSource = "select sum(t_lockstock.fqty)as sk from t_lockstock group by fitemid"
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AIS20061125222715;Data Source=KMWM1"
Adodc1.CommandType = adCmdUnknown
Adodc1.ReselectcordSource = "select t_icitem.fname,fmodel,sum(icinventory.fqty) from t_icitem right outer join icinventory on t_icitem.fitemid=icinventory.fitemid and t_icitem.fname like " & "'%" & Text1.text & '%"' & " group by t_icitem.fname,t_icitem.fmodel,icinventory.fitemid order by fname"
Set DataGrid2.DataSource = Adodc2
Set DataGrid1.DataSource = Adodc1
End Sub
Adodc2.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AIS20061125222715;Data Source=KMWM1"
Adodc2.CommandType = adCmdUnknown
Adodc2.RecordSource = "select sum(t_lockstock.fqty) as sk from t_lockstock group by fitemid"
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AIS20061125222715;Data Source=KMWM1"
Adodc1.CommandType = adCmdUnknown
Adodc1.ReselectcordSource = "select t_icitem.fname,fmodel,sum(icinventory.fqty) from t_icitem right outer join icinventory on t_icitem.fitemid=icinventory.fitemid and t_icitem.fname like " & "'%" & Text1.text & "%'" & " group by t_icitem.fname,t_icitem.fmodel,icinventory.fitemid order by fname"
Set DataGrid2.DataSource = Adodc2
Set DataGrid1.DataSource = Adodc1
End Sub
Private Sub Command1_Click()
Adodc2.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AIS20061125222715;Data Source=KMWM1"
Adodc2.CommandType = adCmdUnknown
Adodc2.RecordSource = "select sum(t_lockstock.fqty)as sk from t_lockstock group by fitemid"
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AIS20061125222715;Data Source=KMWM1"
Adodc1.CommandType = adCmdUnknown
Adodc1.ReselectcordSource = "select t_icitem.fname,fmodel,sum(icinventory.fqty) from t_icitem right outer join icinventory on t_icitem.fitemid=icinventory.fitemid and t_icitem.fname like '%" & Text1.text & "%' group by t_icitem.fname,t_icitem.fmodel,icinventory.fitemid order by fname"
Set DataGrid2.DataSource = Adodc2
Set DataGrid1.DataSource = Adodc1
End Sub