Problems with variables in the sqldatasource data source.

brightmoon

In the sqldatasource data source control, SelectCommand = "SELECT * FROM [test] where field 1 =" <% # getno ()%> ""

I tracked the value of getno () and got it normally. But why doesn't the query result work? Simply replace #getno ()%> with the resulting character.

Thank you!

sabs_nn

If this selectcommand has parameters, remove it

brightmoon

Remove it
==============
then what should we do?

iceice930

Assign values ​​to SelectCommand in the code behind, don't use a mixed method in the foreground, this is easy to go wrong.