110,534
社区成员
发帖
与我相关
我的任务
分享
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);
}