日期:2014-05-17 浏览次数:20894 次
///读记录
public DataSet SiteListSelect(Nob.Model.SiteList model)
{
OleDbParameter[] parameters = {
new OleDbParameter("@SiteTypeId", model.SiteTypeId ),
};
1) DataSet ds = DBhelper.ExecuteDataSet("select * from SiteList where siteTypeId=@SiteTypeId");//为什么这里会参数化会提示无法找到表
2) DataSet ds = DBhelper.ExecuteDataSet("select * from SiteList where siteTypeId=" + model.SiteTypeId);//用拼接却正常?
return ds;
}