How to create HyperLink column based on the values of multiple columns?
To create HyperLink column based on multiple column values, the record should be accessed first and then the column values should be accessed from that record. These values are being used as the parameters for the HyperLink. Please refer the below code snippet which illustrates this:
C#
protected string GetProductHyperLink(GridCell container)
{
Record rowRecord = container.Row.Record;
object Notes = rowRecord.GetValue("first Column name").ToString();
object stockName = rowRecord.GetValue("second Column Name").ToString();
return "http://finance.yahoo.com/q/bc?s=" + stockName.ToString()+"N="+Notes.ToString();
}
VB
Protected Function GetChartHyperLink(ByVal container As GridCell) As String
Dim rowRecord As Record = container.Row.Record
Dim Notes = rowRecord.GetValue("Notes").ToString()
Dim stockName = rowRecord.GetValue("StockName").ToString()
Return "http://finance.yahoo.com/q/bc?s=" & stockName & "N=" & Notes
End Function
In the above snippet,
- Each record is accessed by container.Row.Record.
- The value of each column is accessed by the GetValue method in which the name of column has to be mentioned.
Sample:
https://help.syncfusion.com/support/samples/kb/Grid.Web/6.1.0.34/GGCHyperlink/GGC_Hyperlink.zip