I have a grid on a web form and I am trying to populated it with the following Select statement:

MyAgent = Session["ProducerCode"].ToString();
String strSelect = "SELECT ins1ln, ins1fn, pxd FROM Policy WHERE agent = MyAgent" ;


The problem is that my Where clause does not recognize the variable MyAgent.

Can anybody help me to populate the Where clause with a Session variable.

I am using C#.

Thanks,
Sergio