Hi Jean,

To Hide all rows which have a simillar value/text of TaskID and UserID in both grids (WebGrid1 and WebGrid2), you have to validate the rows in WebGrid1 on InitializeRow Event after you set both of the WEbGrid's DataSource. For your information, there's no need to change the WebGrid's code (server side) whether the Webgrid located inside or outside WebPaneManager. 

Attached is my simple runable sample. Please describe me more detail if my sample is different with your scenario.

Thank you.
Riendy

Hello Riendy,

Thank you.  Your sample worked based on the explanation I gave you. Unfortunately, I gave you incomplete information. So this solution solved only half of the problem.  I have attached a new simple so that you can see what I am trying to do.

Basically, I need to select and retrieve records into Table 2 based on criteria in textbox and dropdown list, and simultaneously hide (or not retrieve) all rows in Table 1 that have the same TaskID and Subject as rows in Table 2.

Could you please adjust the attached sample to help me to achieve this scenario?

Regards

Jean

Hi Jean,

I have modified your sample. In your sample, WebGrid1 doesn't get data programmatically, so I added RetreiveStructure method in WebGrid1 PrepareDataBinding Event. Then I added validation to hide columns which are have a same TaskID and Subject value in WebGrid2 in WebGrid1 InitializeRow Event. Last, I added WebGrid1 Refresh method when GetRecords button clicked.

Note: I delete "User Instance=True" in all connection string to run your sample here.

Could you please let me know is my modified runs as like as your expectation ?

Regards,
Riendy