Solved

Finding datakey in datalist during item_databound event

Posted on 2008-11-02
6
4,273 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
[X]
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
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

I recently went through the process of creating a Calendar Control of events with the basis of using a database to keep track of the dates that are selectable, one requirement was to have the selected date pop-up in a simple lightbox.  At first this…
In .NET 2.0, Microsoft introduced the Web Site.  This was the default way to create a web Project in Visual Studio 2005.  In Visual Studio 2008, the Web Application has been restored as the default web Project in Visual Studio/.NET 3.x The Web Si…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

717 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