给你一个例子,你研究一下,比较复杂的一个例子,主体和明细关系的,没时间,就不给你分开了。 Sub prvSub_XMLBindDrp_CZ() '绑定材质的主体,已排序 myDs = New DataSet() Dim myDataView As DataView myDs.ReadXml(Server.MapPath("../../../备份/XML文档/基础数据/材质大类.xml")) myDataView = myDs.Tables(0).DefaultView myDataView.RowFilter = "删除标记='否'" myDataView.RowStateFilter = DataViewRowState.CurrentRows myDataView.Sort = "材质大类" drpjmm_cl.Items.Clear() drpjmm_cl.Items.Add("") Dim i As Integer For i = 0 To myDataView.Count - 1 Dim myItem As New ListItem() myItem.Value = myDataView.Item(i).Item(0) myItem.Text = myDataView.Item(i).Item(1) drpjmm_cl.Items.Add(myItem) Next If viewstate("State") = "new" Then drpjmm_cl.SelectedIndex = -1 drpjmm_cz.Items.Clear() drpjmm_cz.Items.Add("") End If End Sub Sub prvSub_XMLBindDrp_CZ_MX() '绑定材质大类的明细,已排序 myDs = New DataSet() Dim myDataView As DataView myDs.ReadXml(Server.MapPath("../../../备份/XML文档/基础数据/材质大类.xml")) myDataView = myDs.Tables(1).DefaultView myDataView.RowFilter = "删除标记='否' and 主体_Id=" & drpjmm_cl.SelectedItem.Value myDataView.RowStateFilter = DataViewRowState.CurrentRows myDataView.Sort = "材质代码" drpjmm_cz.Items.Clear() drpjmm_cz.Items.Add("") Dim i As Integer For i = 0 To myDataView.Count - 1 drpjmm_cz.Items.Add(myDataView.Item(i).Item(0)) Next End Sub
这是俺写的代码! objDb是俺写的一个数据服务类! strSql="SELECT id,Zzmc FROM SYS_SetInstance"; DropDownList1.DataSource=objDb.GetDataSet(strSql,"SYS_SetInstance"); DropDownList1.DataTextField="Zzmc"; DropDownList1.DataValueField="id"; DropDownList1.DataBind();
to Kiven1978(谁隐) myDataView.Item(i).Item(1) 这个是什么用法为何在C#中没有这个东西
能写一下吗 VB.NET Dim i As Integer For i = 0 To myDataView.Count - 1 Dim myItem As New ListItem() myItem.Value = myDataView.Item(i).Item(0) myItem.Text = myDataView.Item(i).Item(1) drpjmm_cl.Items.Add(myItem) Next C# for (int i = 0; i<=myDataView.Count - 1;i++) { ListItem myItem = new ListItem(); // myItem.Value = myDataView.Table[i].Item[0]; //这里如何写呢? // myItem.Text = myDataView.Item[i].Item[1]; DropDownList1.Items.Add(myItem);
ds.ReadXml(@"d:\111.xml");
DropDownList1.DataSource=ds;
DropDownList1.DataBind();
Sub prvSub_XMLBindDrp_CZ() '绑定材质的主体,已排序
myDs = New DataSet()
Dim myDataView As DataView
myDs.ReadXml(Server.MapPath("../../../备份/XML文档/基础数据/材质大类.xml"))
myDataView = myDs.Tables(0).DefaultView
myDataView.RowFilter = "删除标记='否'"
myDataView.RowStateFilter = DataViewRowState.CurrentRows
myDataView.Sort = "材质大类"
drpjmm_cl.Items.Clear()
drpjmm_cl.Items.Add("")
Dim i As Integer
For i = 0 To myDataView.Count - 1
Dim myItem As New ListItem()
myItem.Value = myDataView.Item(i).Item(0)
myItem.Text = myDataView.Item(i).Item(1)
drpjmm_cl.Items.Add(myItem)
Next
If viewstate("State") = "new" Then
drpjmm_cl.SelectedIndex = -1
drpjmm_cz.Items.Clear()
drpjmm_cz.Items.Add("")
End If
End Sub Sub prvSub_XMLBindDrp_CZ_MX() '绑定材质大类的明细,已排序
myDs = New DataSet()
Dim myDataView As DataView
myDs.ReadXml(Server.MapPath("../../../备份/XML文档/基础数据/材质大类.xml"))
myDataView = myDs.Tables(1).DefaultView
myDataView.RowFilter = "删除标记='否' and 主体_Id=" & drpjmm_cl.SelectedItem.Value
myDataView.RowStateFilter = DataViewRowState.CurrentRows
myDataView.Sort = "材质代码"
drpjmm_cz.Items.Clear()
drpjmm_cz.Items.Add("")
Dim i As Integer
For i = 0 To myDataView.Count - 1
drpjmm_cz.Items.Add(myDataView.Item(i).Item(0))
Next
End Sub
objDb是俺写的一个数据服务类!
strSql="SELECT id,Zzmc FROM SYS_SetInstance";
DropDownList1.DataSource=objDb.GetDataSet(strSql,"SYS_SetInstance");
DropDownList1.DataTextField="Zzmc";
DropDownList1.DataValueField="id";
DropDownList1.DataBind();
这个是什么用法为何在C#中没有这个东西
VB.NET
Dim i As Integer
For i = 0 To myDataView.Count - 1
Dim myItem As New ListItem()
myItem.Value = myDataView.Item(i).Item(0)
myItem.Text = myDataView.Item(i).Item(1)
drpjmm_cl.Items.Add(myItem)
Next
C#
for (int i = 0; i<=myDataView.Count - 1;i++)
{
ListItem myItem = new ListItem();
// myItem.Value = myDataView.Table[i].Item[0]; //这里如何写呢?
// myItem.Text = myDataView.Item[i].Item[1];
DropDownList1.Items.Add(myItem);