DB2DataAdapter + GridView 使用方法

 
DB2DataAdapter + GridView 使用方法
 

   default.aspx.cs
 
   using System;
   using System.Collections.Generic;
   using System.Web;
   using System.Web.UI;
   using System.Web.UI.WebControls;
   using System.Data;
   using IBM.Data.DB2;
 
   private void DB2DataAdapterConnection()
   {
 
      String ConnectionString = "Server=<Host Name>;Database=<Database Name>;UID=<Account ID>;PWD=<Account Password>";
      DB2Connection conn = new DB2Connection(ConnectionString);
      conn.Open();
 
      DataSet ds = new DataSet();
 
      String SQLStatement = "SELECT * FROM STAFF";
 
      DB2Command dcommand = new DB2Command(SQLStatement, conn);
 
      DB2DataAdapter da = new DB2DataAdapter();
      da.SelectCommand = dcommand;
 
      da.Fill(ds);
 
      GridView1.DataSource = ds.Tables[0];
      GridView1.DataBind();
 
      da.Dispose();
      ds.Dispose();
      dcommand.Dispose();
      conn.Close();
 
   }