【asp】asp.net 数据绑定的实例代码-net-数据-绑定

欢迎您访问我爱IT技术网，今天小编为你分享的编程技术是：【asp.net 数据绑定的实例代码】，下面是详细的讲解！

asp.net 数据绑定的实例代码

public partial class _Default : System.Web.UI.Page
{
    protected string title="大家好";            //前台代码<title><%#title %></title>
    protected void Page_Load(object sender, EventArgs e)
    {
        DataSet ds=new DataSet();
        string sql=ConfigurationManager.ConnectionStrings["strsql"].ConnectionString;
        using (SqlConnection sqlCnn=new SqlConnection(sql))
        {
            using (SqlCommand sqlCmm=sqlCnn.CreateCommand())
            {
                sqlCmm.CommandText="select * from List";
                SqlDataAdapter adapter=new SqlDataAdapter(sqlCmm);
                adapter.Fill(ds);
            }
            this.RadioButtonList1.DataSource=ds.Tables[0];
            this.RadioButtonList1.DataTextField="listname";
            this.RadioButtonList1.DataValueField="id";
            //this.RadioButtonList1.DataBind();
            this.CheckBoxList1.DataSource=ds.Tables[0];
            this.CheckBoxList1.DataTextField="listname";
            this.CheckBoxList1.DataValueField="id";
            //this.RadioButtonList1.DataBind();
            this.DataBind();
        }            //数据绑定到RadioButtonList,CheckBoxList
        if (!IsPostBack)
        {
            DataSet ds1=new DataSet();
            using (SqlConnection sqlCnn1=new SqlConnection(sql))
            {
                using (SqlCommand sqlCmm1=sqlCnn1.CreateCommand())
                {
                    sqlCmm1.CommandText="select provinceid,provincename from Province";
                    SqlDataAdapter adapter=new SqlDataAdapter(sqlCmm1);
                    adapter.Fill(ds1);
                    this.DropDownList1.DataSource=ds1.Tables[0];
                    this.DropDownList1.DataTextField="provincename";
                    this.DropDownList1.DataValueField="provinceid";
                    this.DropDownList1.DataBind();
                }
            }
        }
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        DataSet ds=new DataSet();
        string str=ConfigurationManager.ConnectionStrings["strsql"].ConnectionString;
        using (SqlConnection sqlCnn=new SqlConnection(str))
        {
            using (SqlCommand sqlCmm=sqlCnn.CreateCommand())
            {
                sqlCmm.CommandText="select cityid,cityname from City where provinceid='" + this.DropDownList1.SelectedValue + "'";
                SqlDataAdapter adapter=new SqlDataAdapter(sqlCmm);
                adapter.Fill(ds);
                this.DropDownList2.DataSource=ds.Tables[0];
                this.DropDownList2.DataTextField="cityname";
                this.DropDownList2.DataValueField="cityid";
                this.DropDownList2.DataBind();
            }
        }
    }//实现省市二级联动
}

关于asp.net 数据绑定的实例代码的用户互动如下：

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细