DataSet读取数据

using System.Data;
using System.Data.SqlClient;

namespace ConsoleApplication3
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection thisConn = new SqlConnection(@"Server=.\Nie;uid=sa;pwd=111;Database=MyNorthwind");


            SqlDataAdapter thisAdapter = new SqlDataAdapter("select customerId,Address from Customers",
                                                             thisConn);
            DataSet thisDataSet = new DataSet();
            thisAdapter.Fill(thisDataSet, "customers");
            foreach (DataRow theRow in thisDataSet.Tables["Customers"].Rows)
            {
                Console.WriteLine(theRow["customerId"] + "\t" + theRow["Address"]);
            }
            thisConn.Close();
            Console.Write("Program finished,press any key to Continue.");
            Console.ReadLine();

        }
    }
}