arraylist 数据库读取
如何把数据库读取的东西 放入arraylist里面
While Rd.Read()
Rd.GetValues(Fields)
Dim a as ArrayList= new ArrayList()
For I = 0 To Rd.FieldCount - 1
a["I"].add(rd)
DropDown1.DataSource = a[I]
DropDown1.DataBind
Next
End While
我想这么做 可是 错误的
问题点数：40、回复次数：7Top
1 楼javabuilder9（高守）回复于 2004-12-01 11:03:53 得分 0
是不是我的想法过于简单啊 嘿嘿
Top
2 楼shoutor（www.mouxiao.com）回复于 2004-12-01 11:13:33 得分 30
For I = 0 To Rd.FieldCount - 1
a["I"].add(rd)
Next
DropDown1.DataSource = a
DropDown1.DataBind
Top
3 楼srz007（呵呵）回复于 2004-12-01 11:25:26 得分 5
数据绑定放在循环外面Top
4 楼wawalike（天龙黄毛）回复于 2004-12-01 11:36:59 得分 5
看看对不对，楼上两位应该对的Top
5 楼javabuilder9（高守）回复于 2004-12-01 12:01:33 得分 0
对是对 可为什么只有一个选项啊 是不是数据仍然没有赋值给arraylist啊 而且选项的内容不是我要从数据库读取的Top
6 楼javabuilder9（高守）回复于 2004-12-01 12:02:41 得分 0
原代码如下
Dim Conn As OleDbConnection
Dim Cmd As OleDbCommand
Dim Rd As OleDbDataReader
Dim I As Integer
Dim Provider = "Provider=Microsoft.Jet.OLEDB.4.0"
Dim Database = "Data Source=" & Server.MapPath( "admin/shop.mdb" )
Conn = New OleDbConnection( Provider & ";" & DataBase )
Conn.Open()
Dim SQL = "Select bclassname From bclass"
Cmd = New OleDbCommand( SQL, Conn )
Rd = Cmd.ExecuteReader()
Dim Fields(Rd.FieldCount-1)
While Rd.Read()
Rd.GetValues(Fields)
Dim a as ArrayList= new ArrayList()
For I = 0 To Rd.FieldCount - 1
a(I)=a.add(rd)
Next
DropDown1.DataSource = a
DropDown1.DataBind
End While
Conn.Close()
Top
7 楼javabuilder9（高守）回复于 2004-12-01 13:41:21 得分 0
大家帮我解决一下啊Top
