Please Anybody Tell me How to Show Random Records ?

See more:

C#

ASP.NET

SQL-Server

hi sir , I am Using This Code To show Random Images .. But When I run this code it is not giving me Random Records .. but When I removed ORDER BY ImageID() it is working good
Please Anybody Tell me How to Show Random Records ?

I am Fresher sir ,Thanks In Advance :)

My back end is SQL SERVER
and My Code Is :

protected void BindDataList()
{
        con.Open();

        //Query to get ImagesName and Description from database
        SqlCommand command = new SqlCommand("SELECT TOP 5 * FROM [SlideShowTable1]  where (startddate <= @sdate) AND (endddate >=@edate) AND AddType=@Add ORDER BY ImageID() ", con);

        command.Parameters.AddWithValue("@sdate", System.DateTime.Now.ToString("M/d/yyyy"));
        command.Parameters.AddWithValue("@edate", System.DateTime.Now.ToString("M/d/yyyy"));
        command.Parameters.AddWithValue("@Add", "Right_Side_Add");
      
        SqlDataAdapter da = new SqlDataAdapter(command);
        DataSet dt = new DataSet();
        da.Fill(dt);

        dllImages.DataSource = dt;
        dllImages.DataBind();
        con.Close();
  
}