OleDb 连接 SQL 代码

 //OleDbConnection connection = new OleDbConnection(@"Data Source = (local);Integrated Security=SSPI;"+"Initial Catalog = NorthWind");
            OleDbConnection connection = new OleDbConnection(@"Provider=SQLOLEDB;Data Source=(local);initial catalog=zl;user id=admin;pwd=admin");
            connection.Open();
            //OleDbCommand command = connection.CreateCommand();
            //command.CommandText = "select CatagoryID,CatagoryName from Categories";
            OleDbDataAdapter adapter=new OleDbDataAdapter("select id,name from TradeTree",connection);

            OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);

            DataSet dataSet = new DataSet();
            adapter.Fill(dataSet, "TradeTree");
            Console.WriteLine("name before change:{0}", dataSet.Tables["TradeTree"].Rows[1]["Name"]);
            connection.Close();