DataGrid绑定DropDownList

 目的:从tab_A表中查出数据,DropDownList帮定Tab_B表的第二列, 数据库采用Access.

代码如下:

         private   void  Page_Load( object  sender, System.EventArgs e)
        {
             if ( ! IsPostBack)
            {
                Bind();
            }
        }

         private   void  Bind()
        {
            OleDbConnection con = new  OleDbConnection(System.Configuration.ConfigurationSettings.AppSettings[ " AccessConnection " ]);
             string  sql = " select id,text from tab_A " ;
            OleDbDataAdapter oda = new  OleDbDataAdapter(sql,con);
            DataSet ds = new  DataSet();
            oda.Fill(ds);

            DataGrid1.DataSource = ds;
            DataGrid1.DataBind();
            
            oda.Dispose();
            con.Close();
            con.Dispose();
        }
         private   void  DataGrid1_ItemDataBound( object  sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
        {
            OleDbConnection con = new  OleDbConnection(System.Configuration.ConfigurationSettings.AppSettings[ " AccessConnection " ]);
             string  sql = " select id,text from tab_B " ;
            OleDbDataAdapter oda = new  OleDbDataAdapter(sql,con);
            DataSet ds = new  DataSet();
            oda.Fill(ds);

             if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                DropDownList ddl = (DropDownList)e.Item.FindControl( " ddl " );
                ddl.DataSource = ds;
                ddl.DataTextField = " text " ;
                ddl.DataValueField = " id " ;
                ddl.SelectedIndex = 1 ;
                ddl.DataBind();

                 string  text = Convert.ToString(DataBinder.Eval(e.Item.DataItem, " text " ));
                e.Item.Cells[ 2 ].Text = text;
            }
            oda.Dispose();
            con.Close();
            con.Dispose();
        }

后台数据库连接:

< appSettings >
     < add key = " AccessConnection "  value = " Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:db1.mdb; " />
</ appSettings >