• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1530
  • Last Modified:

How can I access the values of ObjectDataSource from Code-Behind?

I placed an ObjectDataSource in my asp.net page (VB.NET) that is bound to a a FormView.  For a simple project this works fine as I use Conainter.DataItem to display the value in a label such as:

<asp:Label ID="lblName" runat="server" Text='<%# Container.DataItem.ProductName %>'></asp:Label>

My question now is - how to I access all the values returned from the ObjectDataSource's SelectMethod from Code-Behind.  There are many reasons why I may want to do this such as conditional formatting, setting variables, cookies, session variables, hiding/displaying panels on the page, etc.

Please let me know how this can be done properly.

Thank you.
<asp:Label ID="lblName" runat="server" Text='<%# Container.DataItem.ProductName %>'></asp:Label>

Open in new window

1 Solution
If you want to do things inside the FormView after the data is bound, use the FormView's DataBound event and reference it's DataItem object after casting to the appropriate type.
<asp:FormView ID="FormView1" runat="server" DataSourceID="ObjectDataSource1" OnDataBound="FormView1_DataBound">
Protected Sub FormView1_DataBound(sender As Object, e As EventArgs)
	' Get the data item after type casting it appropriately.
	' * Cast to DataRowView if using a DataSet or DataTable.
	Dim Data As Product = TryCast(FormView1.DataItem, Product)
	If Not (Data Is Nothing) Then
		' Change the product name label's style depending on if the product is active or not.
		Dim lblName As Label = DirectCast(FormView1.FindControl("lblName"), Label)
		Dim IsActive As Boolean = Data.IsActive
		If IsActive Then
			lblName.CssClass = "ActiveProduct"
			lblName.CssClass = "InactiveProduct"
		End If
	End If
End Sub

Open in new window

blueswitchAuthor Commented:
Works like a charm.  Thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now