How to get data from a table to DataSet by NHirbernate??

nhotxanh · **Joined:** Wed Aug 30, 2006 10:06 am **Posts:** 3

In my code, I want to get data from a table in MSSQL to DataSet, so then I can bind Dataset to DataGrid.
Who can help me ,plz??
Thanx.

DeanOC · **Posted:** Thu Aug 31, 2006 12:49 am

I'm curious: why would you be using NHibernate when you want to populate a Dataset? Wouldn't it be easier to use ADO.Net?

We bind ILists of objects (returned from NH) to our grids, thus avoiding the need to go anywhere near DataSets.

nhotxanh · **Joined:** Wed Aug 30, 2006 10:06 am **Posts:** 3

Thank you very much for answer. So can you tell me how to bind DataGrid to IList. IList is collection of 1 dimension object.I think that the field of object will be colum, and value will be row. But I couldn't bind successfully. Can you give me one example ???
Thank again.

luedi · **Joined:** Tue Feb 21, 2006 9:50 am **Posts:** 107

just assign the name of the collections to the DataSource property and the names of the properties of the class as mapping name. Here is a short sample:

Code:

public class Person
{
  private string mName;
  private string mPhone;

  public string Name
  {
    get{return mName;}
    set{mName = value;
  }

  public string Phone
  {
    get{return mPhone;}
    set{mPhone = value;}
  }
}

// Code for DataSet assuming binding an IList of Persons
IList persons = GetPersonList();
dataSet1.DataSource = persons;

// following can also be done in the designer
((DataGridTextboxColumn)dataSet1.TableStyles[0].GridColumnStyles[0]).MappingName = "Name";
((DataGridTextboxColumn)dataSet1.TableStyles[0].GridColumnStyles[1]).MappingName = "Phone";

You didn't say if you use .NET 1.1 or 2.0. In .NET 1.1, if you want to support sorting or insert new rows the concrete IList must support the IBindingList interface which you have to implement yourself.
For .NET 2.0 i'm not sure if the Framework provided collections support IBindingList.

Regards
Klaus

mnichols · **Joined:** Mon Aug 21, 2006 9:18 am **Posts:** 179

Since you are talking about a DataGrid instead of a GridView, I assume you are using .Net 1.1. So I won't mess with two-way binding.

When you bind a DataSource control such as an DataGrid to any implementation of IEnumerable (all the collections do), the properties (not fields) are able to be bound declaratively in your DataGrid.

So in the aforementioned Person class, you can just bind to a DataGrid using Eval("Name") for one field and Eval("Phone") for another. When the call to .DataBind() occurs the control reflects on the Container.DataItem as it enumerates over each Person object and assigns the value to the TableCell (or whatever control you may have nested).

So returning an IList isn't "one-dimensional" if it is returning complex types like your business objects. It's wasteful to dump your IList into an DataSet unless you really need a DataSet (like for remote callers or something).
Hope this helps!
--MIKE

nhotxanh · **Joined:** Wed Aug 30, 2006 10:06 am **Posts:** 3

First, Thanks Luedi for your code. But I agree with mnichols, that's wasteful.I understand your idea(mnichols), but I'm programming in Windows-base. Is DataBind and Eval available in this scene???
Once again, can you give me your code,at hand, and the code for .Net 2.0.
Thanks for your enthusiasm.

mnichols · **Joined:** Mon Aug 21, 2006 9:18 am **Posts:** 179

Here is a FAQ that may help you at
http://www.windowsforms.net/Samples/Go%20To%20Market/DataGridView/DataGridView%20FAQ.doc