Suppress Repeater or Datagrid Output

[arielken]

Is it possible to suppress a row of output? I'm thinking somewhere in teeh ItemCreated event but not sure how to do it.

Basically the repeater is bound to a dataset but I have to look up values in another database which determines whether or not this row should be displayed.

 

[crazyboybert]

Hi arielken

I'm not sure if you can suppress the row on a databind but you should be able to do this using a filter on a DataView. The links below cover DataViews and filtering data.

http://authors.aspalliance.com/wisemonk/view.aspx?id=AD032102

http://samples.gotdotnet.com/quickstart/howto/doc/adoplus\FilterData.aspx

hth

Rob



Go placidly amidst the noise and haste, and remember what peace there may be in silence - Erhmann 1927

 

[arielken]

Thanks but that's not really where the problem is. As each row is processed I need to lookup values in a completely separate database to determine whether or not it should be displayed. It would be easy if they were in the same database but one is an oracle database on a Unix server and the other an access database on a windows machine.

 

[crazyboybert]

Oh nasty! This still should be possible by populating the same dataset with multiple datatables from the two databases. And then programatically filter the data into a third datatable before performing the bind.

Here is link to populate dataset from multiple data adaptors on msdn...

msdn.microsoft.com/library/en-us/cpguide/html/ cpconpopulatingdatasetfromdataadapter.asp

Rob



Go placidly amidst the noise and haste, and remember what peace there may be in silence - Erhmann 1927