asp.net从sql server2005中查询数据

 首先要添加
using System.Data;
using System.Data.SqlClient;    
接下来：
          SqlConnection conn = new SqlConnection("server=QLPC\\SQL2005;uid=sa;pwd=（你的密码）;database=（你的数据表）");                  //用于连接数据库
            conn.Open();       //打开数据库
            SqlCommand cmd = new SqlCommand("select * from [user]", conn);              //相当于执行数据语句吧
            SqlDataReader read = cmd.ExecuteReader();                                   //创建一个SqlDataReader的read象  
            while (read.Read())                                                  //当读取的数据存在时则写出来
            {
                Response.Write(read[0]);
            }
conn.close();                //关闭数据库的链接