从数据库下拉列表数据绑定 [英] Dropdownlist databind from database

问题描述

在过去的几个小时中，我一直在努力解决一个非常奇怪的问题.

我有3个下拉控件.
第一个控件在page_load事件上绑定
第二个控件绑定到第一个下拉单击
然后其检索值和绑定3下拉控件>这种情况仅在第1次下拉点击时发生.问题出在这里，它显示数据表已正确填充，但页面下拉菜单中未显示记录.

有人知道会发生什么问题吗?
代码运行正常.

代码:

Hi,

From past few hours i am struggling with very strange problem.

I have 3 drop down controls.
1st control is binding on page_load event
2nd control is binding on 1st drop down click
then its retrieving value and binding 3 drop down control > this happens on 1st drop down click only. Here goes issue, it shows datatable filled properly but not showing records in drop down on page.

Do anybody have an idea what issue can be.
Code is running properly.

code :

dtRequestBy = objDB.GetEmployeeName(cmbGroup.Text)
                    drRequestBy = dtRequestBy.NewRow()
                    drRequestBy.Item("FullName") = ""
                    drRequestBy.Item("Emp_id") = 0
                    dtRequestBy.Rows.InsertAt(drRequestBy, 0)
                    RadComboBox1.DataTextField = "FullName"
                    RadComboBox1.DataValueField = "Emp_id"
                    RadComboBox1.DataSource = dtRequestBy
                    RadComboBox1.DataBind()

Public Function GetEmployeeName(ByVal g_name As String) As DataTable
            Try
                cn = New SqlConnection(cnStr)
                cn.Open()

                Dim strSQL As String
                strSQL = "select emp.Emp_id, FullName = emp.Emp_Salutation + '' '' + emp.Emp_FirstName + '' '' + emp.Emp_LastName from employee emp left join groups gp on gp.g_id=emp.emp_g_id WHERE gp.g_Name=''" & g_name & "'' order by Emp_FirstName"
                Dim myDS As New DataSet
                Dim myDataAdapter As New SqlDataAdapter(strSQL, cn)
                myDataAdapter.Fill(myDS, "Employee")
                Return myDS.Tables(0)
            Catch ex As Exception

            Finally
                If cn.State = ConnectionState.Open Then cn.Close()
            End Try
        End Function

非常感谢任何帮助.

Any help is greatly appreciated.

推荐答案

已加载数据，但未在DropDownList中显示.

将第一个DropDownList的AutoPostBack设置为"True".希望这会起作用.

Data loaded but not show in DropDownList.

Set AutoPostBack "True" of 1st DropDownList. Hope this will work.

这篇关于从数据库下拉列表数据绑定的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！