//建立连接
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();