To Bind Two Or More Dropdown With Single Dataset In ASP.NET

  1. public partial class Default2: System.Web.UI.Page {  
  2.     string ConnStr = ConfigurationManager.ConnectionStrings["CRMConnectionString"].ToString();  
  3.     SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CRMConnectionString"].ToString());  
  4.     DataSet someDataSet = new DataSet();  
  5.     SqlDataAdapter adapt = new SqlDataAdapter();  
  6.     protected void Page_Load(object sender, EventArgs e) {  
  7.         if (!IsPostBack) {}  
  8.         binddataset();  
  9.         TopTeam();  
  10.     }  
  11.     public void binddataset() {  
  12.         con.Open();  
  13.         SqlCommand comm1 = new SqlCommand("select distinct Agentname from crm_agentname where status='Active'", con);  
  14.         SqlCommand comm2g = new SqlCommand("select distinct Teamname from crm_Teamname where status='Active'", con);  
  15.         SqlCommand comm3g = new SqlCommand("select distinct Locationname from crm_location where status='Active'", con);  
  16.         ///////////////////AGENTNAME  
  17.         someDataSet.Tables.Add("crm_agentname");  
  18.         adapt.SelectCommand = comm1;  
  19.         adapt.Fill(someDataSet.Tables["crm_agentname"]);  
  20.         ddlagent.DataTextField = "Agentname";  
  21.         ddlagent.DataValueField = "Agentname";  
  22.         ddlagent.DataSource = someDataSet.Tables["crm_agentname"];  
  23.         ddlagent.DataBind();  
  24.         ///////////////////Teamname  
  25.         someDataSet.Tables.Add("crm_Teamname");  
  26.         adapt.SelectCommand = comm2g;  
  27.         adapt.Fill(someDataSet.Tables["crm_Teamname"]);  
  28.         ddlteam.DataTextField = "Teamname";  
  29.         ddlteam.DataValueField = "Teamname";  
  30.         ddlteam.DataSource = someDataSet.Tables["crm_Teamname"];  
  31.         ddlteam.DataBind();  
  32.         ///////////////////Location  
  33.         someDataSet.Tables.Add("crm_location");  
  34.         adapt.SelectCommand = comm3g;  
  35.         adapt.Fill(someDataSet.Tables["crm_location"]);  
  36.         ddllocation.DataTextField = "Locationname";  
  37.         ddllocation.DataValueField = "Locationname";  
  38.         ddllocation.DataSource = someDataSet.Tables["crm_location"];  
  39.         ddllocation.DataBind();  
  40.         con.Close();  
  41.     }  
  42. }