?
Solved

Finding datakey in datalist during item_databound event

Posted on 2008-11-02
6
Medium Priority
?
4,464 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
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 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

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…
A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Suggested Courses

621 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