ASP.NET+ACCESS获取随机数据
Random rnd = new Random(unchecked((int)DateTime.Now.Ticks));
int intRandomNumber = rnd.Next();
sql = " SELECT top 1 *,(SELECT TOP 1 ImageURL FROM ProductPic WHERE p.ID=ProdID ORDER BY ID ASC) AS ImageURL FROM Product AS p Where p.IsSpecial=1 ORDER BY Rnd(" + (-1 * intRandomNumber) + "*id)";
int intRandomNumber = rnd.Next();
sql = " SELECT top 1 *,(SELECT TOP 1 ImageURL FROM ProductPic WHERE p.ID=ProdID ORDER BY ID ASC) AS ImageURL FROM Product AS p Where p.IsSpecial=1 ORDER BY Rnd(" + (-1 * intRandomNumber) + "*id)";