Hello,

I higly recomend you to consult the docs before posting.

You will find a lot of solutions.

jqGrid has nothing to do with your problems.

Regards

P.S. The solution is very simple if there is no CollectionID value return a empty record set.