Refresh query on every post back

[Arash Katchooi]

Hi

I am developing a web page using ASP 2.0 with C# backend.
I created a query that shows random report from a database
and i want it to show different value for every post back .
how can i refresh query for each post back?

i appreciate any advise.

[kunal pawar]

Can post ur query here and please explain more

[Arash Katchooi]

SELECT Runingtotal.Ran k, Runingtotal.Sal e_Percent, Runingtotal.SKU AS Expr1
FROM Runingtotal
WHERE (((Runingtotal. Sale_Percent)<0 .5))
ORDER BY Rnd(Runingtotal .Rank);

as you see it is sorted by random and i need it to be shown differently on every post back

Thanks for respond