using System;

 using System.Collections.Generic;

 using System.Linq;

 using System.Text;

 using System.Data;

 using System.Data.SqlClient;

 namespace adapterTest

 {

     class Program{

         static void Main(string[] args){

             //创建数据库连接

             SqlConnection conn = new SqlConnection("Data Source=HZ-PC;Initial Catalog=mydb;Persist Security Info=True;User ID=sa;Password=123");

             //创建数据适配器

             SqlDataAdapter da = new SqlDataAdapter("select *from db_line;", conn);

             //创建空数据集

             DataSet ds = new DataSet();

             //使用数据适配器的Fill方法填充数据集

             da.Fill(ds,"db_line");

             //从表集合中取出表db_line

             DataTable dt = ds.Tables["db_line"];

             //嵌套循环，输出每行的每列

             foreach (DataRow row in dt.Rows) {

                 foreach(DataColumn col in dt.Columns){

                     Console.Write("{0}   ",row[col]);

                 }

                 Console.WriteLine();

                 Console.WriteLine("".PadLeft(,'='));

             }

             int age = (int)HZ.age;

             Console.WriteLine(HZ.sex);

         }

         public enum HZ{

             age=,

             height=,

             sex='M',

         }

     }

 }