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
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Blocked AccountPosted Jan 29, 2008, 1:52 AM
U can do this by adding the control parameter.
selectcommand="select field1,field2 from table where field in(@intvariablename)"
Happy Coding!!