是SqlDataReader还是dataset比较快速呢
bzscs 2007-01-14 12:22:45 只是读取信息然后循环处理,不用修改保存;数据量比较多,大概要生成相应的几万个文件
★★★有时候似乎reader快一些★★★
SqlCommand sqlcom = new SqlCommand();
sqlcom.CommandType = CommandType.Text;
sqlcom.CommandText = strSql
sqlcom.Connection = thisConnection;
SqlDataReader objReader = sqlcom.ExecuteReader(CommandBehavior.CloseConnection);
while(objReader.Read())
{
......
}
★★★有时候dataset比reader还块★★★
SqlCommand sqlcom = new SqlCommand();
sqlcom.CommandType = CommandType.Text;
sqlcom.CommandText = strSql;
sqlcom.Connection = thisConnection;
SqlDataAdapter sqlDA = new SqlDataAdapter();
sqlDA.SelectCommand = sqlcom;
DataSet objDataSet = new DataSet();
sqlDA.Fill(objDataSet);
for(i =0;i<objDataSet.Tables[0].Rows.Count;i++)
{
......
}