We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Rebind Grid with Dataset that has Nested Relations

Thread ID:

Created:

Updated:

Platform:

Replies:

60222 Apr 30,2007 04:07 PM May 4,2007 01:11 PM Windows Forms 3
loading
Tags: Grouping
Uma Datla
Asked On April 30, 2007 04:07 PM

Hi,

I am doing rebind Grid Grouping Control(v2.0.50727) with data set that has GrandChild Relations. When I am chaging the Grid view from dataset that has Nested Relations to another view I am getting the following error.

Please help me with this issue.

Exception:
Source Assembly: Syncfusion.Grouping.Base
Error Message: Object reference not set to an instance of an object.
Target Site:
Void .ctor(Syncfusion.Grouping.Element)
Stack Trace:
at Syncfusion.Grouping.Internals.ElementTreeTable..ctor(Element owner)
at Syncfusion.Grouping.Internals.SectionsTreeTable..ctor(Group owner)
at Syncfusion.Grouping.Group..ctor(Element parent)
at Syncfusion.Grouping.ChildTable..ctor(Element parent)
at Syncfusion.Windows.Forms.Grid.Grouping.GridChildTable..ctor(Element parent)
at Syncfusion.Windows.Forms.Grid.Grouping.GridEngine.CreateChildTable(Element parent)
at Syncfusion.Grouping.TableDescriptor.CreateChildTable(Element parent, Boolean hasRecords, Table table, SortColumnDescriptorCollection fields)
at Syncfusion.Grouping.Table.InitTopLevelGroup()
at Syncfusion.Grouping.Table.CategorizeElements()
at Syncfusion.Grouping.Table.OnEnsureInitialized(Object sender)
at Syncfusion.Grouping.Element.EnsureInitialized(Object sender, Boolean notifyParent)
at Syncfusion.Grouping.Table.EnsureInitialized(Object sender, Boolean notifyParent)
at Syncfusion.Grouping.Element.EnsureInitialized(Object sender)
at Syncfusion.Grouping.Table.get_TopLevelGroup()
at Syncfusion.Grouping.Table.get_FilteredChildTableOrTopLevelGroup()
at Syncfusion.Windows.Forms.Grid.Grouping.GridNestedTableControl.get_CurrentCell()
at Syncfusion.Windows.Forms.Grid.Grouping.GridTableControl.DeactivateCurrentCell(Boolean allowCancel)
at Syncfusion.Windows.Forms.Grid.Grouping.GridTableControl.Table_DisplayElementChanging(Object sender, DisplayElementChangingEventArgs e)
at Syncfusion.Windows.Forms.Grid.Grouping.GridTableModel.OnDisplayElementChanging(DisplayElementChangingEventArgs e)
at Syncfusion.Windows.Forms.Grid.Grouping.GridTableModel.Syncfusion.Grouping.ITableEventsTarget.OnDisplayElementChanging(DisplayElementChangingEventArgs e)
at Syncfusion.Grouping.TableDescriptor.Syncfusion.Grouping.ITableEventsTarget.OnDisplayElementChanging(DisplayElementChangingEventArgs e)
at Syncfusion.Grouping.Table.OnDisplayElementChanging(DisplayElementChangingEventArgs e)
at Syncfusion.Grouping.Table.RaiseDisplayElementChanging(Element element, Int32 oldCount, Int32 newCount, Boolean repaintElement, Boolean syncCurrentRecordPos, Boolean leaveCurrentRecord, Boolean scroll)
at Syncfusion.Grouping.Table.Engine_PropertyChanging(Object sender, DescriptorPropertyChangedEventArgs e)
at Syncfusion.Windows.Forms.Grid.Grouping.GridTable.Engine_PropertyChanging(Object sender, DescriptorPropertyChangedEventArgs e)
at Syncfusion.Grouping.DescriptorPropertyChangedEventHandler.Invoke(Object sender, DescriptorPropertyChangedEventArgs e)
at Syncfusion.Grouping.Engine.OnPropertyChanging(DescriptorPropertyChangedEventArgs e)
at Syncfusion.Windows.Forms.Grid.Grouping.GridEngine.TableDescriptor_PropertyChanging(Object sender, DescriptorPropertyChangedEventArgs e)
at Syncfusion.Grouping.DescriptorPropertyChangedEventHandler.Invoke(Object sender, DescriptorPropertyChangedEventArgs e)
at Syncfusion.Grouping.TableDescriptor.OnPropertyChanging(DescriptorPropertyChangedEventArgs e)
at Syncfusion.Windows.Forms.Grid.Grouping.GridTableDescriptor.ResetTableDescriptor()
at Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl.ResetTableDescriptor()
at FORECAST_MGR.ComponentForms.ForecastExceptions.BindData(ForecastExceptionsDataSet ds, VIEWEXCPS excpView)

haneefm [Syncfusion]
Replied On April 30, 2007 07:59 PM

Hi Uma,

Here is a forum thread that discuss with the simillar issue and let me know if this helps.
http://www.syncfusion.com/support/forums/message.aspx?&MessageID=56040

Best regards,
Haneef

Uma Datla
Replied On May 2, 2007 12:04 PM

Hi Haneef,

I have followed the Example GridGroupingRebind. In my Grid I have 3 views. Each view has a different datasource. One of the Grid view has Parent to Child and Child to Grand Child Relation dataset. When I switch the Grid from this view to another I am getting the above exception. The Exception is coming from GridGroupingControl.ResetTableDescriptor().

Please see below for my GridRebind() code.

private void BindData(ForecastExceptionsDataSet ds, VIEWEXCPS excpView)
{
try
{
//ggFcstExcps is the GridGrouping Control
this.ggFcstExcps.DataBindings.Clear();

switch (excpView)
{
case VIEWEXCPS.EXCP_TYPE:
this.ggFcstExcps.DataSource = ds.BUYER_EXCPS_COUNT_BY_EXCPTYPE;
break;
case VIEWEXCPS.VENDOR:
//change this later to Vendor Table
this.ggFcstExcps.DataSource = ds.BUYER_ROG_LIST;
break;
case VIEWEXCPS.WAREHOUSE:
this.ggFcstExcps.DataSource = ds.WH_EXCEPTIONS;
break;

default:
this.ggFcstExcps.DataSource = ds.BUYER_EXCPS_BY_EXCPTYPE;
break;

}

if (this.ggFcstExcps.TableDescriptor != null)
{

this.ggFcstExcps.ResetTableDescriptor();
this.ggFcstExcps.TableDescriptor.Relations.Reset();
}

// Show group area
this.ggFcstExcps.ShowGroupDropArea = false;

// Additionial table descriptors currently habe to be added manually.
AddGroupDropAreas(this.ggFcstExcps.Table);

// Make changes to schema. See above notes how to reset changes.
SetReadOnly(this.ggFcstExcps.Table);
}
catch (Exception ex)
{
ErrorHandler.HandleError(new ErrorDetails(Error.C17201, ex));
}

}
Please help me with this issue.

Thanks
Uma


Uma Datla
Replied On May 4, 2007 01:11 PM

I have solved this issue by calling this line of code before setting the data source to the Grid.

this.gridGroupingControl1.Tabledescriptor.Relations.clear();

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;