List Controls from Different Collections
This coding is for List Controls from Different Collections
----------------------------------------------------------------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();
}
}
