顺序调一下,后面那个遍历foreach 循环会有影响的。获取数据不慢,那就是那个循环慢
//执行sql语句获取存储过程集合
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataSet ds = new DataSet();
adapter.Fill(ds);//关闭链接
connection.Close();//遍历返回集合
List<Dictionary<string, object>> resultList = new List<Dictionary<string, object>>();foreach (DataRow dr in ds.Tables[0].Rows)
{
Dictionary<string, object> dic = new Dictionary<string, object>();
foreach (DataColumn dc in dr.Table.Columns)
{
dic.Add(dc.ToString(), dr[dc]);
}
resultList.Add(dic);
}
return resultList;
//执行sql语句获取存储过程集合
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataSet ds = new DataSet();
adapter.Fill(ds);//关闭链接
connection.Close();//遍历返回集合
List<Dictionary<string, object>> resultList = new List<Dictionary<string, object>>();foreach (DataRow dr in ds.Tables[0].Rows)
{
Dictionary<string, object> dic = new Dictionary<string, object>();
foreach (DataColumn dc in dr.Table.Columns)
{
dic.Add(dc.ToString(), dr[dc]);
}
resultList.Add(dic);
}
return resultList;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货