sql server ¶Áȡʱ³ö´í

SqlConnection myCon = new SqlConnection();
        myCon.ConnectionString = "Persist Security Info=False;User id=sa;pwd='';database=nettest;server=(local)";
        myCon.Open();
        Page.Response.Write(myCon.State + " <br/>");   
        SqlCommand myCom=new SqlCommand();
        myCom.Connection =myCon;
        myCom.CommandText="select * from t_pass";
        SqlDataAdapter sdr = myCom.ExecuteReader();

×îºóÒ»¾ä£ºSqlDataAdapter sdr = myCom.ExecuteReader();±¨´í£º
±àÒëÆ÷´íÎóÐÅÏ¢: CS0029: ÎÞ·¨½«ÀàÐÍ¡°System.Data.SqlClient.SqlDataReader¡±Òþʽת»»Îª¡°System.Data.SqlClient.SqlDataAdapter¡±

---

Ôõô²ÅÄÜÐÞÕý´íÎóÄØ¡£

---

System.Data.SqlClient.SqlDataReader sdr = myCom.ExecuteReader();
»òÕß
SqlConnection scon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        scon.Open();
        SqlDataAdapter dbAdapter = new SqlDataAdapter(str, scon);
        DataSet ds = new DataSet();
        dbAdapter.Fill(ds);
        scon.Close();
ÕâЩд

---

SqlDataReader sdr = myCom.ExecuteReader();

---

using(SqlDataRead