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(objec t sender, EventArgs e)
{
strconn = new OleDbConnection ();
strconn.Connect ionString = "Provider=msdao ra.1; user id=payroll; password=payrol l; data source=payroll" ;
strconn.Open();
strsql = "select * from section";
OleDbCommand cmd = new OleDbCommand(st rsql, strconn);
OleDbDataReader reader = cmd.ExecuteRead er();
DdlSectionID.Da taValueField = "SectionID" ;
DdlSectionID.Da taSource = reader;
DdlSectionID.Da taBind();
reader.Close();
strconn.Close() ;

}
protected void DdlSectionID_Se lectedIndexChan ged(object sender, EventArgs e)
{
strconn = new OleDbConnection ();
strconn.Connect ionString = "Provider=msdao ra.1; user id=payroll; password=payrol l; data source=payroll" ;
strconn.Open();
strsql = "select * from Employee where SectionID=" + DdlSectionID.Te xt + " ";
OleDbCommand cmd1 = new OleDbCommand(st rsql, strconn);
OleDbDataReader reader1 = cmd1.ExecuteRea der();
//DdlBillUnit.Dat aValueField = "BillUnit";
DdlBillUnit.Dat aSource = reader1;
DdlBillUnit.Dat aBind();
DdlSectionID.Se lectedIndex = 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.Te xt + "' ";