using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;//sql
using System.Data;//ConnectionState
using System.Configuration;//用于获取配置文件中的字符串
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
//----------
string ConnStr = "server=(local);database=SystemCourse;integrated security=true";
// string ConnStr = System.Configuration.ConfigurationManager
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConnStr;
if(conn.State ==ConnectionState.Closed)
conn.Open();
//----------
string sql = "select * from students";
SqlCommand cmd = new SqlCommand(sql,conn);
//创建Command对象后,就可以执行SQL命令,执行后完成并关闭数据连接,示例代码如下所示。
// cmd.ExecuteNonQuery(); //执行SQL命令
//con.Close(); //关闭连接
//----------
SqlDataReader reader = cmd.ExecuteReader();//将sql语句发送给sqlconnection,并产生一个sqldatareader对象
//reader是只读的,不能修改数据,reader读取一条就释放一条,只能向前不能后退
while (reader.Read())
{
Console.WriteLine("姓名:{0}",reader[2].ToString());
}
reader.Close();
if (conn.State == ConnectionState.Open)
conn.Close();
}
}
}