Database And .net Guys, Plz Assist

[Joe Spinebuster]

Alright, so I have a webpage and on that webpage I have a link that looks like this:

<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="product_page.aspx?Product_ID=1">Displ ay more info on item</asp:HyperLink>

On this page I place a GridView which is linked to display the contents of a database with a list of items.

What I want to do is place the link inside the last column of the GridView, and change it so the value after "Product_ID=" related to the "ProductID" column of my database. Ya dig?

I tried changing the ItemTemplate of the last column of the GridView to this:

<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="product_page.aspx?Product_ID='<%# Bind("ProductID") %>'">Display more info on item</asp:HyperLink>

BUT, apparently it's not as straightforwards as that. Hopefully this'll show what I'm trying to do, though. If you know what to do, explain clearly coz I am mad fuckin' new at this.

ANYONE...?

[Zooropa]

Few ways to do this mate:


<asp:TemplateField HeaderText="Edit">
<ItemTemplate>
<asp:HyperLink runat="server" ID="hlinkView1" Text='Select' NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.LETTER_ID", "./EditLetter.aspx?LETTER_ID={0}") %>'></asp:HyperLink>
</ItemTemplate>
</asp:TemplateField>

That's one way.

So here the container is the gridview, bound to a datasource.
So in the above example, I'm looking at the Dataitem called "LETTER_ID", that's the field name in the dataset.

So I'm guessing yours might be something like:

<asp:HyperLink ID="HyperLink1" runat="server"
NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.ProductID", "./product_page.aspx?Product_ID={0}") %>'




Another way to do it would be to add an event to the gridview "ondatabound".

Then loop through the gridview rows using a "for each", and manually set the HyperLink.NavigateURL property.

Any bother gies a shout.

[Joe Spinebuster]

Incredible, thanks a lot Marc. You may come to regret that last line in your post, coz I'm working on something and will no doubt get stumped like a motherfucker at pretty much every turn, but I'll TRY not to be a wideo since it's that wee bit more satisfying to figure things out myself. Although pasting in that HyperLink NavigateUrl magic of yours and seeing it actually work was still immensely satisfying. *KISSEZ U*

[Dyno]

Lev never Kissez me

[Joe Spinebuster]

Originally Posted by Dyno

Lev never Kissez me

Marc gives me assistance with things, and you - in the words of DMX - ain't never gave nothin' ta me! Except a Mars bar shaped void in my sweety collection.

Originally Posted by Joe Spinebuster

I'll TRY not to be a wideo

Pure liar, got stuck again already. MY NEW PROBLEM IS THIS:

I have a button click event that stores a number of session variables, like so:

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Session("No_Item") = Session("No_Item") + 1
Label1.Text = Session("No_Item")
Session("Item_Name") = "Golden Sword"
Label2.Text = Session("Item_Name")
Session("Total_Item") = Session("Total_Item") + 1500
Label3.Text = FormatNumber(Session("Total_Item"), 2)
Session("TOTAL_BASKET") = Session("Total_Item")
BASKET.Text = FormatNumber(Session("TOTAL_BASKET"), 2)
End Sub

THING IS, I want the value of the session variable "Item_Name" to actually be retrieved from a label named "ProductNameLabel" on my page, and I want the value of the session variable "Total_Item" to be Total_Item + a value retrieved from a label named "UnitPriceLabel". I thought I would be able to do this like so:

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Session("No_Item") = Session("No_Item") + 1
Label1.Text = Session("No_Item")
Session("Item_Name") = CStr(ProductNameLabel.text)
Label2.Text = Session("Item_Name")
Session("Total_Item") = Session("Total_Item") + CInt(UnitPriceLabel.text)
Label3.Text = FormatNumber(Session("Total_Item"), 2)
Session("TOTAL_BASKET") = Session("Total_Item")
BASKET.Text = FormatNumber(Session("TOTAL_BASKET"), 2)
End Sub

But, as usual, my logic does not apply and the bits in bold are throwing up errors because the labels they refer to are in a DataList and the button click event can't see them because of this.

Is there a way to make my button click event read the values of labels inside a DataList, and store them as session variables?
It would also be nice if I could make the session variable name "No_Item" relative to a label - eg it reads a label with the value "1" and makes the session variable name "No_Item_1", reads a label with the value "2" and makes the session variable name "No_Item_2", etc., but I think I may be attempting the impossible with that. Actually, for all I know it could be the easiest thing in the world, I really am horribly new at this.

For anyone trying to read the code and figure out what I'm up to - yes, I AM testing out this stuff by pretending to be a shopkeeper from a Zelda game setting up an online store.

[Zooropa]

Ah, a datalist.

Where does the button sit? Does it sit next to each item on the datalist, or is sitting at the bottom of the page so that you maybe select something in the datalist, and the button at the bottom does something with the selected item?

For controls like textboxes/labels and that sitting inside a container (datalist/grdiview/datagrid/formview) you need to use findcontrol.

So might be something like:

Dim ADDRESS_IDLabel As Label = Me.DataList1.Items(0).FindControl("ADDRESS_IDLabel ")
Dim textADDRESS_IDLabel As String = ADDRESS_IDLabel.Text

You can see I did DataList.Items there.
items are basically the rows that make up the content of the datalist.
The 0 is the index of the datalist, so the first one it finds.

If you get stuck post up a rough idea of what the page should be doing and should be able to help you out.