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