ok, men det er det som er mit problem... Jeg har denne kode:
<body style="font: 10pt verdana">
<form runat="server">
<span id="Message" EnableViewState="false" style="font: arial 11pt;" runat="server"/><p>
<ASP:DataGrid id="MyDataGrid" runat="server"
Width="800"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
OnSortCommand="MyDataGrid_Sort"
OnEditCommand="MyDataGrid_Edit"
OnCancelCommand="MyDataGrid_Cancel"
OnUpdateCommand="MyDataGrid_Update"
OnDeleteCommand="MyDataGrid_Delete"
DataKeyField="IDnumber"
AutoGenerateColumns="false"
AllowSorting="true"
>
<Columns>
<asp:EditCommandColumn EditText="Edit" CancelText="Cancel" UpdateText="Update" ItemStyle-Wrap="false"/>
<asp:BoundColumn HeaderText="IDnumber" SortExpression="IDnumber" ReadOnly="True" DataField="IDnumber" ItemStyle-Wrap="false"/>
<asp:ButtonColumn Text="Delete Employee" CommandName="Delete"/>
<asp:TemplateColumn HeaderText="Brand" SortExpression="IDbrand">
<ItemTemplate>
<asp:Label runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "brand") %>'/>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList id="dropBrand" DataTextField="brand" DataValueField="IDbrand" runat="server"/>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn HeaderText="Model" SortExpression="model" DataField="model" ItemStyle-Wrap="false"/>
<asp:BoundColumn HeaderText="Doors" SortExpression="doors" ReadOnly="True" DataField="doors" />
<asp:BoundColumn HeaderText="Year" SortExpression="year" ReadOnly="True" DataField="year" />
</Columns>
</ASP:DataGrid>
</form>
</body>
Som du nok laegger maerke til saa er dropdownlisten indeni en template. Min edit funktion ser saadanne ud:
Sub MyDataGrid_Edit(Sender As Object, E As DataGridCommandEventArgs)
MyDataGrid.EditItemIndex = CInt(E.Item.ItemIndex)
BindGrid("IDnumber")
Dim cmd1 As SqlCommand
Dim dtr1 as SqlDataReader
cmd1 = New SqlCommand( "select * from brands", MyConnection )
dtr1 = cmd1.ExecuteReader()
dropBrand.DataSource = dtr1
dropBrand.DataBind()
dtr1.Close()
End Sub
