DropDownList

Question

User-49671077 posted

I have the following code to fill dropdownlist:

Dim strConn As String = ConfigurationManager.ConnectionStrings("connectionString").ConnectionString
        Using sqlConn As New SqlConnection(strConn)
            Using sqlCmd As New SqlCommand()
                sqlCmd.CommandText = "SELECT departmentname FROM DepartmentMembership where sid='" & Session("empId") & "' order by ordby"
                sqlCmd.Connection = sqlConn
                sqlConn.Open()
                Dim da As New SqlDataAdapter(sqlCmd)
                Dim dt As New DataTable()
                
                da.Fill(dt)
                EmpDept.DataSource = dt

                EmpDept.DataValueField = "departmentname"
                EmpDept.DataTextField = "departmentname"
                EmpDept.DataBind()
                sqlConn.Close()
            End Using
        End Using

I want if dropdownlist is emply then show msgbox("Please add data")

Thanks

Answer 1

User475983607 posted

I want if dropdownlist is emply then show msgbox("Please add data")

This requirement is not possible in a web application because the MsgBox will display on the web server not in the browser.   Anyway, you just need to write code that checks if the SQL results set is empty then prompt the user to add data using standard server controls.  For example a label.

If you are building a Windows Application then you are in the wrong support forum.   

Answer 2

User-49671077 posted

Thanks for reply..

Is possible to insert word "Add data" in blank dropdownlist if it is empty? 

Answer 3

User-49671077 posted

Issue Solved..