problem with edit data

I have one big trouble in write aspx. I 'm writing a page for user edit database, i used datagrid with Editing Capability. My database structure:

CountyID Name
1 Adfsdf
2 Sdfvdf
3 Escvc
4 Dsdfn

DistrictID Name CountyID
1 Dist 1 1
2 Dist 2 2
3 Dist 3 3

My page for user change data in District table. I had write:

<asp:datagrid ID="objDataGird" runat="server" HeaderStyle-Font-Bold="true" AutoGenerateColumns="false" AllowPaging="true" PageSize="4" PagerStyle-HorizontalAlign="center" OnPageIndexChanged="doPaging" PagerStyle-Mode="NumericPages" OnEditCommand="objDataGird_Edit" OnCancelCommand="objDataGird_Cancel" OnUpdateCommand="objDataGird_Update" DataKeyField="DistrictID" AllowSorting="true" OnSortCommand="sortGrid">
<Columns>
<asp:editcommandcolumn EditText="Edit" CancelText="Cancel" UpdateText="Update" ItemStyle-Wrap="false"/>
<asp:BoundColumn DataField="DistrictID" HeaderText="ID" ReadOnly="true" SortExpression="DistrictID"/>
<asp:TemplateColumn HeaderText="Name" SortExpression="Name">
<ItemTemplate>
<asp:label Text=<%# FormatBlankAsNone(Container.DataItem("Name"))%> runat="server"></asp:label>
</ItemTemplate>
<editItemTemplate><asp:textbox ID="Name" Text=<%# Container.DataItem("Name"))%> TextMode="SingleLine" runat="server"/>
</editItemTemplate>
</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="CountyID" SortExpression="CountyID">
<ItemTemplate>
<asp:label Text=<%# Container.DataItem("CountyID")%> runat="server"/>
</ItemTemplate>
<editItemTemplate>

'=============================================================
'BUT IN HERE I WANT TO SHOW A DROPDOWNLIST WITH SELECT ALL FIELD FROM COUNTY TABLE FOR USER CHOOSE ONE VALUE</font id="red">
<asp:textbox ID="CountyID" Text=<%# Container.DataItem("CountyID"))%> TextMode="SingleLine" runat="server"/>
'=============================================================

</editItemTemplate>
</asp:TemplateColumn>


</Columns>
</asp:datagrid>

How can i do that? Pls, anyone had experience with this case, help me...thanks

 

cool_man77,

I think you will find your answers in this article : beta.experts-exchange.com/Programming/Programming_Languages/Dot_Net/Q_20687992.html

Success

--
Steurm
www.steurm.net/steurm