Try :
String strSelect = "SELECT ins1ln, ins1fn, pxd FROM Policy WHERE agent = '"+ MyAgent + "'" ;
You need to put single quotes in the string for SQL, you also need to ADD the value to the string.
>Have you tried parameterizing your query and specifying a value with a Parameter?
>
>-Mike
>
>>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