System.Data.OracleClient – OracleDataAdapter + GridView 使用方法

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