System.Data.OracleClient – OracleDataAdapter + GridView 使用方法
using System.Data.OracleClient; using System.Data; private void DataAdapter() { OracleConnection Conn = new OracleConnection(); Conn.ConnectionString = "User Id=<User ID>;Password=<User Password>; Data Source=<Server IP>; Unicode=True"; Conn.Open(); string sql = "SELECT * FROM Test"; OracleCommand cmd = new OracleCommand(sql, Conn); DataSet ds = new DataSet(); OracleDataAdapter da = new OracleDataAdapter(); da.SelectCommand = cmd; da.Fill(ds); GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); Conn.Close(); Conn.Dispose(); } |