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


}
}


Comments

No responses found. Be the first to comment...


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: