I am very new to asp.net and vb so please bare with me. I used the datagrid tool and typed in an SQL query to populate the grid with. The issue is that this is a dynamic page, so the query needs to contain a variable. I went into the source of the aspx file and found:
SelectCommand
="SELECT table..... etc

I need to add a variable to the where statement but I can't figure out how to do it. if i were in the aspx.vb file, i would just use " & variable & " but that doesn't seem to work in the aspx file

any help would be appreciated.