I have a MySqlDataReader object, with the result of this query :
SELECT warehouse, leasing, transportation, maintenance, manpower FROM retail WHERE zone = 'Central' GROUP BY warehouse
And then I loop through the DataReader once,
while (r2.Read())
{
strXml.AppendFormat("<set label = '{0}'></set>",r2["warehouse"].ToString());
}
And now I want to loop through it again...!!
I know that DataReader is only a 'forward-only' object.. But is there any other solution for me here ?
I'm asking, is there any any efficient way to hold data other than MySqlDataReader ?