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