How should I set an asp.net label's text to some value in another control?

Question

I'd like to set the text of two labels to values found in a FormView on a page (whose data comes from an SQLDataSource.)

What's the best way to do this? I'm thinking of using the DataBound event for the FormView to set the label text to the value of a field in the FormView, or of using the SQLDataSource Selected event to set the labels to values retrieved by the query. Could I use the Page_Load event in conjunction with the FormView?

The FormView only displays one of the two values, though the other value is retrieved by the SQLDataSource.

I'm unfamiliar with accessing the data structures behind these controls but figure the data is there so I might as well use it rather than run the same SQL query twice.

My question then is which event do I use, which control do I access the data from, and how do I access the data from that control?

Answer 1

If you're just trying to set a label, just set the label at the Page_load event:

myLabel.Text = "someValue";

Answer 2

I'd use the OnDataBound event and get the value from the underlying datasource using:

lblExample.Text = ((DataRowView)((FormView)sender).DataItem)["fieldName"].ToString();

Hope it helps. // CeriQ

Answer 3

I am using CERIQ's answer, but am not having any luck. I converted the code to vb.net for my project and it looks like this:

   Protected Sub fvClients_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles fvClients.DataBound

    lblClientName.Text = (DirectCast((DirectCast(sender, FormView)).DataItem, DataRowView))("FirstName" + " " + "LastName").ToString()
End Sub

However, no dice. Am I doing something wrong? Also, please note my lbClientName control resides outside of the formview, could this be the issue?

Please help!