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();                //关闭数据库的链接