Nullable Columns do not show on datagrid binding + Question about GUI

Posts   
 
    
aliem
User
Posts: 21
Joined: 03-Oct-2006
# Posted on: 15-Dec-2006 00:45:04   

I am very new to LLBLGen and have two simple questions.

(1) Nullable Columns I am testing out binding from a simple table and I have noticed that it will not show the columns which are nullable. How can I fix this?

(2) Are there any prepackaged GUI objects/controls for LLBLGenPro to download that performs the basic functionality, like paging/editing/sorting etc...?

Thanks

bclubb
User
Posts: 934
Joined: 12-Feb-2004
# Posted on: 15-Dec-2006 02:52:38   

You should see nullable columns can you post the code that isn't working and a bit about your scenario? What DB, Self Servicing or Adapter.

There is the LLBLGenDataSource the manual goes into detail on what this control will allow you to do. If while looking through this you have any questions just let us know.

aliem
User
Posts: 21
Joined: 03-Oct-2006
# Posted on: 15-Dec-2006 19:58:29   

Ok here is my scenario:

-LLBLGen Pro 2.0 -Adapter with 2 classes -SQL Server Express


DataAccessAdapter adapter = new DataAccessAdapter(true);
EntityCollection<CalendarEventEntity> calendarEvents = new EntityCollection<CalendarEventEntity>(new CalendarEventEntityFactory());

adapter.FetchEntityCollection(calendarEvents, null);

uxDebugDataGrid.DataSource = calendarEvents; 
uxDebugDataGrid.DataBind();

The UI has "Autogenerate columns to true"

More work into this shows the following results:

-Nullable "BIT" and "INT" columns are the ones not displaying by default.

If I manually define the datagrid columns they will show.

This is not a big issue as I will likely never use autogenerate columns, but I'm interested as to why this is happening. Is something wrong with my setup?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39927
Joined: 17-Aug-2003
# Posted on: 16-Dec-2006 12:51:59   

Nullable types have been changed in .NET 2.0's development about 2 months or so before they released the RC. The problem I think is that a couple of control developers didn't pickup the changes very well, and simply ignore nullable types. You're using a 3rd party grid?

Frans Bouma | Lead developer LLBLGen Pro
aliem
User
Posts: 21
Joined: 03-Oct-2006
# Posted on: 17-Dec-2006 00:45:55   

Oh ok thanks. I'm just using the standard .net ASP datagrid right now. Although if you or anyone has any suggestions on other grids (3rd party) to use I would be interested to hear about them. So far I really like LLBLGenPro though, very powerful and easy to use...

Are there any considerations to developing a "Nakeobjects" equivalent for LLBLGenPro? I love code automation simple_smile .

Chester
Support Team
Posts: 223
Joined: 15-Jul-2005
# Posted on: 17-Dec-2006 19:30:51   

You might check out some recent posts about third party grids. Lots of different grids are being used by LLBLGen Pro users. I hadn't heard of NakedObjects before, but this post is an interesting use of LLBLGen for prototyping purposes:

http://llblgen.com/tinyforum/Messages.aspx?ThreadID=8205