sql dataset

 //建立连接
            SqlConnection connection = new SqlConnection(@"Data Source=localhost;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("what do you see:{0}",dataset.Tables["TradeTree"].Rows[3]["Name"]);

            connection.Close();