Substitue ItemArray with something else in a FormView

[staeri]

When loading a FormView I try to fill a third-party combo control with
this code:

Protected Sub FormView1_ItemCreated(ByVal sender As Object, ByVal e As
EventArgs)

If FormView1.Row.RowState = DataControlRowState.Edit Then
Dim rowView As DataRowView = TryCast(FormView1.DataItem,
DataRowView)
If Not rowView Is Nothing Then
'Get and fill cboProject
Dim strProjectID As String =
TryCast(rowView.Row.ItemArray(8), String)
Dim cboProject As WebCombo =
TryCast(FormView1.FindControl("cboProject"), WebCombo)
cboProject.Value = strProjectID
End If
End If

End Sub

It works great except that I would like to change
"TryCast(rowView.Row.ItemArray(8), String)" and use the column name
instead of ItemArray(8). I have many columns in the FormView so it's
very difficult for me to guess which number represents a certain
column.

How can this be done?

I'm very grateful for help!

// S

 

[Milosz Skalecki [MCAD]]

Hi there,

First of all it's better to move databound-releated code to DataBound event
handler. Second you can access column by names directly from DataRowView:

protected Sub FormView1_DataBound( _
ByVal sender As Object, _
ByVal e As EventArgs)

dim formView as FormView = DirectCast(sender, FormView)

if formView.CurrentMode = FormViewMode.Edit then

Dim rowView As DataRowView = TryCast( _
formView.DataItem, DataRowView)
Dim cboProject as WebCombo = TryCast( _
formView.FindControl("cboProject"), WebControl)

cboProject.Value = Convert.ToString(rowView("ColumnName"))

end if

end sub

Hope this helps