How Can Select Random Rows From Database?

Hi

Iam developing online test using ASP.NET,C#.NET.Now my doubt is test takers should get random questions from the database sqlserver2005.Already i ve inserted 10 question into the database.I ve used NEW ID() .But questions are repeating.I am new commer in to IT industry .Provide me with code.Given below is my code.I can retrive questions from the database now but cannot get in random order.protected void Page_Load(object sender, EventArgs e)

{Label10.Visible = false;

Label9.Visible = false;if (!IsPostBack)

{if (Session["id"] == null)

{Session["id"] = 1;

}Session["ans"] = 0;SqlConnection con = new SqlConnection(@"server=123-9181FF31362SQLEXPRESS;user id=sampleu;pwd=Sampleu2;database=n;");

con.Open();

SqlCommand cmd = new SqlCommand("select * from n3 where sno='" + Convert.ToInt16(Session["id"].ToString()) + "' ", con);SqlDataReader re;

re = cmd.ExecuteReader();while (re.Read())

{

 

Label1.Text = re[0].ToString();

Label2.Text = re[1].ToString();

Label3.Text = re[2].ToString();

Label4.Text = re[3].ToString();

Label5.Text = re[4].ToString();

Label6.Text = re[5].ToString();string sss = re[6].ToString();if (sss == "nil")

{

Panel1.Visible = true;Panel2.Visible = false;

}

else

{Panel1.Visible = false;Panel2.Visible = true;

}

}

re.Close();

}

}

 

 protected void Button1_Click(object sender, EventArgs e)

{string Answer = "";if (RadioButton1.Checked == true)

{Answer = "A";

}else if (RadioButton2.Checked == true)

{Answer = "B";

}else if (RadioButton3.Checked == true)

{Answer = "C";

}else if (RadioButton4.Checked == true)

{Answer = "D";

}else if (RadioButton5.Checked == true)

{Answer = "True";

}else if (RadioButton6.Checked == true)

{Answer = "False";

}SqlConnection con1 = new SqlConnection(@"server=123-9181FF31362SQLEXPRESS;user id=sampleu;pwd=Sampleu2;database=n;");

con1.Open();

string ss = Session["id"].ToString();SqlCommand cmd1 = new SqlCommand("select Answer from n3 where sno='" + Convert.ToInt16(Session["id"].ToString()) + "' ", con1);

SqlDataReader re1;string result1 = "";

re1 = cmd1.ExecuteReader();if (re1.Read())

{

result1 = re1[0].ToString();

}

//Session["ans"] = 0;if (Answer == result1)

{Session["ans"] = (Convert.ToInt16(Session["ans"].ToString()) + 1);

 

}

con1.Close();

 Session["id"] = (Convert.ToInt16(Session["id"]) + 1);

RadioButton1.Checked = false;RadioButton2.Checked = false;

RadioButton3.Checked = false;RadioButton4.Checked = false;

RadioButton5.Checked = false;RadioButton6.Checked = false;

 

 SqlConnection con = new SqlConnection(@"server=123-9181FF31362SQLEXPRESS;user id=sampleu;pwd=Sampleu2;database=n;");

con.Open();SqlCommand cmd = new SqlCommand("select * from n3 where sno='" + Convert.ToInt16(Session["id"].ToString()) + "' ", con);SqlDataReader re;

re = cmd.ExecuteReader();

 

 

 while (re.Read())

{

Label1.Text = re[0].ToString();

Label2.Text = re[1].ToString();

Label3.Text = re[2].ToString();

Label4.Text = re[3].ToString();

Label5.Text = re[4].ToString();

Label6.Text = re[5].ToString();string sss = re[6].ToString();if (sss == "nil")

{

Panel1.Visible = true;Panel2.Visible = false;

}

else

{Panel1.Visible = false;Panel2.Visible = true;

}

}

re.Close();int s = Convert.ToInt16(Session["id"].ToString());if (s == 11)

{

Label10.Text = Session["ans"].ToString() + " / " + "10";Label9.Visible = true;

Label10.Visible = true;

//int x = Convert.ToInt16(Session["ans"].ToString());

//int y = (x/10) * 100;//y = Label10.Text;

 

}

////// SqlConnection con6 = new SqlConnection(@"server=123-9181FF31362SQLEXPRESS;user id=sampleu;pwd=Sampleu2;database=n;");

////// con6.Open();

////// SqlCommand cmd6 = new SqlCommand("SELECT CONVERT(int, 10*RAND()) from n3 where sno='" + Convert.ToInt16(Session["id"].ToString()) + "' ", con6);

////// SqlDataReader re6;

////// re6 = cmd6.ExecuteReader();

////// //select top 5 * from Employee order by NEWID()

//////// SELECT FirstName,LastName

////////FROM Person.Contact

////////TABLESAMPLE SYSTEM (10 PERCENT)

 

////// while (re6.Read())

////// {

////// Label1.Text = re6[0].ToString();

////// }

////// con6.Close();

}

}