C#操作ACCESS时，参数传不进，在线等大神！！

[zx670554906]

public DataTable FindAccess1(string startdate,string enddate,string sno)
{
OleDbParameter[] _param = new OleDbParameter[3];
_param[0] = new OleDbParameter("@startdate", startdate);
_param[1] = new OleDbParameter("@enddate", enddate);
_param[2] = new OleDbParameter("@sno", sno);

_param[0].DbType = DbType.String;
_param[1].DbType = DbType.String;
_param[2].DbType = DbType.String;
return this.accessExcuteSelectData1("SELECT TLinkData.SNO, Max(TLinkData.TestDT) AS TestDT FROM TLinkData where TestDT>#" + @startdate + "# and TestDT<#" + @enddate + "# and SNO=@sno GROUP BY TLinkData.SNO", _param);
}

sno死活传不进SQL语句，如果把sno换成固定值‘1001’就能查到数据，代码已跟踪参数能传方法进来，就是ACCESS最后执行结果集为空，数据库为ACCESS！在线等大神

[zx670554906]

@startdate和@enddate都能传得进去，在线求解啊！

[吉普赛的歌]

看下人家写的和你的有什么区别吧 http://blog.csdn.net/aspnet2002web/article/details/7584796

[吉普赛的歌]

msdn上的还是最经典： https://msdn.microsoft.com/zh-cn/library/system.data.oledb.oledbparameter(v=vs.110).aspx

[易2017]

代码的这样看

public DataTable FindAccess1(string startdate,string enddate,string sno)
        {
            OleDbParameter[] _param = new OleDbParameter[3];
            _param[0] = new OleDbParameter("@startdate", startdate);
            _param[1] = new OleDbParameter("@enddate", enddate);
            _param[2] = new OleDbParameter("@sno", sno);

            _param[0].DbType = DbType.String;
            _param[1].DbType = DbType.String;
            _param[2].DbType = DbType.String;
            return this.accessExcuteSelectData1("SELECT TLinkData.SNO, Max(TLinkData.TestDT) AS TestDT FROM TLinkData where TestDT>#" + @startdate + "# and TestDT<#" + @enddate + "# and SNO=@sno GROUP  BY TLinkData.SNO", _param);
        }

[秋的红果实]

return this.accessExcuteSelectData1("SELECT TLinkData.SNO, Max(TLinkData.TestDT) AS TestDT FROM TLinkData where TestDT>#@startdate# and TestDT<#@enddate# and SNO='@sno' GROUP BY TLinkData.SNO", _param); 改成这样应该可以，没测试，你自己检查下，比如是否缺少空格