ADO.NET 2.0 Dataset和Datatable 新功能新特性-阿里云开发者社区

ADO.NET 2.0 Dataset和Datatable 新功能新特性

2017-11-26 987

版权

本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

简介：

1.新的索引引擎更快的执行效率
下面这段代码在2003中需要157秒，在2005中只要11秒就可以完成：

DataSet ds = new DataSet();

ds.Tables.Add( " BigTable " );

ds.Tables[ 0 ].Columns.Add( " ID " , Type.GetType( " System.Int32 " ));

ds.Tables[ 0 ].Columns[ " ID " ].Unique = true ;

ds.Tables[ 0 ].Columns.Add( " Value " , Type.GetType( " System.Int32 " ));

Cursor.Current = Cursors.WaitCursor;

DateTime datBegin = DateTime.Now;

Random rand = new Random();

int i, intValue;

DataRow dr;

for (i = 1 ; i <= 500000 ; i ++ )

{

try

{

intValue = rand.Next();

dr = ds.Tables[0].NewRow();

dr["ID"] = intValue;

dr["Value"] = intValue;

ds.Tables[0].Rows.Add(dr);

}

catch { }

}

Cursor.Current = Cursors.Default;

MessageBox.Show( " Elapsed Time: " + (DateTime.Now - datBegin).Seconds.ToString());

MessageBox.Show( " count = " + ds.Tables[ 0 ].Rows.Count.ToString());

2.Dataset可以序列化为二进制文件

string connstr = " server=(local);database=northwind;integrated security=true;async=true " ;

DataSet ds = new DataSet();

SqlDataAdapter dadpt = new SqlDataAdapter( " select * from [order details] " , connstr);

dadpt.Fill(ds);

BinaryFormatter bf = new BinaryFormatter();

FileStream fs = new FileStream( @" c:\xml1.txt " ,FileMode.OpenOrCreate);

ds.RemotingFormat = SerializationFormat.Binary;

bf.Serialize(fs,ds);

3.更独立的Datatable
DataTable Write XML

string connstr = " server=(local);database=northwind;integrated security=true;async=true " ;

SqlDataAdapter dadpt = new SqlDataAdapter( " select * from [order details] " , connstr);

DataTable dt = new DataTable( " Customer " );

dadpt.Fill(dt);

dt.WriteXml( @" c:\DataTable.xml " , true );

dt.WriteXmlSchema( @" c:\DataTableSchema.xml " );

DataTable Read XML

StreamReader sr = new StreamReader( @" C:\DataTableSchema.xml " );

DataTable dt = new DataTable();

dt.ReadXmlSchema(sr);

dt.ReadXml( new StreamReader( @" c:\dataTable.xml " ));

this .dataGridView1.DataSource = dt;

DataTable Merge

string connstr = " server=(local);database=northwind;integrated security=true;async=true " ;

SqlDataAdapter dadpt = new SqlDataAdapter( " select * from customers " , connstr);

DataTable dt = new DataTable( " Customer " );

dadpt.Fill(dt);

SqlDataAdapter dadpt1 = new SqlDataAdapter( " select * from customers " , connstr);

DataTable dt1 = new DataTable( " Customer1 " );

dadpt1.Fill(dt1);

dt.Merge(dt1);

this .dataGridView1.DataSource = dt;

DataTable Load DataReader

string connstr = " server=(local);database=northwind;integrated security=true;async=true " ;

SqlConnection conn = new SqlConnection(connstr);

conn.Open();

SqlCommand cmd = new SqlCommand( " select * from [order details] " , conn);

SqlDataReader dr = cmd.ExecuteReader();

DataTable dt = new DataTable( " Customer " );

dt.Load(dr);

this .dataGridView1.DataSource = dt;

本文转自高海东博客园博客，原文链接：http://www.cnblogs.com/ghd258/archive/2005/10/30/264820.html，如需转载请自行联系原作者

ADO.NET 2.0 Dataset和Datatable 新功能新特性

热门文章

最新文章

相关电子书