DropDownList 空白第一行

 
DropDownList 空白第一行
 

   Default.aspx
 
 
   <asp:DropDownList ID="DropDownList1" runat="server"
   AutoPostBack="True" AppendDataBoundItems="True">
   <asp:ListItem Selected="True" Text="" Value="0"></asp:ListItem>
   </asp:DropDownList>
 
 

 

   Default.aspx.vb
 
   Dim connectionString1 As String = "Data Source=.\SqlExpress; Initial Catalog=Soccer; Integrated Security=SSPI"
   Dim con1 As SqlConnection = New SqlConnection(connectionString1)
   con1.Open()
 
   Dim sb As New StringBuilder
   sb.Append("SELECT * FROM dbo.League ORDER BY dbo.League.League_Name;")
 
   Dim Adapter As New SqlDataAdapter(sb.ToString(), con1)
   Dim ds As New DataSet
 
   Adapter.Fill(ds)
 
   DropDownList1.DataSource = ds.Tables(0).DefaultView
   DropDownList1.DataTextField = "League_Name"
   DropDownList1.DataValueField = "League_ID"
 
   DropDownList1.DataBind()
 
   con1.Close()
   con1.Dispose()