How to select random id from database and display randomly o

Currently, I'm working on the Lucky Draw system. So the process of the system is when user click on button draw it select a random id from database where table attendance="Present". I also want to make the output display like animated counter number. Can anyone help me on this.Thanks.

I stuck on the background code :

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.IO;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class _Default : System.Web.UI.Page
{
string constr = ConfigurationManager.ConnectionStrings["lucky"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("SELECT TOP 1 id from [dbo].[EMPLOYEES] ORDER BY NEWID()"))
{
}
}
}
}

This i my EMPLOYEES table :

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dharmraj Thakur8y ago
Just change your column name from the query...

SELECT TOP 1 EMP_ID from [dbo].[EMPLOYEES] ORDER BY NEWID()
Amit Gupta8y ago
https://stackoverflow.com/questions/580639/how-to-randomly-select-rows-in-sql