语法错误 (操作符丢失)

[rsxhsmm]

AccessDataSource ads = new AccessDataSource();
ads.DataFile = "~/App_Data/WEBSHOP.mdb";
ads.SelectCommand = "select * from cart where cartCustomer = '" + Session["cartName"] + "' and Productid=" + FormView1.DataKey.Value;
DataView dv = (DataView)ads.Select(DataSourceSelectArguments.Empty);//语法错误 (操作符丢失) 在查询表达式 'cartCustomer = 'rv5qjpfr1lxhemozt44yori0' and Productid=' 中。
怎么办？

[贝贝壳壳]

检查一下 FormView1.DataKey.Value 的值

[q107770540]

很简单 单步调试
查看
ads.SelectCommand = "select * from cart where cartCustomer = '" + Session["cartName"] + "' and Productid=" + FormView1.DataKey.Value;
SelectCommand 是多少

在SQL查询分析器中执行一下

[EnForGrass]

[Quote=引用楼主 的回复:]
AccessDataSource ads = new AccessDataSource();
ads.DataFile = "~/App_Data/WEBSHOP.mdb";
ads.SelectCommand = "select * from cart where cartCustomer = '" + Session["cartName"] + "' an……
[/Quote]
ads.SelectCommand = "select * from cart where cartCustomer = '" + Session["cartName"] + "' and Productid=" + FormView1.DataKey.Value;你先看看你的sql语句有问题吗？
FormView1.DataKey.Value这个是整型嘛？