汽车离合器分类哪些:DropDownList 如何绑定sqldatareader

来源:百度文库 编辑:杭州交通信息网 时间:2024/04/29 17:37:40
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
OleDbDataAdapter1.Fill(DataSet11)
DataGrid1.DataBind()
Dim constr As String = "SELECT * FROM History_sp "
Dim conn As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\spdb.mdb;" & _
"User ID=Admin;" & _
"Password="
Dim mycon As OleDb.OleDbConnection = New OleDb.OleDbConnection(conn)
Dim da As DropDownList
Dim mycmd As OleDb.OleDbCommand
Dim myreader As OleDb.OleDbDataReader
mycon.Open()
mycmd = New OleDb.OleDbCommand(constr, mycon)
myreader = mycmd.ExecuteReader
da = DataGrid1.FindControl("DropDownList1")
da.DataSource = myreader.GetValue(11)
da.DataBind()
'在此处放置初始化页的用户代码
End Sub
DropDownList1是我在datagrid加的模板,我想把它绑到某一字段上可是不行
,程序哪里有问题,谢谢

xDropDownList.DataSource=mySqlDataReader;
xDropDownList.DataBind();