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