using?System;
using?System.Data;
using?System.Configuration;
using?System.Linq;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.HtmlControls;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.xml.Linq;
using?System.Data.OracleClient;
using?System.IO;
using?System.Text;

public?partial?class?_Default?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????string?sql;
????????if?（!Page.IsPostBack）
????????{
????????????sql?=?“select?card_typeremarks?from?import_code_card_type?“;
????????????DropDownList1.Items.Clear（）;
????????????wirte_dropdownlist（DropDownList1?sql?“1“）;
????????}
????}

????#region?數據庫連接函數
????public?static?OracleConnection?ora_conn（string?con_str）
????{
????????return?new?OracleConnection（ConfigurationSettings.AppSettings[con_str]）;
????}
????#endregion


????#region?寫下拉框控件函數（動態）
????public?static?void?wirte_dropdownlist（DropDownList?e?string?sql_str?string?all_flag）
????{
????????OracleCommand?cmd;
????????OracleConnection?connection?=?ora_conn（“connectionstrings“）;
????????cmd?=?new?OracleCommand（sql_str?connection）;
????????connection.Open（）;
????????OracleDataReader?dr?=?cmd.ExecuteReader（）;
????????e.Items.Add（new?ListItem（“==請選擇==“?““））;
????????while?（dr.Read（））
????????{
????????????e.Items.Add（new?ListItem（dr[1].ToString（）?dr[0].ToString（）））;
????????}
????????dr.Close（）;
????????connection.Close（）;
????}
????#endregion
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-01-22?09:14??dropdownlist綁定數據庫\
?????文件?????????516??2013-01-22?09:13??dropdownlist綁定數據庫\Default.aspx
?????文件????????1589??2013-01-22?09:13??dropdownlist綁定數據庫\Default.aspx.cs
?????文件?????????575??2012-09-25?15:20??dropdownlist綁定數據庫\web.config