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

This article mainly introduces the. Net control dropdownlist how to dynamically bind data, the article is very detailed, has a certain reference value, interested friends must read it!

Bind the collection to DropDownList during page initialization

The copy code is as follows:

Public void Page_Load (Object src.EventArgs e)

{

ArrayList arrValue = new ArrayList ()

ArrValue.add ("kk")

ArrValue.add ("dd")

ArrValue.add ("aa")

ArrValue.add ("cc")

/ / bind the array to the DataSource property of the DropDownList control

Ddl.DataSource = arrValue

Ddl.DataBind ()

}

/ / implementation

The options are:

Add data to DropDownList when the page is initialized

The copy code is as follows:

Public void Page_Load (Object src.EventArgs e)

{

Ddl.Items.Add (new ListItem ("text", "value")

Ddl.Items.Add (new ListItem ("text1", "value1")

Ddl.Items.Add (new ListItem ("text2", "value2")

}

/ / implementation

The options are:

Dynamically bind the data read by DataReader to DropDownList

The copy code is as follows:

Protected void Page_Load (object sender, EventArgs e)

{

If (! Page.IsPostBack)

{

String myconnstr= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath (".") + "..\ database\\ db.mdb"

OleDbConnnection myconn=new OleDbConnnection (myconnstr)

String sqlstr= "select * from test"

OleDbCommand myComm = new OleDbCommand (sqlstr,myconn)

MyComm.Connection.Open ()

OleDbDataReader dr=myComm.ExecuteReader ()

While (dr.Read ())

{

Bj.Items.Add (new ListItem (dr ["bjmc"] .ToString (), dr ["id"] .ToString ()); / / add Item

/ / or it can also be bound.

/ / DropDownList1.Items.Add (new ListItem (myReader [1] .ToString (), myReader [0] .ToString ()); / / add Item

/ / you can only bind in this way if you know the Sql statement or the structure of the data table.

}

Dr.Close ()

}

}

Dynamically bind the data read by DataSet to DropDownList

The copy code is as follows:

SqlConnection sqlconn = new SqlConnection ()

Sqlconn.ConnectionString = "workstation id=localhost;packet size=4096;user

Id=sa;data source=db1;persist security info=False;initial catalog=DB "

Sqlconn.Open ()

SqlDataAdapter sqldar = new SqlDataAdapter ("select UserName from forums_Users", sqlconn)

Sqldar.SelectCommand.CommandType = CommandType.Text

DataSet Ds= new DataSet ()

Sqldar.Fill (Ds, "Users")

Ddl.DataSource = Ds.Tables ["Users"] .DefaultView

Ddl.DataTextField= "UsersName"

Ddl.DataBind ()

Sqlconn.Close ()

The first line is to create a sql connection object, sqlconn

The second line is to assign the correct value to the connection string of the newly created sql connection object sqlconn

The third line is to have the sql connection object sqlconn open and connect to the sql database

The fourth line is to create a sql adapter object, sqldar, and have it execute a sql query statement using the sqlconn object at the same time

The fifth line is to set the command type of the sqldar object to text

The sixth line is to create a dataset object Ds

The seventh line populates the result of sqldar execution into the Ds and names it Users

The eighth line sets the data source of DropDownList to Ds's Users and uses the default view mode

The ninth line is the field name UsersName that sets the display item in the DropDownList space.

The tenth line is the data binding method that executes DropDownList

Line 11 closes the sqlconn object.

Fifth, use DataBinder.eval_r (Container.DataItem, "table field") to output bound data

Protected void Page_Load (object sender, EventArgs e)

{

If (! Page.IsPostBack)

{

String myconnstr= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath (".") + "..\ database\\ db.mdb"

OleDbConnnection myconn=new OleDbConnnection (myconnstr)

String sqlstr= "select * from test"

OleDbCommand myComm = new OleDbCommand (sqlstr,myconn)

MyComm.Connection.Open ()

OleDbDataReader dr=myComm.ExecuteReader ()

Ddl.DataSource = dr

Ddl.DataBind (); bind inverted DD1

}

}

Directly called in the DDL of the UI interface, bound method calls

The code is as follows:

DataBinder.eval_r (Container.DataItem, "Table Field")

These are all the contents of the article "how to bind data dynamically by .net Control dropdownlist". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.