DPC：Creating a DataBound List of Radio Buttons--预览页面source code[等级：中]-ASP.NET教程-爱易网页

DPC：Creating a DataBound List of Radio Buttons--预览页面source code[等级：中]

日期：2013-09-19　浏览次数：20382 次

<% @Import Namespace="System.Data" %> 
<% @Import Namespace="System.Data.SqlClient" %> 
<script language="vb" runat="server"> 
 Sub Page_Load(sender as Object, e as EventArgs) 
 If Not Page.IsPostBack then 
 BindData() 
 End If 
 End Sub 
 
 
 Sub BindData() 
 '1. Create a connection 
 Dim myConnection as New SqlConnection(ConfigurationSettings.AppSettings("connectionString")) 
 
 '2. Create the command object, passing in the SQL string 
 Const strSQL as String = "SELECT PublisherID, Name FROM tblPublishers ORDER BY Name" 
 Dim myCommand as New SqlCommand(strSQL, myConnection) 
 
 myConnection.Open() 
 
 radlstPubs.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection) 
 radlstPubs.DataBind() 
 
 End Sub 
 
 
 
 Sub btnViewBooks_Click(sender as Object, e as EventArgs) 
 'If the user has not selected an item from the radiobuttonlist, 
 'do nothing 
 If radlstPubs.SelectedItem Is Nothing then Exit Sub 
 
 '1. Create a connection 
 Dim myConnection as New SqlConnection(ConfigurationSettings.AppSettings("connectionString")) 
 
 '2. Create the command object, passing in the SQL string 
 Dim strSQL as String = "SELECT Title, Description FROM tblBooks " & _ 
 " WHERE PublisherID = " & radlstPubs.SelectedItem.Value & _ 
 " ORDER BY Title" 
 Dim myCommand as New SqlCommand(strSQL, myConnection) 
 
 myConnection.Open() 
 
 dgBooks.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection) 
 dgBooks.DataBind() 
 
 lblTitle.Text = "Books Published by " & radlstPubs.SelectedItem.Text 
 End Sub 
</script> 
 
<html> 
<body> 
 
 <h1>Radio Button List Demo</h1> 
 This demo illustrates how to use data-binding to dynamically 
 create a radio button list based on database information. 
 The data below is from the 
 <a href="http://www.4guysfromrolla.com/webtech/chapters/">Sample Chapters Database</a>. 
 First, the radio button list is bound to the <code>tblPublishers</code> table. Then, 
 when you select a pu

免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。

DPC：Creating a DataBound List of Radio Buttons--预览页面source code[等级：中]

相关资料更多>

推荐阅读更多>