Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Finding datakey in datalist during item_databound event

Posted on 2008-11-02
6
4,187 Views
Last Modified: 2012-08-13
Hi,

I'm trying to get hold of the datakey value of each row in a datalist control. This is the code I'm using:

    Protected Sub dtSmartMenu_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataListItemEventArgs) Handles dtSmartMenu.ItemDataBound
        Dim HyperLink1 As HyperLink = e.Item.FindControl("HyperLink1")
        Dim smartMenuID As Integer = dtSmartMenu.DataKeys(e.Item.ItemIndex)("smartMenuID")
   
           End Sub

---------------------------------------------
That doesn't work though. Can anyone help me to get hold of that value?!

Thanks for help!

Peter
0
Comment
Question by:peternordberg
  • 3
  • 2
6 Comments
 
LVL 11

Expert Comment

by:Salim Fayad
ID: 22862969
You have to get its "Value"

dtSmartMenu.DataKeys(e.Item.ItemIndex).Value

Open in new window

0
 

Author Comment

by:peternordberg
ID: 22863753
Hi, and thanks for answer!

How can I get that value to be assigned to an integer variable? It complains that it can't find the public member for the type Value for integer.

Peter
0
 
LVL 11

Expert Comment

by:Salim Fayad
ID: 22867446
Here is how you convert it to int

CInt(dtSmartMenu.DataKeys(e.Item.ItemIndex).Value)

Open in new window

0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 

Author Comment

by:peternordberg
ID: 22868102
Hi and thatnks for your help!
Yes, I've already tried that, still I get an error that says>
--------------------------
"Missing Member exeption unhandled by user code"
"Couldn't find the public member Vakue for the type Integer."
---------------------------------
This is the code I'm using

Dim smartMenuID As Integer = CInt(dtSmartMenu.DataKeys(e.Item.ItemIndex).Value)
Thanks for help!
 
Peter
0
 
LVL 22

Accepted Solution

by:
prairiedog earned 500 total points
ID: 22868317
Hi peternordberg:
1. DataList is diffrent from GridView as far as DataKeys is concerned. Here is the right syntax for retrieving DataKey value from DataList:
Dim smartMenuID As Integer = CInt(dtSmartMenu.DataKeys.Item.(e.Item.ItemIndex).ToString())   'although without CInt the above will still work because VB.NET will do the conversion for you, it is always a good idea to use explicilty conversion.
2. Header row and Footer row will also considered "Item", and the above code will throw exception error when it is a header row or a footer row. So you need to wrap your code with a row type check like this:

If (e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem) Then
   Dim HyperLink1 As HyperLink = e.Item.FindControl("HyperLink1")
   Dim smartMenuID As Integer = Me.dtSmartMenu.DataKeys.Item(e.Item.ItemIndex)
End If
 
0
 

Author Closing Comment

by:peternordberg
ID: 31512524
Thanks! That worked perfectly!

Peter
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have developed many web applications with asp & asp.net and to add and use a dropdownlist was always a very simple task, but with the new asp.net, setting the value is a bit tricky and its not similar to the old traditional method. So in this a…
ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question