Intersoft Community - WebGrid Enterprise - WebGrid - Compare cell values in two grids on same page

WebGrid - Compare cell values in two grids on same page

JNguimb — Mon, 27 Jun 2011 00:51:32 GMT

Works great.

Thank you.
Jean

WebGrid - Compare cell values in two grids on same page

Riendy — Sun, 26 Jun 2011 23:31:27 GMT

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

WebGrid - Compare cell values in two grids on same page

JNguimb — Fri, 24 Jun 2011 02:08:17 GMT

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

WebGrid - Compare cell values in two grids on same page

Riendy — Wed, 22 Jun 2011 02:31:40 GMT

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

WebGrid - Compare cell values in two grids on same page

JNguimb — Tue, 21 Jun 2011 14:36:35 GMT

Hello:

I have two grids (WebGrid1 and WebGrid2) on the same page (see attached image). The two grids are located in WebPaneManager1.

I need help with the following:

On initialize, I would like all the rows in WebGrid1 to be hidden immediately where the value/text of TaskID and UserID is the same in both grids.

A sample code would be much appreciated.

Regards

Jean