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();                //¹Ø±ÕÊý¾Ý¿âµÄÁ´½Ó