菜鸟学习c#数据库之利用SqlDataAdatper填充dataset

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace ConsoleApplication3
{
    class Program
    {
        static void Main(string[] args)
        {
           string strCon="server=(local);database=northwind;uid=sa;pwd=123456";
            string select="SELECT *FROM Products";
            SqlConnection conn=new SqlConnection(strCon);
            SqlDataAdapter da=new SqlDataAdapter(select,conn);
            DataSet ds=new DataSet();//内存中的数据集合区
            da.Fill(ds,"Customers");
            foreach(DataRow row in ds.Tables["Customers"].Rows)
                Console.WriteLine("'{0}'from{1}",row[0],row[1]);
           

           
           
            Console.ReadLine();

        }
      
      
    }
  
}