GridView手动绑定Oracle数据库
GridView手动绑定Oracle数据库
GridView手动绑定Oracle数据库
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Web;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Data.OracleClient;
- using System.Data;
- namespace work1.sysconfig
- {
- public partial class DepartmentMgr : System.Web.UI.Page
- {
- protected void Page_Load(object sender, EventArgs e)
- {
- if (!IsPostBack)
- {
- BindData();
- }
- }
- protected void BindData()
- {
- string conStr="Data Source=emsmms;Persist Security Info=True;User ID=emsmms;Password=emsmms123;Unicode=True";
- OracleConnection conn=new OracleConnection(conStr);
- string QueryStr = "select * from T_department";
- OracleDataAdapter adapter = new OracleDataAdapter(QueryStr, conn);
- DataSet ds = new DataSet();
- adapter.Fill(ds);
- GridView1.DataSource = ds.Tables[0];
- GridView1.DataKeyNames = new string[] { "id" };
- GridView1.DataBind();
- }
- }
- }
评论暂时关闭