ช่วยดูcode ดึงdatabase มาใส่ในdropdownlist เพื่อEdit ให้หน่อยค่ะ

<form id="form1" runat="server">
    <div>    
        <asp:ObjectDataSource ID="EmployeeObjectDataSource" runat="server" 
            DataObjectTypeName="ThaiCreate.Entties.Employee" 
            OldValuesParameterFormatString="original_{0}" 
            onupdating="EmployeeObjectDataSource_Updating" 
            SelectMethod="GetEmployeeByEmployeeId" 
            TypeName="ThaiCreate.Data.EmployeeRepository" UpdateMethod="Update">
            <SelectParameters>
                <asp:QueryStringParameter DefaultValue="430001" Name="id" 
                    QueryStringField="EmployeeID" Type="String" />
            </SelectParameters>
        </asp:ObjectDataSource>
        <asp:ObjectDataSource ID="ChangedPositionObjectDataSource" runat="server" 
            OldValuesParameterFormatString="original_{0}" 
            SelectMethod="GetAllPosition" 
            TypeName="ThaiCreate.Data.PositionRepository">
        </asp:ObjectDataSource>
    
        <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" 
            DataSourceID="EmployeeObjectDataSource" Height="50px" 
            ondatabound="DetailsView1_DataBound" Width="300px" CellPadding="4" 
            ForeColor="#333333" GridLines="None">
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <CommandRowStyle BackColor="#E2DED6" Font-Bold="True" />
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <FieldHeaderStyle BackColor="#E9ECF1" Font-Bold="True" />
            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
            <Fields>
                <asp:BoundField DataField="EmployeeId" HeaderText="EmployeeId" ReadOnly="True" 
                    SortExpression="EmployeeId" />
                <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                <asp:TemplateField HeaderText="Position" SortExpression="Position">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                        &gt;<asp:DropDownList ID="DropDownList1" runat="server" 
                            AppendDataBoundItems="True" DataSourceID="ChangedPositionObjectDataSource" 
                            DataTextField="PositionName" DataValueField="PositionId" 
                            ondatabound="DropDownList1_DataBound">
                            <asp:ListItem>- Select -</asp:ListItem>
                        </asp:DropDownList>
                    </EditItemTemplate>
                    <InsertItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Position") %>'></asp:TextBox>
                    </InsertItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("Position") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:CommandField ShowEditButton="True" />
            </Fields>
            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <EditRowStyle BackColor="#999999" />
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
        </asp:DetailsView>    
    </div>
    </form>

public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void DetailsView1_DataBound(object sender, EventArgs e)
        {
           
            switch (DetailsView1.CurrentMode)
	        {
                case DetailsViewMode.ReadOnly:

                    break;
		        default:
                    Employee employee = DetailsView1.DataItem as Employee;
                    TextBox positionTextBox = DetailsView1.FindControl("TextBox1") as TextBox;
                    if (positionTextBox != null && employee.Position!=null)
                    {
                        positionTextBox.Text = employee.Position.PositionName;
                    }
                    break;
	        }             
        }

        protected void DropDownList1_DataBound(object sender, EventArgs e)
        {
            DropDownList d = sender as DropDownList;
            Employee employee = DetailsView1.DataItem as Employee;
            if (employee.Position != null)
            {
                d.SelectedValue = String.Format("{0}", employee.Position.PositionId);
            }
        }

        protected void EmployeeObjectDataSource_Updating(object sender, ObjectDataSourceMethodEventArgs e)
        {
            Employee employee = e.InputParameters["employee"] as Employee;
            DropDownList d = DetailsView1.FindControl("DropDownList1") as DropDownList;
            employee.Position = Position.CreatePosition(Int32.Parse(d.SelectedItem.Value), d.SelectedItem.Text);
        }      
    }