asp.netÁ¬½ÓSQLserver2005ÎÊÌâ

string userpossword;
        SqlConnection conn = new SqlConnection("server=.\\SQL2005;uid=sa;pwd=sa;database=TongXunLuDB");
        string strcon = "select userpassword from UserLoginInfo where username='admin'";
        conn.Open();
        SqlCommand cmd = new SqlCommand(strcon,conn);


      SqlDataReader dr = cmd.ExecuteReader() ;
      userpossword = dr["userpassword"].ToString();
        return userpossword;

ÕâÊÇÁ¬½ÓµÄº¯Êý£¬Á¬½ÓÓ¦¸ÃûÓÖÎÊÌ⣬¾ÍÊÇdatareader±äÁ¿ÖÐûÓÐÖµ£¬ÔÚ²éѯ·ÖÎöÆ÷ÖÐÖ´ÐÐÉÏÃæµÄSQLÓï¾ä¿ÉÒÔ²é³öÀ´½á¹û£¬µ«Êǵ½Õâ¾ÍûÓнá¹û£¬drÀïÃæµÄ×Ö¶ÎûÓÖÎÊÌ⣬Õâµ½µ×ΪʲôÄØ£¬Õâô¼òµ¥µÄµØ·½£¬£¬£¬

---

µ¥²½µ÷ÊÔ¡£¡£¡£

---

ÒýÓÃ

µ¥²½µ÷ÊÔ¡£¡£¡£

µ÷ÁË£¬²»ÐË°¡

---

ÊÔ×ÅÕâÑùдһÏ£¡   

SqlDataReader dr = cmd.ExecuteReader() ;
if(dr.Read())
  {
      userpossword = dr["userpassword"].ToString();
  }
        return userpossword;

---

ºÜ²»´í°¡¡£¶¥¡£¡£

ÒýÓÃ

ÊÔ×ÅÕâÑùдһÏ£¡   

SqlDataReader dr = cmd.ExecuteReader() ;
if(dr.Read())
  {
      userpossword = dr[