不行呀,出現如下錯誤: Compiler Error Message: BC30311: Value of type 'System.Data.OleDb.OleDbDataReader' cannot be converted to 'String'. 代碼為: Sub DropDownList_BindGrid() CmdSelect=new OleDbCommand("select * from class order by id",MyConnection) MyConnection.Open() dtrReader=CmdSelect.ExecuteReader() dropnews.DataSource=dtrReader dropnews.DataTextField="bigclass" dropnews.DataValueField="bigclassid" dropnews.Items.FindByText(dtrReader["bigclass"].ToString().Trim()).Selected = true dropnews.DataBind() dtrReader.Close() MyConnection.Close() End Sub 請問怎樣解決????
if (drv == null) return;
if((drv["数据库字段"]).Trim().ToString()!="")
ddl.SelectedIndex=ddl.Items.IndexOf(ddl.Items.FindByText((drv["数据库字段"]).Trim()).ToString()));
else
ddl.SelectedIndex=0;
Compiler Error Message: BC30311: Value of type 'System.Data.OleDb.OleDbDataReader' cannot be converted to 'String'.
代碼為:
Sub DropDownList_BindGrid()
CmdSelect=new OleDbCommand("select * from class order by id",MyConnection)
MyConnection.Open()
dtrReader=CmdSelect.ExecuteReader() dropnews.DataSource=dtrReader
dropnews.DataTextField="bigclass"
dropnews.DataValueField="bigclassid" dropnews.Items.FindByText(dtrReader["bigclass"].ToString().Trim()).Selected = true dropnews.DataBind()
dtrReader.Close()
MyConnection.Close()
End Sub
請問怎樣解決????