ASP.Net/ADO.net Database/DropDownList

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

Bind data from OleDbConnection to asp:dropdownlist

   <source lang="csharp">

<%@ Page Language=VB Debug=true %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OLEDB" %> <script runat=server> Sub Page_Load(ByVal Sender as Object, ByVal E as EventArgs) 

   If Not IsPostBack Then
       Dim DBConn as OleDbConnection
       Dim DBCommand As OleDbDataAdapter
       Dim DSPageData as New DataSet
       "DBConn = New OleDbConnection( _
       "    "PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
       "    & "DATA SOURCE=" _
       "    & Server.MapPath("EmployeeDatabase.mdb;"))
       "DBConn = New OleDbConnection( _
       "    "PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
       "    & "DATA SOURCE=" _
       "    & "c:\inetpub\wwwroot\EmployeeDatabase.mdb;")
       DBConn = New OleDbConnection( _
           "PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
           & "DATA SOURCE=" _
           & MapPath("EmployeeDatabase.mdb;"))
       DBCommand = New OleDbDataAdapter _
           ("Select LastName & ", " & FirstName " _
           & "as EmpName, ID " _
           & "From Employee " _
           & "Order By LastName, FirstName", DBConn)
       DBCommand.Fill(DSPageData, _
           "Employee")
       ddlEmps.DataSource = _
           DSPageData.Tables("Employee").DefaultView
       ddlEmps.DataBind()
   End If

End Sub </SCRIPT> <HTML> <HEAD> <TITLE>Connecting to an Access Database</TITLE> </HEAD> <Body LEFTMARGIN="40"> <form runat="server">

<asp:dropdownlist 

   id="ddlEmps"
   datatextfield="EmpName" 
   datavaluefield="ID"
   runat="server"

/> </form> </BODY> </HTML> 

      </source>

<A href="http://www.nfex.ru/Code/ASPDownload/EmployeeDatabase.zip">EmployeeDatabase.zip( 10 k)</a>


Bind data source to asp:DropDownList

   <source lang="csharp">

<%@ Page Language="VB" %> <script runat="server"> 

       Function AllPublishers() As System.Data.SqlClient.SqlDataReader
           Dim connectionString As String = "server="(local)\NetSDK"; trusted_connection=true; Database="pubs""
           Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionString)
   
           Dim queryString As String = "SELECT [publishers].* FROM [publishers]"
           Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection)
   
           sqlConnection.Open
           Dim dataReader As System.Data.SqlClient.SqlDataReader = sqlCommand.ExecuteReader(System.Data.rumandBehavior.CloseConnection)
   
           Return dataReader
       End Function
       
   Sub Page_Load(sender As Object, e As EventArgs)
     Page.DataBind()
   End Sub

</script> <html> <head> </head> <body> 

   <form runat="server">

<asp:CheckBoxList id="CheckBoxList1" runat="server" DataSource="<%# AllPublishers() %>" DataTextField="pub_name" DataValueField="pub_id"></asp:CheckBoxList>

<asp:RadioButtonList id="RadioButtonList1" runat="server" DataSource="<%# AllPublishers() %>" DataTextField="pub_name" DataValueField="pub_id"></asp:RadioButtonList>

<asp:DropDownList id="DropDownList1" runat="server" DataSource="<%# AllPublishers() %>" DataTextField="pub_name" DataValueField="pub_id"></asp:DropDownList>

<asp:ListBox id="ListBox1" runat="server" DataSource="<%# AllPublishers() %>" DataTextField="pub_name" DataValueField="pub_id"></asp:ListBox>

<asp:Repeater id="Repeater1" runat="server" DataSource="<%# AllPublishers() %>"> <HeaderTemplate> Publisher List:
</HeaderTemplate> <ItemTemplate> <%# DataBinder.Eval(Container.DataItem, "pub_name") %> (ID: <%# DataBinder.Eval(Container.DataItem, "pub_id") %>) <%# DataBinder.Eval(Container.DataItem, "city") %>, <%# DataBinder.Eval(Container.DataItem, "state") %>, <%# DataBinder.Eval(Container.DataItem, "country") %>
</ItemTemplate> </asp:Repeater>

<asp:DataList id="DataList1" runat="server" DataSource="<%# AllPublishers() %>"> <ItemTemplate> <p> ID: <asp:Label id="Label6" runat="server" Text="<%# DataBinder.Eval(Container.DataItem, "pub_id") %>"></asp:Label>  Name: <asp:Label id="Label7" runat="server" Text="<%# DataBinder.Eval(Container.DataItem, "pub_name") %>"></asp:Label>

Address: <asp:Label id="Label8" runat="server" Text="<%# DataBinder.Eval(Container.DataItem, "city") %>"></asp:Label> , <asp:Label id="Label9" runat="server" Text="<%# DataBinder.Eval(Container.DataItem, "state") %>"></asp:Label> , <asp:Label id="Label10" runat="server" Text="<%# DataBinder.Eval(Container.DataItem, "country") %>"></asp:Label> 

               </ItemTemplate>
               <HeaderTemplate>
                   <asp:Label id="Label1" runat="server" Font-Names="Tahoma" Font-Italic="True">List of publishers:</asp:Label>

               </HeaderTemplate>
               <FooterTemplate>

               </FooterTemplate>
               <SeparatorTemplate>

                    

                    
               </SeparatorTemplate>
           </asp:DataList>
       </p>
   </form>

</body> </html> 

      </source>


Binding Database Data to a DropDownList Control

   <source lang="csharp">

<%@ Page Language=VB Debug=true %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OLEDB" %> <script runat=server> Sub Page_Load(ByVal Sender as Object, ByVal E as EventArgs) 

   If Not IsPostBack Then
       Dim DBConn as OleDbConnection
       Dim DBCommand As OleDbDataAdapter
       Dim DSPageData as New DataSet
       DBConn = New OleDbConnection( _
           "PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
           & "DATA SOURCE=" _
           & Server.MapPath("EmployeeDatabase.mdb;"))
       DBCommand = New OleDbDataAdapter _
           ("Select ID, FirstName " _
           & "From Employee " _
           & "Order By FirstName", DBConn)
       DBCommand.Fill(DSPageData, _
           "Employee")
       ddlEmployees.DataSource = _
           DSPageData.Tables("Employee").DefaultView
       ddlEmployees.DataBind()
   End If

End Sub Sub SubmitBtn_Click(Sender As Object, E As EventArgs) 

   lblDataSelected.Text = "Selected Text: " _
       & ddlEmployees.SelectedItem.Text _
       & "
Selected Value: " _
       & ddlEmployees.SelectedItem.Value _
       & "
Selected Index: " _
       & ddlEmployees.SelectedIndex

End Sub </SCRIPT> <HTML> <HEAD> <TITLE>Binding Database Data to a DropDownList Control</TITLE> </HEAD> <Body LEFTMARGIN="40"> <form runat="server">

<asp:label 

   id="lblDataSelected" 
   runat="server"

/>

<asp:dropdownlist 

   id="ddlEmployees"
   datatextfield="FirstName" 
   datavaluefield="ID"
   runat="server"

/>

<asp:button 

   id="butOK"
   text="OK"
   type="Submit"
   onclick="SubmitBtn_Click" 
   runat="server"

/> </form> </BODY> </HTML> 

      </source>

<A href="http://www.nfex.ru/Code/ASPDownload/EmployeeDatabase.zip">EmployeeDatabase.zip( 10 k)</a>

Источник — «http://nfex.ru/index.php?title=ASP.Net/ADO.net_Database/DropDownList&oldid=1669»