ASP.NET

<br />
 ' Fill ddlMemberGroup<br />
    Private Sub ddlMemberGroupFill()<br />
<br />
        If Not Page.IsPostBack Then<br />
            Dim conn As SqlConnection = New SqlConnection(Web.Configuration.WebConfigurationManager.ConnectionStrings("TCCLMS").ConnectionString)<br />
            Dim queryString As String = "SELECT GROUPID, GROUPNAME FROM MEMBERGROUP ORDER BY GROUPNAME ASC"<br />
            Try<br />
                conn.Open()<br />
                Dim comm As SqlCommand = New SqlCommand(queryString, conn)<br />
                ' Dim dataReader As SqlDataReader = comm.ExecuteReader()<br />
                Dim adapter As SqlDataAdapter = New SqlDataAdapter(comm)<br />
                Dim ds As DataSet = New DataSet()<br />
                ds.Clear()<br />
                adapter.Fill(ds)<br />
<br />
                ddlMemberGroup.DataSource = ds<br />
                ddlMemberGroup.DataTextField = "GroupName"<br />
                ddlMemberGroup.DataValueField = "GroupID"<br />
                ddlMemberGroup.DataBind()<br />
                ddlMemberGroup.Items.Insert(0, New ListItem("Select One...", "Value"))<br />
                conn.Close()<br />
            Catch ex As Exception<br />
<br />
                conn.Close()<br />
            End Try<br />
<br />
        End If<br />
<br />
    End Sub<br />

<br />
<asp:CompareValidator ID="cvddlMemberGroup" runat="server" ControlToValidate="ddlMemberGroup"<br />
                ErrorMessage="Please select a Member Type" Operator="NotEqual" ValueToCompare="Select One..."></asp:CompareValidator><br />

<br />
<asp:DropDownList id="ddlMemberGroup" runat="server" AutoPostBack="True"><br />
                <asp:ListItem>Select One..</asp:ListItem><br />
                <asp:ListItem>one</asp:ListItem><br />
                <asp:ListItem>two</asp:ListItem><br />
                <asp:ListItem>three</asp:ListItem><br />
                <asp:ListItem>four</asp:ListItem><br />
                <asp:ListItem></asp:ListItem><br />
</asp:DropDownList><br />