GridView手動綁定Oracle資料庫

←手機掃碼閱讀火星人 @ 2014-03-12 , reply:0

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();
}
}
}

Tags:

[火星人 ] GridView手動綁定Oracle資料庫已經有344次圍觀