ASP.NET

Function GetStatus() as DataSet 

	
	Dim DBConn as OleDbConnection
	Dim DBCommand as OleDbDataAdapter
	
			
	DBConn = New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("data/Auto_log.mdb") & ";")
	DBCommand = New OleDbDataAdapter("SELECT StatusID, Status from Status ORDER BY Status", DBConn)


	DBCommand.Fill(DS, "Status")
	DBConn.Close()
	
    Return DS
			
	
End Function

    Function GetSelectedIndex(ByVal StatusID As String) As Integer
        'Loop through the DataSet DS
        Dim iLoop As Integer
        Dim DT As DataTable = DS.Tables("Status")
        For iLoop = 0 To DT.Rows.Count - 1
            If StatusID = DT.Rows(iLoop)("StatusID").ToString Then
                Return iLoop
            End If
        Next iLoop
    End Function

Dim ddlStatus As DropDownList = FindControl("ddlStatusctrl")

<asp:TemplateColumn>
	<HeaderTemplate>
	Status		
	</HeaderTemplate>
	<ItemTemplate>
	<%# Container.DataItem("Status") %>
	</ItemTemplate>
	<EditItemTemplate>
	<asp:DropDownList id="ddlStatusctrl" runat="server"
	DataTextField="Status"
	DataValueField="StatusID"
	DataSource="<%#	GetStatus() %>"   
	SelectedIndex='<%# GetSelectedIndex(Container.DataItem("StatusID")) %>' />
	</EditItemTemplate>
</asp:TemplateColumn>