请教datagrid里怎么绑定dropdownlist?

[chengxing]

请教datagrid里怎么绑定dropdownlist?

<DIV id="divDataGrid" class="DataGridDiv">
<asp:datagrid id="dgFacility" runat="server" BorderWidth="0" CellSpacing="1" CellPadding="0" CssClass="DataGridGeneral" ShowHeader="False" AutoGenerateColumns="False">
<ItemStyle CssClass="DataGridRow"></ItemStyle>
<Columns>
<asp:TemplateColumn HeaderText="Clubhouse Code">
<ItemStyle Width="20%" CssClass="DataGridCell"></ItemStyle>
<ItemTemplate>
<asp:textbox id="txtTransDate" Runat="server" Width="82%" ReadOnly="True">-- Please select --</asp:textbox> 
<IMG title="ShowCalendar"id="imgCanlendar1"onclick="Calendar_OnClick(this)" src="../../../Images/calendar.jpg" border="0">
</ItemTemplate>
</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="Description">
<ItemStyle Width="20%" CssClass="DataGridCell"></ItemStyle>
<ItemTemplate>
<asp:textbox id="Textbox1" Runat="server" Width="82%" ReadOnly="True">-- Please select --</asp:textbox> 
<IMG title="Show Calendar" id="imgCanlendar2" onclick="Calendar_OnClick(this)" src="../../../Images/calendar.jpg" border="0">
</ItemTemplate>
</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="Description">
<ItemStyle Width="13%" CssClass="DataGridCell"></ItemStyle>
<ItemTemplate>
<!--
<asp:dropdownlist id="ddlVenueCode" runat="server" CssClass="FontReadOnly" Width="157px"></asp:dropdownlist>
-->
如果我这里要绑定一个下拉列表改怎么做？好像上面注释的代码不能够绑定，请高手指点,谢谢！
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid>
</DIV>

[thinkingforever]

一般在datagrid的DataGrid1_ItemDataBound事件中给dropdownlist进行帮定
private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
取到数据
帮定dropdownlist
}

[chengxing]

<asp:TemplateColumn HeaderText="Description">
<ItemStyle Width="13%" CssClass="DataGridCell"></ItemStyle>
<ItemTemplate>

<asp:dropdownlist id="ddlVenueCode" runat="server" CssClass="FontReadOnly" Width="157px"></asp:dropdownlist>

---->我指的是这里的dropdownlist里怎么绑定数据?比如说Textbox里可以用Text属性绑定.

</ItemTemplate>
</asp:TemplateColumn>

[sanlands]

建一个模版列 再编辑就OK了

[yzhouen]

Private Sub DataGrid1_ItemDataBound(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles DataGrid1.ItemDataBound

Select Case e.Item.ItemType
Case ListItemType.EditItem
Dim DRV As DataRowView = CType(e.Item.DataItem, DataRowView)
Dim provinceid As String = IIf(IsDBNull(DRV("provinceid")), "", DRV("provinceid"))
Dim cityid As String = IIf(IsDBNull(DRV("cityid")), "", DRV("cityid"))

Dim myitem As ListItem
DDL1 = CType(e.Item.FindControl("item_province_list"), DropDownList)
DDL2 = CType(e.Item.FindControl("item_city_list"), DropDownList)
DDL1.Items.Clear()
DDL2.Items.Clear()

CType(e.Item.Cells(0).Controls(0), LinkButton).Attributes.Add("onclick", "return confirm('……?'); ")
Dim strconn As String = ConfigurationSettings.AppSettings("ODBC")
Dim myconn As OdbcConnection = New OdbcConnection(strconn)
Dim ds As DataSet = New DataSet()
Dim sql As String = "……"
Dim adpt As OdbcDataAdapter = New OdbcDataAdapter(sql, myconn)
ds.Clear()
adpt.Fill(ds)

DDL1.DataSource = ds.Tables(0).DefaultView
DDL1.DataTextField = "name"
DDL1.DataValueField = "provinceid"
DDL1.DataBind()

Dim item As ListItem
item = DDL1.Items.FindByValue(provinceid)

If Not item Is Nothing Then
item.Selected = True
End If

Dim procode As String = DDL1.SelectedItem.Value

ds.Clear()
sql = "……"
adpt = New OdbcDataAdapter(sql, myconn)
adpt.Fill(ds)
DDL2.DataSource = ds.Tables(0).DefaultView
DDL2.DataTextField = "name"
DDL2.DataValueField = "cityid"
DDL2.DataBind()

Dim item1 As ListItem
item1 = DDL2.Items.FindByValue(cityid)

If Not item1 Is Nothing Then
item1.Selected = True
End If

Case ListItemType.AlternatingItem, ListItemType.Item

Dim myTableCell As TableCell = e.Item.Cells(0)
Dim myDeleteButton As LinkButton = e.Item.Cells(0).Controls(0)
myDeleteButton.Attributes.Add("onclick", "return confirm'……'); ")

End Select
End Sub

[yzhouen]

Protected WithEvents DDL1 As System.Web.UI.WebControls.DropDownList 'province
Protected WithEvents DDL2 As System.Web.UI.WebControls.DropDownList 'city

[wwrong]

设置模板列
我绑了两个
Private Sub DataGrid1_EditCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.EditCommand
DataGrid1.EditItemIndex = e.Item.ItemIndex
bind()


Dim i, j As Integer
Dim value As String
Dim ddlb As DropDownList

For i = 0 To DataGrid1.Items(DataGrid1.EditItemIndex).Cells.Count - 1
If DataGrid1.Items(DataGrid1.EditItemIndex).Cells(i).Controls.Count > 1 Then
If TypeOf DataGrid1.Items(DataGrid1.EditItemIndex).Cells(i).Controls(1) Is DropDownList Then
ddlb = CType(DataGrid1.Items(DataGrid1.EditItemIndex).Cells(i).Controls(1), DropDownList)
ddlb.Items.Clear()
If i = 0 Then
bind1(ddlb)‘第一个
End If
If i = 1 Then
bind2(ddlb)
End If

For j = 0 To ddlb.Items.Count - 1
ddlb.Items(j).Value = ddlb.Items(j).Value.Trim
Next


End If
End If
Next
End Sub

[shoutor]

http://blog.csdn.net/shoutor