c# Invalid attempt to call Rea

Invalid attempt to call NextResult when reader is closed
c# Invalid attempt to call Read when reader is closed
经过测试发现,当读到末尾后它就会关闭,因此循环的时候要提前判断,当然reader其实并不怎么好用,
直接用

   SqlDataAdapter adapter = new SqlDataAdapter(cmd);//数据适配器
                    DataSet ds = new DataSet();//数据集
                    result = adapter.Fill(ds, "rows"); //获取记录集
                    obj.Merge(JObject.FromObject(ds));

一样也可以

如果硬要用的话,可以看下面的,下面是我经过反复调整没有bug的代码