[RESOLVED] Want to create NavigateUrl string in my code

[MMock]

I'll make this short and sweet: I want to generate the NavigateUrl string for a hyperlink in my code, because I create the HyperLink column in my code. So I want to do something like this:

                Dim hyFactor As HyperLink = DirectCast(Me.gvL.Rows(i).FindControl("hyFactor"), HyperLink)
                hyFactor.Text = sFactor
                hyFactor.NavigateUrl = "Edit_Loss.asp"

sFactor came from a database call I just made.

And that works. The trouble is I want to pass to Edit_Loss.asp two parameters whose values depend on the current row in the grid. So it would look something like:

Edit_Loss.asp?param1={0}&param2={1}, but in vb how do I tell it where to get 0 and 1 from? Is this doable?

Thanks.

[MMock]

Alternatively, when my asp file does a request("param1") what are my choices, in my aspx file that call the asp file, of ways to give it a param1? In other words, what is the source that the request() goes to to get the value it's looking for?

Thanks.

[mendhak]

You have "i" which is the row in your gridview you're dealing with. Using i, you can also query the datasource of the gridview. Cast the grid's source to dataset, or dataview or datatable or whatever it allows. Once you have that, you have the 'collection'. You can then use i to get the specific property you want, for example

DataSet.Tables(0).Rows(i).Item("field1").ToString() and DataSet.Tables(0).Rows(i).Item("field9").ToString()

[MMock]

Thank you, mendhak.

I think I was making more of it that it was, and it's really just a string operation. So I am doing it like this:

            For i As Integer = 0 To Me.gv.Rows.Count - 1
                Dim labelAbbrev As Label = DirectCast(Me.gv.Rows(i).FindControl("lblAbbrev"), Label)

                GetData(labelAbbrev.Text, sIk, sTax, sFromDate, sToDate, sUpDate)

                Dim hyTax As HyperLink = DirectCast(Me.gv.Rows(i).FindControl("hyTax"), HyperLink)
                hyTax.Text = sTax
                hyTax.NavigateUrl = "Edit_Tax.asp?tax_ik=" + sIk + "&ldc_abbr=" + labelAbbrev.Text

Next

[mendhak]

Dim hyTax As HyperLink = DirectCast(Me.gv.Rows(i).FindControl("hyTax"), HyperLink)

Woohoo!!