Using variables in the aspx file
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.