For display reasons I've been forced to populate a datatable with the results of a sproc instead of going straight to the datagrid (I'm building a semi-pivot table with results that aren't normally part of a pivot table). Anyways, for the life of me I cannot get the EditURL working for the hyperlink column I've created. Has anyone done a hyperlinkcolumn in the background in DNN before and can tell me where I'm messing up?
Dim
linkColumn As New HyperLinkColumn
linkColumn.DataNavigateUrlField = "UserID"
linkColumn.NavigateUrl = EditUrl("UserID", "{0}", "EditDriver") <---- THis is the once that's come the closest to working. The URL is formatted wrong but it's at least return the correct UserID.
'linkColumn.NavigateUrl = String.format((EditUrl("DivisionID", DataBinder.Eval(Container.DataItem, "DivisionID").ToString, "EditDivision")), "") <--- I saw some examples on the web that used it this way but I get an error on DataBinder and Container even after I've added Imports System.Web.UI.DataBinder.
linkColumn.Visible = IsEditable
linkColumn.Text = "Edit"
dgDrivers.Columns.Add(linkColumn)