datatable 在.net2.0的增强
DataTable的数据使用DataReader方式读取
DataTable table = new DataTable(”Employees”);
adapter.Fill(table);
DataTableReader dtReader = table.CreateDataReader();
while (dtReader.Read())
{
str = dtReader.GetValue(0).ToString();
}
合并数据,序列化(1.1)
DataTableReader dtReader = dataset.CreateDataReader();
// dtRader会读取DataSet中所有DataTable的数据.
// 可以merge多个data table
dtTable1.Merge(dtTable2);
// Serialize的支持,从而可以在web method中传递DataTable
DataTable table = new DataTable();
table.Load(reader, LoadOption.OverwriteChanges);
// 设置序列化的格式,default为SerializationFormat.Xml
table.RemotingFormat = SerializationFormat.Binary;
BinaryFormatter bf = new BinaryFormatter();
FileStream fs = new FileStream(”Data.txt”, FileMode.OpenOrCreate);
bf.Serialize(fs, table);
DataTable table = new DataTable(”Employees”);
adapter.Fill(table);
DataTableReader dtReader = table.CreateDataReader();
while (dtReader.Read())
{
str = dtReader.GetValue(0).ToString();
}
合并数据,序列化(1.1)
DataTableReader dtReader = dataset.CreateDataReader();
// dtRader会读取DataSet中所有DataTable的数据.
// 可以merge多个data table
dtTable1.Merge(dtTable2);
// Serialize的支持,从而可以在web method中传递DataTable
DataTable table = new DataTable();
table.Load(reader, LoadOption.OverwriteChanges);
// 设置序列化的格式,default为SerializationFormat.Xml
table.RemotingFormat = SerializationFormat.Binary;
BinaryFormatter bf = new BinaryFormatter();
FileStream fs = new FileStream(”Data.txt”, FileMode.OpenOrCreate);
bf.Serialize(fs, table);