问一个DataSet的问题

[daiwb]

IDbCommand cmd = connection.CreateCommand();
cmd.CommandText = sql;
IDataReader reader = cmd.ExecuteReader();
DataSet set = new DataSet();
set.Load(reader, LoadOption.OverwriteChanges, new string[1] { "Data" });

其中Load是.Net 2.0才有的特性,1.1下面有什么好的方法替代? Thx~

[TJUsecretfish]

yeah..

you could try to use DataAdapter..

[limengqiang]

没用过2.0 set.Load(reader, LoadOption.OverwriteChanges, new string[1] { "Data" });
是啥意思啊

[Knight94]

Have a try!

IDbCommand cmd = connection.CreateCommand();
cmd.CommandText = sql;
IDataAdapter dbAdapter = new IDataAdapter();
dbAdapter.SelectCommand = cmd;

DataSet set = new DataSet();
dbAdapter.Fill( set, "Data" );