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() |