Random Records From Access Database

[guru_iyer]

Hey I am trying to do a project on Test Engine. I need to retrieve random rows of questions from access database. I did the following code, but every time I once close and run it again, the sequence of questions is same. How can I change the sequence every time?

private void button1_Click(object sender, EventArgs e)
        {
            OleDbConnection con = new OleDbConnection(Connection.conStr);
            OleDbCommand cmd = new OleDbCommand("select * from dell order by Rnd(serialNumber)", con);
            OleDbDataAdapter adp = new OleDbDataAdapter(cmd);
            DataSet ds = new DataSet();
            adp.Fill(ds, "new");
            dataGridView1.DataSource = ds.Tables["new"];
        }

[Momerath]

SELECT *, Rnd(serialNumber) FROM dell ORDER BY Rnd(serialNumber)

[abelLazm]

check this link it contains a detailed discussion on how to randomly select values

[Saikalyankumar]

You, can also refer to this link http://www.aspfree.com/c/a/ASP-Code/SQL-statement-tip-to-randomize-a-Result-Set-Order-by-NewId/

[abelLazm]

Use any of these Queries

SELECT *, rand(@@IDLE % (@@ROWCOUNT + serialNumber))as xx FROM dell ORDER BY xx
//or
SELECT *,(sin(serialNumber * rand())) as xx from dell
ORDER BY xx

[guru_iyer]

@abelLazm Thanks a lot.. It worked..