Cascading Drop Listings

Di Silva

I am very new to the field of programming. I am still training on .NET technologies but not sure if I have got the concept. But now I am required to complete a project.

I am working on a online school fee paymment projects with 3 tier architecture.

The three modules are Admin, School Accountant and Parent.

The Admin would add the accountants for each school and the account for the specific school would need to add the class and students of his school.

I was able to proceed a little bit from an old project(Copy & paste). However I am not able to proceed with creating a two drop down lists.

I am needing to create a webpage where it will show to the account to select the class and after selecting the class, adding the each student details.

My Source page is :

<%@ Page Title="" Language="C#" MasterPageFile="~/Accountant/Accountant.Master" AutoEventWireup="true" CodeBehind="AddStudent.aspx.cs" Inherits="OnlineFeePayment.Accountant.AddStudent" %>

Add Students

--------------------------------------

I was able to create one dropdown list using the following code:

protected void Page_Load(object sender, EventArgs e)

{

if(!IsPostBack)

{

DataSet D = StateHelper.SelectSchool();

DropDownList1.DataSource = D;

DropDownList1.DataTextField = "School_Complete";

DropDownList1.DataValueField = "School_Id";

DropDownList1.DataBind();

}

protected void Button1_Click(object sender, EventArgs e)

{

Class C=new Class();

C.Class_Name = TextBox1.Text;

C.School_Id = int.Parse(DropDownList1.SelectedItem.Value);

ClassHelper.AddClass(C);

}

---------------------------------------------------------

namespace BO

{

public class Student

{

public int Student_Id { get; set; }

public string Student_Name { get; set; }

public string Student_Image { get; set; }

public int Class_Id { get; set; }

}

----------------------------------------------------------

namespace DAL

{

public class StateHelper

{

public static void AddState(State S)

{

DataManager.InsertUpdateDelete("ADDSTATE", S.State_Name);

}

public static DataSet SelectState()

{

DataSet S1 = DataManager.GetDataSet("SELECTSTATE");

return S1;

}

public static DataSet SelectDistrict()

{

DataSet S = DataManager.GetDataSet("SELECTDISTRICT");

return S;

}

public static DataSet SelectSchool()

{

DataSet S2 = DataManager.GetDataSet("SELECTSCHOOL");

return S2;

}

----------------------------------------

I was able to find few posts about cascading droplist however I was not able to understand how I could use it in my project.

Can someone please help me with the code to complete the 2 droplist with a little bit of explanation.?

Thanks in Advance.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jes Sie7y ago
I was working on a school project and used several cascading dropdownlist.

Below is what I did. Maybe you can get an idea from it:
void GetEnrolledGradeLvl()
       {
           string teacherId = lblTeacherID.Text;
           ddlGradeLvl.DataSource = LessonPlanDataAccess.GetEnrolledGradeLvl(teacherId);
           ddlGradeLvl.DataBind();
           ddlGradeLvl.Items.Insert(0, "Select");
       }

       private void GetEnrolledSubjects()
       {
           int GLId = Convert.ToInt32(ddlGradeLvl.SelectedValue);
           string teacherId = lblTeacherID.Text;
           ddlSubject.DataSource = LessonPlanDataAccess.GetEnrolledSubjects(GLId, teacherId);
           ddlSubject.DataBind();
           ddlSubject.Items.Insert(0, "Select");
       }

       protected void ddlGradeLvl_SelectedIndexChanged(object sender, EventArgs e)
       {
           if(ddlGradeLvl.SelectedIndex > 0)
           {
               GetEnrolledSubjects();
           }
           else
           {
               ddlSubject.SelectedIndex = 0;
           }
       }

       protected void ddlSubject_SelectedIndexChanged(object sender, EventArgs e)
       {
           if(ddlSubject.SelectedIndex > 0)
           {
               GetCoHeaderBySy();

           }
           else
           {
               ddlSY.SelectedIndex = 0;
               ddlWeekNo.SelectedIndex = 0;
           }
       }
Abhijeet Jadhav7y ago
Hi Di Silva,
Kindly follow the steps in below link to create a cascading dropdownlist:

https://youtu.be/cFQ5yGT4LTU