random fetch display data to dropdownlist
<p>basically i wish to random the item display in dropdownlist ,any function can work with it?</p>

<p><strong>output</strong></p>

<p>a</p>

<p>b</p>

<p>c</p>

<p><strong>expected output (can be any but not only abc)</strong></p>

<p>b</p>

<p>a</p>

<p>c</p>

<p>OR</p>

<p>c</p>

<p>a</p>

<p>b</p>

<p>OR</p>

<p>any</p>

<hr>

<p>asp:Label ID="Label3" Text=' &lt;%#DataBinder.Eval(Container.DataItem, "Question")%> ' Runat="server"</p>

<hr>

<p>Select * from (SELECT [r1] AS [Option] FROM [ExerciseTable] WHERE ([Question] = @Question)</p>

<p>UNION SELECT [r2] AS [Option] FROM [ExerciseTable] WHERE ([Question] = @Question) UNION </p>

<p>SELECT [r3] AS [Option] FROM [ExerciseTable] WHERE ([Question] = @Question AND </p>

<p>[r3]!=null))t Order by Newid()"</p>
