如何将数据表列与组合框绑定 [英] How to bind data table column with combo box

问题描述

我有一个名为employee的表（empID，EmpName，EmpSalary）

我想将'EmpName'列绑定到我表单上的组合框。有多少种方式......我可以做到这一点。



我尝试了什么：



我试图将数据表列包含到组合框中。

解决方案

 objdbconn.OpenConn（）
 msSQL =  从hrm_mst_temployee选择a.employee_gid，concat（user_firstname，''，user_lastname）作为employee_name& _ 
  内部联接adm_mst_tuser b on a.user_gid = b.user_gid order by user_firstname asc 
 ds_data = objdbconn.GetDataSet（msSQL，  hrm_mst_temployee）
 cboEmployee .DataSource = ds_data 
 cboEmployee.DataMember =   hrm_mst_temployee 
 cboEmployee.DataTextField =   employee_name 
 cboEmployee.DataValueField =    employee_gid 
 cboEmployee.DataBind（）
 cboEmployee.Items.Insert（ 0 ，   - 选择 - ）
 cboEmployee.SelectedIndex = -1 
 ds_data.Dispose（）
 objdbco nn.CloseConn（）

I have table named employee(empID,EmpName,EmpSalary)
I want to bind 'EmpName' column to combo box on my form. how many ways.. I can do this.

What I have tried:

I am trying to bind data tables column containt to with combo box.

解决方案

objdbconn.OpenConn()
       msSQL = " select a.employee_gid,concat(user_firstname,' ',user_lastname) as employee_name from hrm_mst_temployee a " & _
               " inner join adm_mst_tuser b on a.user_gid=b.user_gid order by user_firstname asc "
       ds_data = objdbconn.GetDataSet(msSQL, "hrm_mst_temployee")
       cboEmployee.DataSource = ds_data
       cboEmployee.DataMember = "hrm_mst_temployee"
       cboEmployee.DataTextField = "employee_name"
       cboEmployee.DataValueField = "employee_gid"
       cboEmployee.DataBind()
       cboEmployee.Items.Insert(0, "--Select--")
       cboEmployee.SelectedIndex = -1
       ds_data.Dispose()
       objdbconn.CloseConn()

这篇关于如何将数据表列与组合框绑定的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！