string strSQL; strSQL="select * From T_Base_Sign Where (LoginID=@a And LoginPW=@b) "+ " And (Time_Limit=@c And Time_Start>@d Or Time_Limit=@e) "; --------------------------------------------------------------------- string strSQL; strSQL="select * From T_Base_Sign Where (LoginID=? And LoginPW=?) "+ " And (Time_Limit=? And Time_Start>? Or Time_Limit=?) ";
例如:
mCmm.Parameters.Add(new OleDbParameter("LoginPW",strLoginPW.Trim()));
。。
mCmm.Parameters.Add(new OleDbParameter("LoginPW",strLoginPW.Trim()));
strSQL="select * From T_Base_Sign Where (LoginID=@a And LoginPW=@b) "+
" And (Time_Limit=@c And Time_Start>@d Or Time_Limit=@e) ";
---------------------------------------------------------------------
string strSQL;
strSQL="select * From T_Base_Sign Where (LoginID=? And LoginPW=?) "+
" And (Time_Limit=? And Time_Start>? Or Time_Limit=?) ";