<% @PageLanguage = " C# " %>
<% @ImportNamespace = " System.Data " %>
<% @ImportNamespace = " System.Data.OleDb " %>
-------------------------------------------
<% @ImportNamespace = " System.Data.SqlClient " %>
< ScriptLanguage = " c# " Runat = " Server " >
OleDbDataReaderdr;

Stringmyconnstring = " Provider=Microsoft.Jet.OLEDB.4.0;DataSource= " + Server.MapPath( " . " ) + " ..\mdb " ;
string sql = " .. "
OleDbConnectionmy_conn = new OleDbConnection(myconnstring);
OleDbCommandmy_comm = new OleDbCommand(sql,my_conn);
my_comm.Connection.Open();
dr = my_comm.ExecuteReader();
// DataGriddg
dg.DataSource = dr
dg.DataBind();
</ Script >
< head >
<% while (dr.Read())
... {;}
%>
</ head >
DataSetDataAdapter
DataAdapter是與DataSet配套使用的
OleDbDataAdaptermy_adapter = new OleDbDataAdapter();
-------------------------------------------------
SqlDataAdaptermy_sqladapter = new SqlDataAdapter();
my_adapter.SelectCommand.Connection = my_conn;
或
my_adapter.UpdateCommand.Connection = my_conn;
my_adapter.DeleteCommand.Connection = my_conn;
my_adapter.InsertCommand.Connection = my_conn;
如果需要執行Sql語句，那么還必須給相應的CommandText屬性賦值。
my_adapter.SelectCommand.CommandText = strSelect;
my_adapter.UpdateCommand.CommandText = strUpdate;
my_adapter.InsertCommand.CommandText = strInsert;
my_adapter.DeleteCommand.CommandText = strDelete;
如果只是查詢數據庫，則可以建立DataAdapter實例時就完成上述工作
OleDbDataAdapterMyAdapter = new OleDbDataAdapter(sql,my_conn);
DataSetds = new DataSet();
OleDbConnectionmy_conn = new OleDbConnection(myconnstring);
OleDbDataAdaptermy_adapter = new OleDbDataAdapter(sql,my_conn);
my_adapter.fill(ds, " score " );
DataGridscore;
score.DataSource = ds.Table[ " score " ].Defaultview;
score.DataBind();
// InsertCommand
DataRowdr = ds.Table[ " Score " ].NewRow();
dr[ " name " ] = ..

ds.Tables[ " Score " ].Rows.Add(dr);
// update
DataAdapter.Update(ds, " Score " );
// modify
DataRowdr = ds.Tables[ " Score " ].Rows[ 0 ];
dr[ " name " ] = ;
// Delete
DataRowdr = ds.Talbes[ " Score " ].Rows[ 0 ];
dr.Delete();
// 注:
OleDbConnectionmy_conn = new OleDbConnection(myconnstring);
OleDbDataAdaptermy_adapter = new OleDbDataAdapter(sql,my_conn);
OleDbCommandBuildercustCB = new OleDbCommandBuilder(my_adapter); // DataAdapter在數據發生改變時，并不能自動產生(Transact-SQL),所以一定要使用CommandBuilder,它能自動產生Sql語句，！就此一步
RejectChanges是DataSet,DataTable,DataRow共有的方法
使操作對象拒絕已經發生的改變，使數據復員
if (DataSet.HasErrors)
... {

DataSet.RejectChanges();
}
else ... {DataSet.AcceptChanges();}
----------------------------------------------------------------------------------------------------------------------------------
DataReader -> DataTable
public static DataTableConvertDataReaderToDataTable(SqlDataReaderdataReader)
... {
/**/ /**/ /**/ /// 定義DataTable和模式
DataTabledatatable = new DataTable();
DataTableschemaTable = dataReader.GetSchemaTable(); // 導入一個數據表的表結構

try
... { /**/ /**/ /**/ /// 動態添加表的數據列
foreach (DataRowmyRow in schemaTable.Rows)
... {
DataColumnmyDataColumn = new DataColumn();
myDataColumn.DataType = myRow.GetType();
myDataColumn.ColumnName = myRow[ 0 ].ToString();
datatable.Columns.Add(myDataColumn);
}

/**/ /**/ /**/ /// 添加表的數據
while (dataReader.Read())
... {
DataRowmyDataRow = datatable.NewRow();
for ( int i = 0 ;i < schemaTable.Rows.Count;i ++ )
... {
myDataRow[i] = dataReader[i].ToString();
}
datatable.Rows.Add(myDataRow);
myDataRow = null ;
}
schemaTable = null ;

/**/ /**/ /**/ /// 關閉數據讀取器
dataReader.Close();
return datatable;
}
catch (Exceptionex)
... {
/**/ /**/ /**/ /// 拋出類型轉換錯誤
SystemError.SystemLog(ex.Message);
throw new Exception(ex.Message,ex);
}
}
}
}