目的:从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();
}
{
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 >
< add key = " AccessConnection " value = " Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:db1.mdb; " />
</ appSettings >