源码如下：
-
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();
-
}
-
}
-
}
