related to drop down list

[jyoti pandey]

sir i have taken to drop down list and i want to select any data in drop down list1,
accordind to this data display related data in drop down list2.
how i can do this i am working in asp.net with c#
the coding i have done is
protected void Page_Load(object sender, EventArgs e)
{
strconn = new OleDbConnection();
strconn.ConnectionString = "Provider=msdaora.1; user id=payroll; password=payroll; data source=payroll";
strconn.Open();
strsql = "select * from section";
OleDbCommand cmd = new OleDbCommand(strsql, strconn);
OleDbDataReader reader = cmd.ExecuteReader();
DdlSectionID.DataValueField = "SectionID";
DdlSectionID.DataSource = reader;
DdlSectionID.DataBind();
reader.Close();
strconn.Close();

}
protected void DdlSectionID_SelectedIndexChanged(object sender, EventArgs e)
{
strconn = new OleDbConnection();
strconn.ConnectionString = "Provider=msdaora.1; user id=payroll; password=payroll; data source=payroll";
strconn.Open();
strsql = "select * from Employee where SectionID=" + DdlSectionID.Text + " ";
OleDbCommand cmd1 = new OleDbCommand(strsql, strconn);
OleDbDataReader reader1 = cmd1.ExecuteReader();
//DdlBillUnit.DataValueField = "BillUnit";
DdlBillUnit.DataSource = reader1;
DdlBillUnit.DataBind();
DdlSectionID.SelectedIndex = 0;
reader1.Close();
strconn.Close();
}
were i doing any mistake plz help me

[kenobewan]

I believe you need to change this line:
strsql = "select * from Employee where SectionID='" + DdlSectionID.Text + "' ";