Hi,

Have an SqlDataAdapter to query a table. To pull records with certain agentid, "Where AgentID=@AgentID" worked just fine.

How can I use the same query to pull either records for a certain agentid, or ALL agent records? i.e., optional parameter?

Thanks,
Xiaodong