UC知道.net 三层和access 不知哪里问题 select没有采用参数的重载
来源：百度知道 编辑：UC知道 时间：2024/06/20 15:21:35
下面是详细代码
Model不写出来了，只做一张简单的表 id 主键 name
web.config
<connectionStrings>
<add name="OleDbConnectionString" providerName="System.Data.OleDb" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}/App_Data/access.mdb" />
</connectionStrings>
sqlhelp
public static string connectionstring = string.Format( ConfigurationManager.ConnectionStrings["OleDbConnectionString"].ConnectionString, HttpContext.Current.Request.PhysicalApplicationPath);
DAL层
namespace DAL
{
public class three
{
private const string PARM_id = "@id";
private const string PARM_name = "@name";
private const string sql_select = "select * from three where 1=1";
private const string sql_select_searchcondition = "and (id like @id or name like @name)";
private const string s
Model不写出来了，只做一张简单的表 id 主键 name
web.config
<connectionStrings>
<add name="OleDbConnectionString" providerName="System.Data.OleDb" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}/App_Data/access.mdb" />
</connectionStrings>
sqlhelp
public static string connectionstring = string.Format( ConfigurationManager.ConnectionStrings["OleDbConnectionString"].ConnectionString, HttpContext.Current.Request.PhysicalApplicationPath);
DAL层
namespace DAL
{
public class three
{
private const string PARM_id = "@id";
private const string PARM_name = "@name";
private const string sql_select = "select * from three where 1=1";
private const string sql_select_searchcondition = "and (id like @id or name like @name)";
private const string s
tbbll.select();//问题所在
这里你没有按函数定义传递相应的参数
public void select(GridView gv, Wuqi.Webdiyer.AspNetPager anp, string searchondition, string sortexpression)
函数定义需要四个参数的，而你使用的时候没有给参数