class Program
{
static void Main(string[] args)
{
/*
* 五个步骤
* 1、连接数据源
* 2、打开连接
* 3、创建一个SQL查询命令
* 4、使用DataReader读取并显示数据
* 5、关闭DataReader和连接
@"Data Source=.\SQLEXPRESS;"+
@"AttachDbFilename='C:\SQL Server 2000 Sample Databases\NORTHWND.MDF';"
+
@"Integrated Security=true;Connect Timeout=30;User Instance=true");//1、
thisConnection.Open();//2、
SqlCommand thisCommand = thisConnection.CreateCommand();//3、
/* thisCommand.CommandType = CommandType.StoredProcedure;//调用存储过程
//Ten Most Expensive products是存储过程的名字
thisCommand.CommandText = "Ten Most Expensive products";*/
thisCommand.CommandText =
"select CustomerID,CompanyName from Customers";
SqlDataReader thisReader = thisCommand.ExecuteReader();//4、
while (thisReader.Read())
{
Console.WriteLine("\t{0}\t{1}",
thisReader["CustomerID"], thisReader["CompanyName"]);
/* //存储过程输出的两列
Console.WriteLine("\t{0}\t{1}",
thisReader["TenMostExpensiveProducts"], thisReader["UnitPrice"]);*/
}
thisReader.Close();
thisConnection.Close();
Console.WriteLine("program finished,press Enter/Return to continue:");
Console.ReadLine();
}
}
{
static void Main(string[] args)
{
/*
* 五个步骤
* 1、连接数据源
* 2、打开连接
* 3、创建一个SQL查询命令
* 4、使用DataReader读取并显示数据
* 5、关闭DataReader和连接
*/
/* 连接sql2000的字段
string sqlstring = "server=20120421-0838.;uid=sa;pwd=mc123;database=Northwind";
SqlConnection thisConnection = new SqlConnection(sqlstring);*/
//Integrated Security=true这句指定sql和windows的标准内置安全功能。还可以用(User=sa;PWD=ma)代替它
//连接sql2005
SqlConnection thisConnection = new SqlConnection(@"Data Source=.\SQLEXPRESS;"+
@"AttachDbFilename='C:\SQL Server 2000 Sample Databases\NORTHWND.MDF';"
+
@"Integrated Security=true;Connect Timeout=30;User Instance=true");//1、
thisConnection.Open();//2、
SqlCommand thisCommand = thisConnection.CreateCommand();//3、
/* thisCommand.CommandType = CommandType.StoredProcedure;//调用存储过程
//Ten Most Expensive products是存储过程的名字
thisCommand.CommandText = "Ten Most Expensive products";*/
thisCommand.CommandText =
"select CustomerID,CompanyName from Customers";
SqlDataReader thisReader = thisCommand.ExecuteReader();//4、
while (thisReader.Read())
{
Console.WriteLine("\t{0}\t{1}",
thisReader["CustomerID"], thisReader["CompanyName"]);
/* //存储过程输出的两列
Console.WriteLine("\t{0}\t{1}",
thisReader["TenMostExpensiveProducts"], thisReader["UnitPrice"]);*/
}
thisReader.Close();
thisConnection.Close();
Console.WriteLine("program finished,press Enter/Return to continue:");
Console.ReadLine();
}
}