DataSet代码

最新推荐文章于 2024-07-31 18:14:50 发布

原创最新推荐文章于 2024-07-31 18:14:50 发布 · 449 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#dataset #security #command

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