using System;
using System.Data.SqlClient;
namespace sqlserver2005
{
class showall
{
public static void show()
{
//创建数据库连接,三者选一,不需要设置 ODBC 数据源
SqlConnection aConnection = new SqlConnection(@"Data
Source=(local);Initial Catalog=hotel;Integrated Security=SSPI");
//hotel 为数据源名
//SqlConnection aConnection = new
SqlConnection("server=JLU-LYLEGEND13\SQLEXPRESS;Initial
Catalog=hotel;Integrated Security=SSPI"); //hotel 为数据源名,
JLU-LYLEGEND13 为计算机名
//SqlConnection aConnection = new
SqlConnection("server=.;uid=admin;pwd=adminadmin;database=h
otel"); //admin 为账号,adminadmin 为密码,database 为数据库名
//创建 command 对象并保存 sql 查询语句
SqlCommand aCommand = new SqlCommand("select * from
manager", aConnection);
try
{
aConnection.Open();
//创建 datareader 对象来连接到表单
SqlDataReader aReader = aCommand.ExecuteReader();
Console.WriteLine("This is the returned data from
emp_test table");
//循环遍历数据库
while (aReader.Read())
{
Console.WriteLine(aReader.GetString(0) + " " +
aReader.GetString(1) + " " + aReader.GetString(2));
}
//关闭 reader 对象
aReader.Close();