Bound Grid Column to External hyperlink

[Jim]

@(Html.Kendo().Grid<positions.Models.vOpenPositionsDistinct>()
.Name("gridMain")
.DataSource(dataSource => dataSource // Configure the grid data source
.Ajax() // Specify that ajax binding is used
.Read(read => read.Action("Positions_Read", "Home")) // Set the action method which will return the data in JSON format
)
.Columns(columns =>
{
columns.Bound(s => s.SourceURL).ClientTemplate("<a href='" + Url.Content("#= SourceURL #") + "' target='_blank'>#: SourceURL #</a>").HeaderTemplate("Source URL").Width(120);

})

I have external url links stored in my database and I want to bind them in a grid column as <a href> tag. If I use the code above all rows will have the 1st row SourceURL Value .

What am I doing wrong? It seems as if it creates a generic template for all rows and the template has same url.

[Dimiter Madjarov]

Hello Jim,


The sample code looks correct for displaying the unique URL for each Grid item. Could you please assure that the correct URLs are returned from the read action? If that is the case and the issue is still reproducing, please send me a small isolated project, which demonstrates it, so I could inspect it locally and assist further.

Regards,
Dimiter Madjarov
Telerik

 

 

[Jim]

Hi,

If I remove the ClientTemplate and only bind columns.Bound(s => s.SourceURL); I get the links the way they should be.
The links are from DB view vOpenPositions and the view returns the links the way they should be.

I have created a sample MSSQL Azure Database and a sample project here: https://www.dropbox.com/s/fvlwjq60bz20ijj/positions.zip

It should connect to the database straight way...

Thank you for your time!

[n/a]

Hi, Can youi please provide the full view code where you got a workin example?

[Dimiter Madjarov]

Hello Jim,


Thank you for providing the sample project. The Grid was unable to fetch the data and an exception "No connection could be made because the target machine actively refused it" was thrown.

Nevertheless after reviewing the Index view I was able to spot the reason for the issue. I assume that you are referring to the child Grid SourceURL column. When a client template is used in a child Grid, the hash symbols should be escaped. Otherwise the Grid will try to find the property in the parent model. Usually this will result in a "Property not found" error, but in the specific current case the parent model contains a property with the same name and just displays it in all rows. As as solution, I would suggest to use backslashes to escape the hash symbols in the child Grid.
E.g.

columns.Bound(s => s.SourceURL).ClientTemplate("<a href='" + Url.Content("\\#= SourceURL \\#") + "' target='_blank'>\\#= SourceURL \\#Link</a>")

I hope this information helps.

Regards,
Dimiter Madjarov
Telerik

 

 

[Jim]

I am sorry for the DB issue, maybe some FW rule...

Your help is greatly appreciated!! Thanks! It all works now.