Shulou(Shulou.com)06/03 Report--

This article will explain in detail how to achieve data binding in asp.net. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

The code is as follows:

Public partial class _ Default: System.Web.UI.Page

{

Protected string title= "Hello everyone"; / / Front desk code

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

} / / data binding to 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 ()

}

}

} / / realize the two-level linkage between provinces and cities

}

This is the end of the article on "how to achieve data binding in asp.net". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.