OLEDBConnection myconnection;
MyConnection = New OLEDBCONNECTION ("provider = microsoft.jet.Oledb.4.0; data source =" server.mappath ("aa.mdb"));
public void droplist1 () {OleDbDataAdapter myCommand = new OleDbDataAdapter ( "select * from class8 where class9 =" kkk1 [0], myConnection); DataSet ds = new DataSet (); myCommand.Fill (ds, "class8"); DataList1 . DataSource = ds.tables ["class8"]. Defaultview; datalist1.databind (); myconnection.close ();}