I am trying to populate dropdown list but it comes out empty
please help
<%@ Page Title="TimeTableWizard" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site1.Master" CodeBehind="Wizardtime.aspx.vb" Inherits="TMIS.Wizardtime" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<html xmlns="http://www.w3.org/1999/xhtml">
<body>
<div>
<asp:Wizard ID="Wizard1" runat="server" ActiveStepIndex="2" BackColor="#EFF3FB" BorderColor="#B5C7DE" BorderWidth="1px" Font-Names="Verdana" Font-Size="0.8em" Height="210px" OnNextButtonClick="Wizard1_NextButtonClick" Width="496px">
<HeaderStyle BackColor="#284E98" BorderColor="#EFF3FB" BorderStyle="Solid" BorderWidth="2px" Font-Bold="True" Font-Size="0.9em" ForeColor="White" HorizontalAlign="Center" />
<NavigationButtonStyle BackColor="White" BorderColor="#507CD1" BorderStyle="Solid" BorderWidth="1px" Font-Names="Verdana" Font-Size="0.8em" ForeColor="#284E98" />
<SideBarButtonStyle ForeColor="White" BackColor="#507CD1" Font-Names="Verdana" />
<SideBarStyle BackColor="#507CD1" Font-Size="0.9em" VerticalAlign="Top" />
<StepStyle Font-Size="0.8em" ForeColor="#333333" />
<WizardSteps>
<asp:WizardStep ID="WizardStep1" runat="server" Title="Class Details">
<table style="width: 100%;">
<tr>
<td>Class Details</td>
</tr>
<tr>
<td>Class</td>
<td><asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>
<td></td>
</tr>
<tr>
<td>Stream</td>
<td><asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></td>
<td> </td>
</tr>
</table>
</asp:WizardStep>
<asp:WizardStep ID="WizardStep2" runat="server" Title="Subject Details">
<table style="width: 100%;">
<tr>
<td colspan="4">Choose the Subjects you would want to include.</td>
</tr>
<tr>
<td class="auto-style4">Number of Periods</td>
<td colspan="3">
<asp:DropDownList ID="PeriodNumberdll" runat="server">
<asp:ListItem>1</asp:ListItem>
<asp:ListItem>2</asp:ListItem>
<asp:ListItem>3</asp:ListItem>
<asp:ListItem>4</asp:ListItem>
<asp:ListItem>5</asp:ListItem>
<asp:ListItem>6</asp:ListItem>
<asp:ListItem>7</asp:ListItem>
<asp:ListItem>8</asp:ListItem>
<asp:ListItem>9</asp:ListItem>
<asp:ListItem>10</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td class="auto-style5">Subject</td>
<td colspan="3" class="auto-style6">
<asp:DropDownList ID="Subjectdll" runat="server">
<asp:ListItem>MATHEMATICS</asp:ListItem>
<asp:ListItem>READING</asp:ListItem>
<asp:ListItem>ENGLISH</asp:ListItem>
<asp:ListItem>SCIENCE</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td class="auto-style4"> </td>
<td>
<asp:Button ID="Button2" runat="server" Text="Add" />
</td>
<td>
<asp:Button ID="Button3" runat="server" Text="Add All" />
</td>
<td>
<asp:Button ID="Button6" runat="server" Text="Remove Subject" />
</td>
</tr>
<asp:GridView ID="gvDetails" runat="server" AutoGenerateColumns="false" BorderWidth="0">
<Columns>
<asp:TemplateField HeaderText="Student Course Detail">
<ItemTemplate>Student CourseStudent BranchStudent BranchStudent BranchStudent BranchStudent BranchStudent Branch</ItemTemplate>
<ItemTemplate>Student Branch</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="">
<ItemTemplate>
<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
</ItemTemplate>
<ItemTemplate>
<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</table>
</asp:WizardStep>
<asp:WizardStep ID="WizardStep3" runat="server" Title="Add Teachers">
<table style="width: 100%;">
<tr>
<td>Choose Teacher to Add</td>
</tr>
<tr>
<td>Tearchers Name</td>
<td>
<asp:DropDownList ID="TeachersDll" runat="server">
</asp:DropDownList>
</td>
<td>
<asp:Label ID="Account" runat="server"></asp:Label>
</td>
</tr>
<tr>
<td>
<asp:Button ID="Button7" runat="server" Text="Search" />
</td>
<td>
<asp:Button ID="Button4" runat="server" Text="Add Teacher" />
</td>
<td>
<asp:Button ID="Button5" runat="server" Text="Remove Teacher" />
</td>
</tr>
<asp:GridView ID="TeacherGrid" runat="server" AutoGenerateColumns="false" BorderWidth="0">
<Columns>
<asp:TemplateField HeaderText="Teacher Details">
<ItemTemplate>Student CourseStudent BranchStudent BranchStudent BranchStudent BranchStudent BranchStudent Branch</ItemTemplate>
<ItemTemplate>Student Branch</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="">
<ItemTemplate>
<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
</ItemTemplate>
<ItemTemplate>
<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</table>
</asp:WizardStep>
<asp:WizardStep ID="WizardStep4" runat="server" Title="Summary">
</asp:WizardStep>
</WizardSteps>
</asp:Wizard>
</div>
</form>
</body>
</html>
</asp:Content>
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Me.IsPostBack Then
refreshdata()
refreshdata2()
End If
End Sub
Private Sub refreshdata2()
Dim query As String = "SELECT admno, FullName FROM Teacherdata"
Using con As SqlConnection = New SqlConnection(constr)
Using cmd As SqlCommand = New SqlCommand(query, con)
con.Open()
TeacherGrid.DataSource = cmd.ExecuteReader()
TeachersDll.DataTextField = "FullName"
TeachersDll.DataValueField = "admno"
TeachersDll.DataBind()
con.Close()
TeachersDll.Items.Insert(0, New ListItem("--Select Customer--", ""))
End Using
End Using
End Sub
Private Sub refreshdata()
Label1.Text = TextBox1.Text
Label2.Text = TextBox2.Text
Label3.Text = PeriodNumberdll.SelectedItem.Text
Label4.Text = Subjectdll.SelectedItem.Text
'Label5.Text = TeachersDll.SelectedItem.Text
' Label6.Text = TextBox6.Text
' Label7.Text = TextBox7.Text
End Sub
