GridView手動綁定Oracle數據庫

GridView手動綁定Oracle數據庫

1. using System;
2. using System.Collections.Generic;
3. using System.Linq;
4. using System.Web;
5. using System.Web.UI;
6. using System.Web.UI.WebControls;
7. using System.Data.OracleClient;
8. using System.Data;
10. namespace work1.sysconfig
11. {
12. public partial class DepartmentMgr : System.Web.UI.Page
13. {
14. protected void Page_Load(object sender, EventArgs e)
15. {
16. if (!IsPostBack)
17. {
18. BindData();
19. }
20. }
22. protected void BindData()
23. {
24. string conStr="Data Source=emsmms;Persist Security Info=True;User ID=emsmms;Password=emsmms123;Unicode=True";
25. OracleConnection conn=new OracleConnection(conStr);
26. string QueryStr = "select * from T_department";
27. OracleDataAdapter adapter = new OracleDataAdapter(QueryStr, conn);
28. DataSet ds = new DataSet();
29. adapter.Fill(ds);
30. GridView1.DataSource = ds.Tables[0];
31. GridView1.DataKeyNames = new string[] { "id" };
32. GridView1.DataBind();
33. }
34. }
35. }