using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class LIstBoundingFromDatabase : System.Web.UI.Page{ SqlConnection connection; SqlCommand cmd; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Connect(); } } public void Connect() { connection = new SqlConnection(" server=192.168.1.2;database=ProjectManagementSystem;user ID=sa; password=sa"); connection.Open(); cmd = new SqlCommand("dbo.select_StudentDemo", connection); cmd.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(ds); // Binding Values To DropDownList //******************************* ddl_StudentName.DataSource = ds; ddl_StudentName.DataTextField = "studentname"; ddl_StudentName.DataValueField = "studentid"; ddl_StudentName.DataBind(); // Binding Values To DropDownList //******************************* lb_Name.DataSource = ds; lb_Name.DataTextField = "studentname"; lb_Name.DataValueField = "studentid"; lb_Name.DataBind(); // Binding Values To Radio Button List //************************************ rbtnlist_Name.DataSource = ds; rbtnlist_Name.DataTextField = "studentname"; rbtnlist_Name.DataValueField = "studentid"; rbtnlist_Name.DataBind(); // Binding Values To Radio Button List //************************************ btlist_Name.DataSource = ds; btlist_Name.DataTextField = "studentname"; btlist_Name.DataValueField = "studentid"; btlist_Name.DataBind(); cbl_Name.DataSource = ds; cbl_Name.DataTextField = "studentname"; cbl_Name.DataValueField = "studentid"; cbl_Name.DataBind(); }}