public DataTable selectParam(string bName, string mNmae, string FileName) { SQLiteParameter[] param = null; DataTable dt = new DataTable(); string sql = "select SeqNo,FileName, Size, LastModified, MonitorName, BucketName,Status from Monitor where BucketName ='" + bName + "' "; if (!string.IsNullOrEmpty(mNmae)) { sql += " and MonitorName='" + mNmae + "'"; } if (!string.IsNullOrEmpty(FileName)) { sql += " and FileName='" + FileName + "'"; } sql += "order by LastModified desc"; dt = sqlLiteHelper.ExecuteDataTable(sql, param); return(dt); }