How to implement data binding with asp.net
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.
