Actually, when I try to convert the IDataReader to List(of T) with the Function CBO.FillCollection(Of T), which I am obtaining from

" DotNetNuke.Data.DataProvider.Instance.ExecuteSQL(MySqlString) "

I am getting Error, while the same thing works ok if I get it from Stored Procedure

Both above works ok if I convert the IDataReader to ArrayList using CBO.FillCollection()

What am I doing wrong ?

What special do I need to do for using CBO.FillCollection(Of T) ?

What are the advatage of Using List(Of T) over ArrayList (yes, it is strongly typecased, but how is it useful and what about the resource consulmption ?)

Have you ensure you are referencing the correct assemblies?  You might not have the System.Data.* referenced.  Snapshot from my C# page:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Text;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;


using DotNetNuke.Data;
using Microsoft.ApplicationBlocks.Data;

-------------------

Generics are the way to go!