DataTable在.net2.0中的增强

dataTable可从datareader中读取数据

             using  (SqlConnection connection  =   new  SqlConnection(connectionString))

             ... {

                connection.Open();

                // Create a Command

                using (SqlCommand command = new SqlCommand(Sql, connection))

                ...{

                    // Call ExecuteReader to return a DataReader

                    using (SqlDataReader reader = command.ExecuteReader())

                    ...{

                        // Create a DataTable

                        DataTable table = new DataTable();

                        // Fill DataTable

                        table.Load(reader, LoadOption.OverwriteChanges);

                        // Display data in GridView

                        dataGridView1.DataSource = table;

                    }

                }

            }

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