如何将以下代码改为 C＃????
如何将以下代码改为 C＃????
Private Sub DataGrid1_ItemDataBound(ByVal sender As Object, _
ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) _
Handles DataGrid1.ItemDataBound
If e.Item.ItemType = ListItemType.EditItem Then
Dim DRV As DataRowView = CType(e.Item.DataItem, DataRowView)
Dim CurrentShip As String = DRV("ShipVia")
Dim DDL As DropDownList = _
CType(e.Item.Cells(4).Controls(1), DropDownList)
Dim SQL As String = _
"SELECT ShipperID, CompanyName FROM Shippers ORDER BY ShipperID"
Dim DA As SqlDataAdapter = New SqlDataAdapter(SQL, ConnStr)
Dim DS As New DataSet
Dim item As ListItem
DA.Fill(DS, "Shippers")
DDL.DataSource = DS.Tables("Shippers").DefaultView
DDL.DataTextField = "CompanyName"
DDL.DataValueField = "ShipperID"
DDL.DataBind()
item = DDL.Items.FindByValue(CurrentShip)
If Not item Is Nothing Then item.Selected = True
End If
End Sub
用于检查DropDownList并添加上数据库内容
<asp:TemplateColumn HeaderText="Ship Method">
<ItemTemplate>
<%#Container.DataItem("ShipVia")%>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList runat="server" ID="Dropdownlist1"/>
</EditItemTemplate>
</asp:TemplateColumn>
恳请赐教，谢先。。。。。
问题点数：20、回复次数：3Top
1 楼net_lover（【孟子E章】）回复于 2006-06-02 12:44:44 得分 10
private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.EditItem) {
DataRowView DRV = ((DataRowView)(e.Item.DataItem));
string CurrentShip = DRV("ShipVia");
DropDownList DDL = ((DropDownList)(e.Item.Cells[4].Controls[1]));
string SQL = "SELECT ShipperID, CompanyName FROM Shippers ORDER BY ShipperID";
SqlDataAdapter DA = new SqlDataAdapter(SQL, ConnStr);
DataSet DS = new DataSet();
ListItem item;
DA.Fill(DS, "Shippers");
DDL.DataSource = DS.Tables["Shippers"].DefaultView;
DDL.DataTextField = "CompanyName";
DDL.DataValueField = "ShipperID";
DDL.DataBind();
item = DDL.Items.FindByValue(CurrentShip);
if (!(item == null)) {
item.Selected = true;
}
}
}
Top
2 楼amandag（高歌）回复于 2006-06-02 12:48:41 得分 0
路过Top
3 楼viena（维也纳N02）回复于 2006-06-02 12:49:48 得分 10
private void InitializeComponent()
{
this.DataGrid1.ItemDataBound += new System.EventHandler(this.DataGrid1_ItemDataBound);
}
private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemType == ListItemType.EditItem)
{
DataRowView DRV = (DataRowView)e.Item.DataItem;
string CurrentShip = DRV["ShipVia"];
DropDownList DDL = (DropDownList)e.Item.Cells[4].Controls[1];
string SQL = "SELECT ShipperID, CompanyName FROM Shippers ORDER BY ShipperID";
SqlDataAdapter DA = new SqlDataAdapter(SQL, ConnStr);
DataSet DS = new DataSet();
ListItem item;
DA.Fill(DS, "Shippers");
DDL.DataSource = DS.Tables["Shippers"].DefaultView;
DDL.DataTextField = "CompanyName";
DDL.DataValueField = "ShipperID";
DDL.DataBind();
item = DDL.Items.FindByValue(CurrentShip);
if(item!=null)item.Selected = true;
}
}Top
