iList to DataSet or DataTable (Crystal Reportes usage)

pedrojr · **Posted:** Mon Aug 22, 2005 1:18 pm

Hi,

I use the Crystal Reports to generate reports. It only works with DataSet. Exists some form to convert DataSet for iList?

Thanks,

[]s

Patrik.H · **Posted:** Mon Aug 22, 2005 1:34 pm

Not a answer.. sorry for that.. But when NH runs a report query, wouldnt it be nice to return a (System.Data) datatable instead of a array of objects.

In most cases I have to convert it to a DT and then display it..

pedrojr · **Posted:** Mon Aug 22, 2005 4:56 pm

Hi friend,

You it would have some example of as to make this conversion?

I tried to convert directly but it gave an error of type of invalid conversion. :(

I thank its aid very.

[]s

michal · **Posted:** Tue Aug 23, 2005 7:51 am

Hi,
I'm using Reflection for this task : object.GetType.GetProperties() gives me array of PropertyInfo objects, then [propertyinfo instance].PropertyType gives the data types, [propertyinfo instance].GetValue(....) can read object values - with such info make two simple loops - first for creating DataTable structure, second - to put data from your objects into datatable.

Something like this (vb code, should be no problem with conversion to c#)

Code:

dim dt as new DataTable
dim pis as PropertyInfo()=myObjectArray(0).GetType.GetProperties()
For Each pi As PropertyInfo In pis
   Dim name As String = pi.Name
     Select Case pi.PropertyType.Name
        Case "Int32", "String", .....
           dt.Columns.Add(name, pi.PropertyType)
     End Select
Next

for each obj as myObjectType in myObjectArray
  For Each pi As PropertyInfo In pis
     Dim name As String = pi.Name
        Select Case pi.PropertyType.Name
            Case "Int32", "String", .....
               dim dr as DataRow=dt.NewRow
               dr(name)=pi.GetValue(obj, Nothing)
        End Select
   Next
   dt.rows.add(dr)
next

anthoparis · **Posted:** Fri Oct 21, 2005 12:18 pm

shouldn't it be sufficient ?

IList lst = session.Find(query);

DataGrid1.DataSource = lst;
DataGrid1.DataBind();
DataSet1==CType(DataGrid1.DataSource,DataSet)