sqldatasource selectcommand string

Question

How can we write sqldatasource selectcommand string  based on a variable from the codebehind.

selectcommand="select field1,field2 from table where field="+<%=intvariablename%>

here i am getting some syntax error...

its very urgent