遍历表格的内容并用控制台格式化显示

来源：互联网发布：linux虚拟机配置ip 编辑：程序博客网时间：2024/04/29 18:25

/*
* Created by SharpDevelop.
* User: Administrator
* Date: 2006-1-30
* Time: 14:34
* Using C#
* To change this template use Tools | Options | Coding | Edit Standard Headers.
*/
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
namespace dbcon
{
class MainClass
{
public static void Main(string[] args)
{
//数据库连接字符串,以下是我自己的数据库连接字符串
   string strcon="server=CAU-HOTPHEN;uid=sa;pwd=111111;database=master";
   SqlConnection con=new SqlConnection(strcon);
   try
   {
    con.Open();
    Console.WriteLine("Connect Success");
    string strSql="select * from dbo.spt_values ";//数据库查询字符串
    SqlDataAdapter da=new SqlDataAdapter(strSql,con);
    DataSet ds=new DataSet();
    da.Fill(ds);//不用con.Open(),DataAdapter会根据需要自动打开或关闭连接
    Console.WriteLine("数据库连接成功");
    Console.WriteLine("总共 {0} 条记录",ds.Tables[0].Rows.Count);
    foreach(DataColumn col in ds.Tables[0].Columns)
    {
     Console.Write("{0}/t",col.ColumnName);//显示列名
    }
    Console.Write("/n");
    foreach(DataRow dr in ds.Tables[0].Rows)
    {
     foreach(DataColumn col in ds.Tables[0].Columns)
     {
      Console.Write("{0}/t",dr[col.ColumnName]);//显示表格纪录内容
     }
     Console.Write("/n");
    }
   }
   catch(Exception e)
   {
    Console.WriteLine(e.Message);
   }
   Console.Read();
}
}
}