To cut a long story short:

this: "SELECT * FROM Products" is my defalt select command of SqlDataSource1.

I write code like this: SqlDataSource1.SelectCommand = "SELECT ItemID FROM Products";

It really works, but only until page's refreshed.

So, what can I do to make the change of a select command constant?



, thanks.

I'm having the same problem. Please let me know if you find a solution.

Thanks

Q1) Is it in the load event of the page?
Q2) VB of C#
Q3) Can you show the code around it please?

hi fewer,
have you found the solution to the following problem that you faced?
i am also having the same problem. any help would be greatly appreciated.

ok people this ishowit works.
first solution is, change the string in the page load event.
if you change it there the last string is the string used by the compiler.
you can also make a change to the code by event handling.
if you navigatefrom site to site use session variables to maintain current strings.

Ivan