C#连接数据库sqlserver2005,执行sql,得到SqlDataReader结果的实例:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;//头文件
namespace DBdemo2
{
class Program
{
static void Main(string[] args)
{
//建立连接对象
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=mapdemo;Data Source=PC-20130306BGML";
//打开连接
conn.Open();
//建立执行命令对象
string sqlstring = "select * from stdents";
SqlCommand cmd = new SqlCommand(sqlstring,conn);
//执行语句,返回SqlDataReader对象
SqlDataReader rdr = cmd.ExecuteReader();
//遍历访问
while(rdr.Read()){
Console.WriteLine("{0},{1},{2},{3},{4},{5}", rdr[0], rdr["stdudentname"],
rdr["sex"], rdr["birthday"], rdr["native"], rdr["address"]);
}
//关闭资源
rdr.Close();
conn.Close();
}
}
}