StrataFrame Forum » StrataFrame Application Framework - V1 » WebForms (How do I?) » Using WebBusinessBindingSource with DevExpress 8.1.1 ASPxGridView

Using WebBusinessBindingSource with DevExpress 8.1.1 ASPxGridView

Mark Dowlearn — Fri, 25 Jul 2008 08:27:15 GMT

Hello,

I'm doing a test web page with a DevExpress 8.1.1 ASPxGridView and a WebBusinessBindingSource.

I've linked the WebBusinessBindingSource to a SF BO that represents a SQL2005 table. It has some custom properties on it but aside from that is a straight mapping of the table.

I've set the data source for the grid to the WebBusinessBindingSource. (The grid doesn't appear to like the custom properties, so I've just loaded a couple of varchar fields as columns and under those conditions it appears to work ok for setting up the columns and displaying them).

I populate the WebBusinessBindingSource's underlying BO in the PageLoad method of the page.

When I run the page, the BO seems to properly populate with about 140 records, but the grid displays just the first row and then repeats the first row for all the remaining rows that it displays.

I'm able to get all rows to display when using a SqlDataSource, so I am thinking this has something to do with the WebBusinessBindingSource.

It feels like I've got to be missing something simple here -- any suggestions as to why the single row repeats in the display?

And has anyone had any experience with using custom properties as sources for the grid columns? (Not sure why this doesn't work ....)

RE: Using WebBusinessBindingSource with DevExpress 8.1.1 ASPxGridView

StrataFrame Team — Fri, 25 Jul 2008 08:27:15 GMT

Have you tried it to see if it works properly? Let me know if it's still acting weird.

RE: Using WebBusinessBindingSource with DevExpress 8.1.1 ASPxGridView

Chan — Thu, 24 Jul 2008 19:59:20 GMT

Thank you very very much

RE: Using WebBusinessBindingSource with DevExpress 8.1.1 ASPxGridView

Trent L. Taylor — Thu, 24 Jul 2008 13:37:28 GMT

Chan,

You can get the most recent version here that has that fix: http://forum.strataframe.net/FindPost18055.aspx .

RE: Using WebBusinessBindingSource with DevExpress 8.1.1 ASPxGridView

StrataFrame Team — Thu, 24 Jul 2008 09:12:35 GMT

I finally discovered that the Telerik and DevExpress grids do not use the enumerator of the DataSourceView in a predictable fashion. They create their own list of items to store in the list because they provide paging. This allows them to use a for loop, not a foreach loop to build the grid from only the items they want to display. We had to change the WBBS enumerator to return a new BO reference like the winforms BBS does. It's fixed, and we'll try to get a build together so we can post it as the new 1.6.6 Beta.

RE: Using WebBusinessBindingSource with DevExpress 8.1.1 ASPxGridView

Chan — Thu, 24 Jul 2008 01:02:45 GMT

Hi,
Shall I have this fix ASAP? I need it urgently. I am "stuck" here cannot deliver.

Sorry for any inconvenience.

Thank you

RE: Using WebBusinessBindingSource with DevExpress 8.1.1 ASPxGridView

Trent L. Taylor — Thu, 17 Jul 2008 08:52:28 GMT

Chan,

This is actually something that we are looking at but we are in the middle of SF class this week and next. So we will try and get you some answers as soon as we can. Thanks.

RE: Using WebBusinessBindingSource with DevExpress 8.1.1 ASPxGridView

Chan — Tue, 15 Jul 2008 20:17:43 GMT

Hi,
Any updates?

Thank you

RE: Using WebBusinessBindingSource with DevExpress 8.1.1 ASPxGridView

Chan — Wed, 02 Jul 2008 01:08:56 GMT

Hi,
Please find the attached sample project.

Thank you

RE: Using WebBusinessBindingSource with DevExpress 8.1.1 ASPxGridView

Trent L. Taylor — Mon, 30 Jun 2008 09:37:02 GMT

We have it on a list to look at but as of yet we have not reproduced. You are welcome to post a sample that reproduces the problem so that we can more quickly reproduce the issue.

RE: Using WebBusinessBindingSource with DevExpress 8.1.1 ASPxGridView

Chan — Mon, 30 Jun 2008 09:15:47 GMT

Hi,
Any update on this? I need it very urgently.
Thank you

RE: Using WebBusinessBindingSource with DevExpress 8.1.1 ASPxGridView

Chan — Thu, 26 Jun 2008 02:26:54 GMT

Hi,
I also faced the same problem. I tried to bind the same WebBBS to AspxCombobox and it is working fine.

Any ideas?

Thank you

RE: Using WebBusinessBindingSource with DevExpress 8.1.1 ASPxGridView

Trent L. Taylor — Mon, 23 Jun 2008 23:50:03 GMT

Let me know if you don't make any progress and I will see if I can reproduce.

RE: Using WebBusinessBindingSource with DevExpress 8.1.1 ASPxGridView

Mark Dowlearn — Mon, 23 Jun 2008 22:48:21 GMT

Thans -- I'll contintue to work on figuring it out.

RE: Using WebBusinessBindingSource with DevExpress 8.1.1 ASPxGridView

Trent L. Taylor — Mon, 23 Jun 2008 12:48:58 GMT

[quote]I've already overridden the GetCustomBindablePropertyDescriptors method and have been using custom properties successfully with other controls. It appears to me to be something specific to the interaction with SF and the DevExpress control.[/quote]

The DevExpress control should be totally irrelevant as the IBindingList implementation doesn't care about the control but rather speaking straight to the interface properties and methods.

The first thing I would do is take the BO in question and bind it to a WinForms grid through a standard BBS, then if that worked, take the WBBS and binding to a control other than the DevExpress grid (I have never attempted to use the web DevExpress grid, so I am afraid I cannot be of much help there without having to setup and get my head into this control itself, though I do not beleive that this is the problem anyway).

RE: Using WebBusinessBindingSource with DevExpress 8.1.1 ASPxGridView

Mark Dowlearn — Mon, 23 Jun 2008 11:35:26 GMT

Hello, Trent -

>>>You need to override the GetCustomBindablePropertyDescriptors method and provide a ReflectionPropertyDescriptor for each custom property so that it can be bound.

I've already overridden the GetCustomBindablePropertyDescriptors method and have been using custom properties successfully with other controls. It appears to me to be something specific to the interaction with SF and the DevExpress control.

>>>It sounds like something is repositioning the BO for each exposed row in the IBindingList implementation. This can happen for a number of reasons: filters, sorts, other navigation code within an event of the BO, etc.

Hmmm....There are no filters or sorts on the BO, just a plain vanilla "FillAll()" and hook it up to the grid using a WebBusinessBindingSource. No navigation code either. I'll look at debugging through the source code unless there's something specific you would suggest.

>>>There are a LOT of posts out here on the forum in this regard. Here are just a few:
>>>http://forum.strataframe.net/FindPost15985.aspx (This sample shows how to create a custom property and add a broken rule to that custom property)
>>>http://forum.strataframe.net/FindPost17063.aspx

Yes, these have been very helpful. Still don't know why custom properties work with other controls but not the DevExpress control using the WebBusinessBindingSource, however.

RE: Using WebBusinessBindingSource with DevExpress 8.1.1 ASPxGridView

Trent L. Taylor — Mon, 23 Jun 2008 08:05:52 GMT

[quote](The grid doesn't appear to like the custom properties, so I've just loaded a couple of varchar fields as columns and under those conditions it appears to work ok for setting up the columns and displaying them).[/quote]

You need to override the GetCustomBindablePropertyDescriptors method and provide a ReflectionPropertyDescriptor for each custom property so that it can be bound.

[quote]but the grid displays just the first row and then repeats the first row for all the remaining rows that it displays. [/quote]

It sounds like something is repositioning the BO for each exposed row in the IBindingList implementation. This can happen for a number of reasons: filters, sorts, other navigation code within an event of the BO, etc.

[quote]And has anyone had any experience with using custom properties as sources for the grid columns? (Not sure why this doesn't work ....) [/quote]

There are a LOT of posts out here on the forum in this regard. Here are just a few:

http://forum.strataframe.net/FindPost15985.aspx (This sample shows how to create a custom property and add a broken rule to that custom property)

http://forum.strataframe.net/FindPost17063.aspx