General question how to set control.visible in listView and calculate column in sql

[Paul]

Any help with this problem would be appreciated (it isn't really Telerik specific)

I have a RadListView with an sqlDataSource. I have two problems. First I want to calculate a column in the sqldatasource. I have a table with a column called Owner and want to create a bool which indicates whether the present user is the owner of that record. ie

Select *, (Owner=@User) as mine where....

But this doesn't work so how can you calculate a columnwithin a select statement?

Second problem which is more related to the Rad control is that I am using an itemTemplate in the listView and would like to have a button within that template where I control the "visible" based on the value of the calculated column ("mine"). I have tried

Visible='<%#Eval("mine")%>'

but get a cast error (to avoid the first problem I have just calculated mine as 'true' in the datasource).

[Iana Tsolova]

Hi Paul,

I suggest that you handle the RadListView ItemDataBound event. There for the current item bound you can see if its Owner is equal to the logged user and based on that implement your logic.

Regarding the second question: You can again use the ItemDataBound event as mentioned above.

For more information on accessing the controls in a RadListView, check the below article:
http://www.telerik.com/help/aspnet-ajax/accessing-controls-in-radlistview.html

Regards,
Iana
the Telerik team