DataSet离线数据集

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            using (SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=master;User ID=sa;Password=123456;"))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "select waterwork from Table_1 where othersnum=@num";
                    cmd.Parameters.Add(new SqlParameter("@num", textBox1.Text));
                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            string work = reader.GetString(0);
                            MessageBox.Show(work);
                        }
                    }
                }
            }
        }

        private void btnDataSet1_Click(object sender, RoutedEventArgs e)
        {
            using(SqlConnection conn=new SqlConnection ("Data Source=.;Initial Catalog=master;User ID=sa;Password=123456;"))
            {
                using(SqlCommand cmd=conn.CreateCommand())
                {
                    cmd.CommandText = "select * from Table_1";
                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                    DataSet dataset = new DataSet();
                    adapter.Fill(dataset);
                    //foreach(DataRow row in dataset.Tables[0].Rows)
                    //{
                    //    int waternum = (int)row["waterwork"];
                    //    MessageBox.Show(waternum.ToString());
                    //}
                    DataTable table = dataset.Tables[0];
                    DataRowCollection rows = table.Rows;
                    for (int i = 0; i < rows.Count;i++ )
                    {
                        DataRow r = rows[i];
                        string waternum = (string)r["waterwork"];
                        MessageBox.Show(waternum);
                    }
                }
            }
        }