manually hyperlink datagrid column

[son]

hi help please..

i have a datagrid which i did manually in my aspx.vb file i would like that the datafield's in the first column becomes a hyperlink to another page...

can anyone help me out cause me really stuck... thanks in advance sonia..

 

[kahlua001]

Either use a HyperlinkColumn or a TemplateColumn

 

[son]

hi me getting confused.. i am programmatically doing the datagrid
my code is as follows:

Protected WithEvents dynamicDataGrid As System.Web.UI.WebControls.DataGrid
Protected WithEvents report As System.Web.UI.HtmlControls.HtmlGenericControl




Sub DisplayTable(ByVal myDataSet As DataSet)



dynamicDataGrid = New DataGrid()

dynamicDataGrid.CssClass = "reportText"
dynamicDataGrid.CellPadding = 0
dynamicDataGrid.CellSpacing = 0

dynamicDataGrid.BorderStyle = BorderStyle.None
dynamicDataGrid.GridLines = GridLines.None
dynamicDataGrid.HeaderStyle.CssClass = "reportTextHeader"
dynamicDataGrid.FooterStyle.CssClass = "reportTextFooter"
dynamicDataGrid.ShowFooter = True
dynamicDataGrid.AutoGenerateColumns = False



Dim myDataGridCol As New BoundColumn()

myDataGridCol.HeaderStyle.Width = Unit.Percentage(0)
myDataGridCol.ItemStyle.CssClass = "reportTextBorderLeft"
dynamicDataGrid.Columns.Add(myDataGridCol)



myDataGridCol = New BoundColumn()
myDataGridCol.HeaderText = "Vehicle"
myDataGridCol.HeaderStyle.CssClass = "col1"
myDataGridCol.DataField = "Vehicle"
dynamicDataGrid.Columns.Add(myDataGridCol)


report.Controls.Add(dynamicDataGrid)
dynamicDataGrid.DataSource = myDataSet
dynamicDataGrid.DataBind()

end sub

i am getting an error that since i am bounding a column i can not add a hyperlink... could u help me please i would really appreciate it... thanks in advance

 

[kahlua001]

Instead of Dim myDataGridCol As New BoundColumn()

use..

Dim myDataGridCol As New HyperlinkColumn()

myDataGridCol.DataNavigateUrlField="WidgetID"
myDataGridCol.DataNavigateUrlFormatString="details.aspx?WidgetID={0}"

 

[son]

hi i tried what u have told me but still it is not working.. what i forgot to mention before regarding my code and i am really sorry about this ..its just that its getting really frustrating and i hate feeling like this but anyways... i forgot to add this code because i have more than one column and they need to be binded because the display table sub has a parameter as a dataset which is an sql statement retrieving date from tables from sql sever 2000.. the complete code i am using is as follows.. once again thanks in advance...



Protected WithEvents dynamicDataGrid As System.Web.UI.WebControls.DataGrid
Protected WithEvents report As System.Web.UI.HtmlControls.HtmlGenericControl




Sub DisplayTable(ByVal myDataSet As DataSet)



dynamicDataGrid = New DataGrid()

dynamicDataGrid.CssClass = "reportText"
dynamicDataGrid.CellPadding = 0
dynamicDataGrid.CellSpacing = 0

dynamicDataGrid.BorderStyle = BorderStyle.None
dynamicDataGrid.GridLines = GridLines.None
dynamicDataGrid.HeaderStyle.CssClass = "reportTextHeader"
dynamicDataGrid.FooterStyle.CssClass = "reportTextFooter"
dynamicDataGrid.ShowFooter = True
dynamicDataGrid.AutoGenerateColumns = False



Dim myDataGridCol As New BoundColumn()

myDataGridCol.HeaderStyle.Width = Unit.Percentage(0)
myDataGridCol.ItemStyle.CssClass = "reportTextBorderLeft"
dynamicDataGrid.Columns.Add(myDataGridCol)



myDataGridCol = New BoundColumn()
myDataGridCol.HeaderText = "Vehicle"
myDataGridCol.HeaderStyle.CssClass = "col1"
myDataGridCol.DataField = "Vehicle"
dynamicDataGrid.Columns.Add(myDataGridCol)

myDataGridCol = New BoundColumn()
myDataGridCol.HeaderText = "Distance"
myDataGridCol.HeaderStyle.CssClass = "col2"
myDataGridCol.DataField = "Distance"
dynamicDataGrid.Columns.Add(myDataGridCol)

myDataGridCol = New BoundColumn()
myDataGridCol.HeaderText = "Fuel Used"
myDataGridCol.HeaderStyle.CssClass = "col3"
myDataGridCol.DataField = "Fuel_Used"
dynamicDataGrid.Columns.Add(myDataGridCol)

myDataGridCol = New BoundColumn()
myDataGridCol.HeaderText = "Consumption Rate"
myDataGridCol.HeaderStyle.CssClass = "col4"
myDataGridCol.DataField = "Consumption_Rate"
dynamicDataGrid.Columns.Add(myDataGridCol)

myDataGridCol = New BoundColumn()
myDataGridCol.HeaderStyle.CssClass = "col5"
myDataGridCol.ItemStyle.CssClass = "reportTextBorderLeft"
dynamicDataGrid.Columns.Add(myDataGridCol)


report.Controls.Add(dynamicDataGrid)
dynamicDataGrid.DataSource = myDataSet
dynamicDataGrid.DataBind()

End Sub

 

[kahlua001]

When you say the code i supplied is not working, can you be more specific? is there an error message? Can you post the exact code you were trying...

 

[son]

ah sorry about that.. my report is running but nothing is showing up in the column where i need the hyperlink fields to show... the other datafields are being binded and data is being showed but the first column which is suppose to have the datafield hyperlinks is not..

 

[kahlua001]

Check to see if you have the correct datafield. That is my guess without seeing code.

 

[son]

ah ok will do so.. thanks.. me will leave it for now.. cause i have been on it for quite sometime now.. thanks..