@{
    var db = Database.Open("WebPagesMovies") ;
    var selectCommand = "SELECT * FROM Movies";
    var item = "";
    var search = "";

    if(!Request.QueryString["searchTitle"].IsEmpty() ) {
        selectCommand = "SELECT * FROM Movies WHERE @0 LIKE @1";
        item = Request.QueryString["item"];
        search = "%" + Request["search"] + "%";
    }

    var selectedData = db.Query(selectCommand, item, search); // **NOT WORKING**
    var grid = new WebGrid(source: selectedData, defaultSort: "Genre", rowsPerPage:3);
}

@{
    var db = Database.Open("WebPagesMovies") ;
    var selectCommand = "SELECT * FROM Movies";
    var search = "";

    if(!Request.QueryString["searchTitle"].IsEmpty() ) {
        selectCommand = "SELECT * FROM Movies WHERE Title LIKE @1";
        item = Request.QueryString["item"];
        search = "%" + Request["search"] + "%";
    }

    var selectedData = db.Query(selectCommand, item, search);
    var grid = new WebGrid(source: selectedData, defaultSort: "Genre", rowsPerPage:3);
}