SqlConnection提示异常

Question

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["sql2005"].ConnectionString);     SqlDataAdapter adp = new SqlDataAdapter();        adp.SelectCommand.Connection = con;        adp.SelectCommand.CommandType = CommandType.Text;        adp.SelectCommand.CommandText = "SELECT id,name,pwd,class,age FROM member"; 提示con对象为空

Answer 1

改成这样试试

  SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["sql2005"].ConnectionString);
            SqlCommand cmd = con.CreateCommand();

            cmd.CommandText = "SELECT id,name,pwd,class,age FROM member";
            SqlDataAdapter adp = new SqlDataAdapter(cmd);

            DataSet ds = new DataSet();
            con.Open();
            adp.Fill(ds);
            con.Close();