>Try :
>String strSelect = "SELECT ins1ln, ins1fn, pxd FROM Policy WHERE agent = '"+ MyAgent + "'" ;
You just have to be careful that you don't expose your application to SQL Injection attacks. You really have to understand the source of MyAgent.
-Mike
>
>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