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()