Hi,

Please can somebody help me on this, my head really hurts!!!!!

The problem is this, i have a datagrid which reads in an xml file. The datagrid works fine. I have a dropdownlist column which i want to be populated with value colour. I have this simple xml file:

Code:
<cars>
  <car id="1">
    <name>VW Golf</name>
    <colour>Green</colour>
  </car>
  <car id="2">
    <name>Fieta</name>
    <colour>White</colour>
  </car>
</cars>
I would like this DDlist to have only the value and text set to its associated car colour. I have tried using the simple container :

Code:
<EditItemTemplate>
<asp:DropDownList id="ddl"  DataTextField='<%# DataBinder.Eval(Container, "DataItem.colour") %>' runat="server"></asp:DropDownList>
</EditItemTemplate>
I have tried so many different combinations to get this simple functionality to work but just can't do it. I can bind all the colour values from the xml file to the DDL but i just want the value associated to that car. So each row in the datagrid will have a different colour in the DDL. I guess most of you are thinking why not just use a textbox. I basically then want to add other colour items to the DDL depending on the colour that is in the DDL.

Hope i make sense. I really would appreciate any help on this, pointers, suggestions. I have read through every page on the net but can't seem to get this to work!