You need to configure the ObjectDataSource control to pass the value of the pid field to GetProductsByProductId method