C# :: Populating GridView With SQL Query

I have two tables

Orders
ID, CreatedDate,CustomerID
1, 03/04/2014, test

OrderDetails
ID,ProductId, ProductName,Quantity,Price,Total
1, 5, Toy, 5, 1.99, 9.95

I have a gridview, im using its 'datasource dropdownlist' to populate it, i have the SQL statement

SELECT Orders.ID, OrderDetails.ProductId, OrderDetails.ProductName, OrderDetails.Quantity, OrderDetails.Price, OrderDetails.Total FROM (OrderDetails INNER JOIN Orders ON OrderDetails.ID = Orders.ID) WHERE (Orders.CustomerId = ?)

where the '?' is parameters source = QueryString, and QueryStringField= email

i have a session that is the customerEmailId, so

string CustomerEmailID = (string)Session["email"];
Response.Redirect("MyAccount.aspx?email=" + CustomerEmailID);//i have tested it and customerEmailid is test
however nothing loads in the GridView