I am populating a datagrid using the following query passed in the URL, but I want to search by 'keyword'
Instead of "Results.aspx?Country=england" I want "Results.aspx?keyword=england"

This is the string I am using created using the simple query builder on dreamweaver mx, can anyone tell me what part of the code I need to change?


CommandText='<%# "SELECT * FROM State WHERE Country LIKE ? " %>'

<Parameters>
<Parameter Name="@Country" Value='<%# IIf((Request.QueryString("Country" <> Nothing), Request.QueryString("Country", "" %>' Type="WChar" />
</Parameters>

Thank You