C#编程-69：DataReader和DataSet读取数据库内容示例

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace SQLLastTest
{
    class Program
    {
        static void Main(string[] args)
        {
            //连接字符串
            SqlConnectionStringBuilder sqlsb = new SqlConnectionStringBuilder();
            sqlsb.DataSource = @"(localdb)\Projects";
            sqlsb.IntegratedSecurity = true;
            sqlsb.InitialCatalog = "company";
            //连接数据库，采用try...catch形式
            SqlConnection sqlcon = new SqlConnection(sqlsb.ToString());
            try
            {
                sqlcon.Open();
                string sql = "select * from clerk";
                SqlCommand sqlcom = new SqlCommand(sql,sqlcon);
                //使用SqlDataReader打印表信息
                SqlDataReader sqlread = sqlcom.ExecuteReader();
                Console.WriteLine("使用SqlDataReader打印表信息：");              
                for (int i = 0; i < sqlread.FieldCount; i++)
                {
                    Console.Write(sqlread.GetName(i)+"\t");
                }
                Console.WriteLine();
                while (sqlread.Read())
                {
                    for (int i = 0; i < sqlread.FieldCount; i++)
                    {
                        Console.Write(sqlread[i].ToString()+"\t");
                    }
                    Console.WriteLine();
                }
                sqlread.Close();
                //使用DataSet打印表信息
                Console.WriteLine("使用DataSet打印表信息:");
                SqlDataAdapter sqladp = new SqlDataAdapter(sql,sqlcon);
                DataSet dataSet = new DataSet();
                sqladp.Fill(dataSet,"clerk");
                foreach (DataTable table in dataSet.Tables)
                {
                    foreach (DataColumn col in table.Columns)
                    {
                        Console.Write(col.ColumnName+"\t");
                    }
                    Console.WriteLine();
                    foreach (DataRow row in table.Rows)
                    {
                        foreach (DataColumn col in table.Columns)
                        {
                            Console.Write(row[col]+"\t");
                        }
                        Console.WriteLine();
                    }
                }
            }
            catch(Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            finally
            {
                sqlcon.Close();
            }
            Console.ReadKey();
        }
    }
}