问题描述
以下是查询到的数据如何将"PNumber"字段的值绑定到DropDownList中.PrivateSubPage_Load(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesMyBase.Load'在此处放置初始化页的用户代码DimmSqlAsStringDimmCnAsSqlClient.SqlConnectionDimmCmdAsSqlClient.SqlCommandDimmRsAsSqlClient.SqlDataReaderDimmFiles()AsStringDimmStrAsStringDimiAsIntegerDimurlAsStringOnErrorGoToErrorHandleurl="../../PartMaster/doc/"mSql="selectID,PNumber"mSql=mSql+"fromnewDCpartmasterorderPNumber"mCn=NewSqlClient.SqlConnection("workstationid=dg;packetsize=4096;userid=sa;password=123456;datasource=ETLWEB;persistsecurityinfo=False;initialcatalog=EDC")mCmd=NewSqlClient.SqlCommandmCmd.Connection=mCnmCmd.CommandType=CommandType.TextmCmd.CommandText=mSqlmCn.Open()mRs=mCmd.ExecuteReadermCn.Close()mCmd=NothingExitSubErrorHandle:mCn=NothingmCmd=NothingmRs=NothingEndSub
解决方案
解决方案二:
mRs.DataTextField="PNumber";mRs.DataValueField="ID";//上面设置dropdownListmSql="selectID,PNumber"mSql=mSql+"fromnewDCpartmasterorderPNumber"mCn=NewSqlClient.SqlConnection("workstationid=dg;packetsize=4096;userid=sa;password=123456;datasource=ETLWEB;persistsecurityinfo=False;initialcatalog=EDC")mCmd=NewSqlClient.SqlCommandmCmd.Connection=mCnmCmd.CommandType=CommandType.TextmCmd.CommandText=mSqlmCn.Open()mRs=mCmd.ExecuteReadermCn.Close()mCmd=Nothing
解决方案三:
不明白,请给点详细的代码.
解决方案四:
检索出来的ID,PNumber可以add到DropDownList的实例中
解决方案五:
mRs.DataTextField="PNumber";mRs.DataValueField="ID";要设置dropdownlist的文本和值字段名称。
解决方案六:
mRs.DataTextField="PNumber";mRs.DataValueField="ID";mRs.DataSource=myData;mRs.DataBind();类似这样设置就可以绑定了.