数据绑定

1 使用简单绑定完成页面标题 (title) 的绑定

<head runat="server">
<title> <%#title()%></title>
</head>

protected string title()
{

string sql="简单的数据绑定!";
return sql;
}

2 使用复杂绑定完成 CheckBoxList 和 RadioButtonList 控件的绑定

aspx文件:

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:RadioButtonList ID="RadioButtonList1" runat="server">
</asp:RadioButtonList>
<asp:CheckBoxList ID="CheckBoxList1" runat="server">
</asp:CheckBoxList> </div>
</form>
</body>
</html>

aspx.cs文件

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using sqlHealpler;

namespace ASPdotNetSUPPER
{
public partial class complexBand1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string sql = "select * from T_Province";
DataTable dt = sqlHealper.ExecuteTable(sql);
this.RadioButtonList1.DataSource = dt;
this.RadioButtonList1.DataTextField = "Pname";
this.RadioButtonList1.DataValueField = "Id";
this.CheckBoxList1.DataSource = dt;
this.CheckBoxList1.DataTextField = "Pname";
this.CheckBoxList1.DataValueField = "Id";
this.DataBind();
}
}
}


3 创建数据库表 province 和 city ,使用 dropdownlist 的绑定,实现省市列表级联。

aspx文件:

<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
Xonselectedindexchanged="DropDownList1_SelectedIndexChanged">
</asp:DropDownList>
<asp:DropDownList ID="DropDownList2" runat="server">
</asp:DropDownList>
</div>
</form>
</body>


aspx.cs文件

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlDataReader reader = sqlhelper.datareader("select * from p");
if (reader.HasRows)
{
DropDownList1.DataSource = reader;
DropDownList1.DataTextField = "p";
DropDownList1.DataValueField = "id";
DropDownList1.DataBind();
DropDownList1.SelectedIndex = 0;

string value = DropDownList1.SelectedValue;
SqlDataReader reader2 = sqlhelper.datareader("select * from city where pid=@pid", new SqlParameter("@pid", value));
if (reader2.HasRows)
{
DropDownList2.DataSource = reader2;
DropDownList2.DataTextField = "city";
DropDownList2.DataValueField = "id";
DropDownList2.DataBind();
}
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
string value=DropDownList1.SelectedValue;
SqlDataReader reader = sqlhelper.datareader("select * from city where pid=@pid", new SqlParameter("@pid", value));
if (reader.HasRows)
{
DropDownList2.DataSource = reader;
DropDownList2.DataTextField = "city";
DropDownList2.DataValueField = "id";
DropDownList2.DataBind();
}
}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值