Binding a DropDownList with CodeBehine

[WorkerBeeJ]

I have an aspropDownList contained in an asp:table and I'm trying to populate it with items contained in a dataset. Here's the control:

<asp:TableCell Wrap=&quot;False&quot;><aspropDownList id=&quot;lstBusinessUnit&quot; runat=&quot;server&quot; DataValueField=&quot;BusinessUnitID&quot; DataTextField=&quot;BusinessUnitInfo&quot; Width=&quot;100&quot; ></aspropDownList></asp:TableCell>

And here's the codebehind where I'm trying to populate the DropDownList:

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
CheckValidSession()
Dim dsBusinessUnits As DataSet
With New BusinessUnitBus()
dsBusinessUnits = .GetActiveBusinessUnits()
End With
lstBusinessUnits.DataSource = dsBusinessUnits '**line 31
lstBusinessUnits.DataBind()
End Sub

I'm getting a NullReferenceException on line 31. Can anyone tell me where I'm going wrong? (Or let me know what else I should post?)

thanks!

 

[xloop]

Can you post the code for GetActiveBusinessUnits()

cheers

 

[WorkerBeeJ]

Problem solved. Here's the solution in case anyone's interested:

<aspropDownList id=&quot;lstBusinessUnit&quot; runat=&quot;server&quot; DataValueField=&quot;BusinessUnitID&quot; DataTextField=&quot;BusinessUnitInfo&quot; DataSource=<%# BusinessUnits %> ></aspropDownList>

And here's the (partial) codebehind:
Private dsBusinessUnit As DataSet

...
If Not Page.IsPostBack Then
GetBusinessUnits()
End If
...

Public Sub GetBusinessUnits()
With New BusinessUnitBus()
dsBusinessUnit = .GetActiveBusinessUnits()
End With
End Sub

Public ReadOnly Property BusinessUnits() As DataSet
Get
Return dsBusinessUnit
End Get
End Property