DataSet代码

//SqlConnection connection = new SqlConnection(@"Data Source=(local);Integrated Security=SSPI;"+"Initial Catalog=NorthWind");
            //connection.Open();
            //SqlCommand command = connection.CreateCommand();
            //command.CommandText = "select CategoryID,CategoryName from Categories";

            //SqlDataReader reader = command.ExecuteReader();

            //while (reader.Read())
            //{
            //    Console.WriteLine("what do you see:{0}/t{1}",reader["CategoryID"],reader["CategoryName"]);
            //}
            //reader.Close();
            //connection.Close();  

            SqlConnection connection = new SqlConnection(@"Data Source=(local);Initial Catalog=zl;user id = admin;pwd=admin");
            connection.Open();
            SqlDataAdapter adapter = new SqlDataAdapter("select * from TradeTree",connection);
            SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
            DataSet dataSet = new DataSet();

            adapter.Fill(dataSet,"TradeTree");
            Console.WriteLine("{0}", dataSet.Tables["TradeTree"].Rows[1]["ID"]);
            dataSet.Tables["TradeTree"].Rows[1]["name"] = "MyChange";
            Console.WriteLine("{0}",dataSet.Tables["TradeTree"].Rows[1]["name"]);
            connection.Close();