} public void Bind() { string sql = "Select TOP 3 * From [Name] Order By Rnd(PKID)"; OleDbDataAdapter dr = new OleDbDataAdapter(sql, con); DataSet ds = new DataSet(); dr.Fill(ds); GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); }
我最想知道的是我在ACCESS里面查询,就一点错误都没、做成程序出线这样的 问题
使用randim随机数 SELECT top 10 * FROM [Name] Order By Rnd(rnd(-1*id*0.123))
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
Bind();
}
}
public void Bind()
{
string sql = "Select TOP 3 * From [Name] Order By Rnd(PKID)";
OleDbDataAdapter dr = new OleDbDataAdapter(sql, con);
DataSet ds = new DataSet();
dr.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
SELECT top 10 * FROM [Name] Order By Rnd(rnd(-1*id*0.123))