//绑定DropDownList private void DDL()
...{
OracleConnection conn = new OracleConnection("Data Source=caora;User ID=gufei;Password=gufei;"); conn.Open(); OracleDataAdapter oradar = new OracleDataAdapter("select PRODNAME from PRODUCTION where UNITBASIC_ID=(select UNITBASIC_ID from UNITBASIC where DYEAR='" + DYEAR + "' and UNIT_ID=(select UNIT_ID from UNIT where UNITID='" + UserName + "'))", conn); oradar.SelectCommand.CommandType = CommandType.Text; DataSet da = new DataSet(); oradar.Fill(da, "PRODUCTION"); DropDownList1.DataSource = da.Tables["PRODUCTION"].DefaultView; DropDownList1.DataTextField = "PRODNAME"; DropDownList1.DataBind(); conn.Close();
}
//GridView数据绑定 private void GV1() ...{ OracleConnection conn = new OracleConnection("Data Source=caora;User ID=gufei;Password=gufei;"); conn.Open(); OracleDataAdapter oradar = new OracleDataAdapter("select PRODNAME from PRODUCTION where UNITBASIC_ID=(select UNITBASIC_ID from UNITBASIC where DYEAR='" + DYEAR + "' and UNIT_ID=(select UNIT_ID from UNIT where UNITID='" + UserName + "'))", conn); DataSet da = new DataSet(); oradar.Fill(da, "PRODUCTION"); GridView1.DataSource = da.Tables["PRODUCTION"].DefaultView; GridView1.DataBind(); conn.Close(); }