01.protected void Page_Load(object sender, EventArgs e)
02. {
03.
04. string query = "SELECT [ประเภทรายงาน] FROM [menu]";
05. DataTable dt = new DataTable();
06. string connetionString = null;
07.
08. string strPath = System.IO.Directory.GetCurrentDirectory();
09. connetionString = "Provider=Microsoft.ACE.OLEDB.12.0;"
10. + "Data Source=" + strPath + "\\RealDatabase.accdb;"
11. + "Persist Security Info=False;";
12. OleDbCommand cmd = new OleDbCommand(query);
13. OleDbConnection connection = new OleDbConnection(connetionString);
14. OleDbDataAdapter da = new OleDbDataAdapter();
15. cmd.CommandType = CommandType.Text;
16. cmd.Connection = connection;
17. da.SelectCommand = cmd;
18. da.Fill(dt);
19.
20. DropDownList1.DataSource = dt;
21. DropDownList1.DataTextField = "ประเภทรายงาน";
22. DropDownList1.DataValueField = "ประเภทรายงาน";
23. DropDownList1.DataBind();
24. DropDownList1.Items.Insert(0, "ประเภทรายงาน");
25. }
