新手问:下拉菜单的绑定!

Question

我数据库中有两个字段(typeid,typename).
我想通过下拉菜单绑定数据库!请问有人给我一段代码参考吗!谢谢

Answer 1

string strConn,strCmd;
strConn="DATABASE=Northwind;SERVER=localhost;UID=sa;PWD=;";
strCmd="SELECT employeeid,firstName,lastName FROM Employees";
SqlDataAdapter oCMD=new SqlDataAdapter(strCmd,strConn);
DataSet oDS=new DataSet();
oCMD.Fill(oDS,"EmployeesList");
DataTable dt=oDS.Tables["EmployeesList"];
dt.Columns.Add("EmployeeName",typeof(string),"lastName+','+firstname");
EmpList.DataSource=oDS.Tables["EmployeesList"].DefaultView;
EmpList.DataTextField="EmployeeName";
EmpList.DataValueField="employeeid";
EmpList.DataBind();

Answer 2

ArrayList  database = 这里把你数据库取出来的记录封装到这个LIST中.
List list = new ArrayList();
SelectItem item = null;
for( int i = 0;i<database.size;i++){
Object obj = (Object)database.get(i);
String  typeid = (String)obj.getTypeId();
String  typename= (String)obj.getTypeName();
item = new SelectItem(typeid,typename);
list.add( item  );
}
Object是你从数据库取出来的时候封装的CLASS名,
这是后台,前台你就直接绑定到一个下拉列表中,象这样:
  <tr>
<th scope="row" class="commontext">File名リスト</th>
<td id="filenamelist">
<h:selectManyCheckbox id="fileName" value="#{ReleasePublishForm.fileName}" layout="pageDirection">
<f:selectItems value="#{ReleasePublishForm.fileList}"/>
</h:selectManyCheckbox>
</td>
  </tr>fileList这个替换成,我上边组织的LIST就可以了.