Intersoft Community - Hierarchical

Prevent RowChecker from checking rows that are not expanded in a hierarchical grid

mlacy1358 — Fri, 13 Sep 2013 17:12:55 GMT

We are using the latest version of the Intersoft WebGrid. We have a self-referencing hierarchical grid that has RowChecker enabled so there is a "check all" check box in the column header of the checkbox column that when checked will check all of the rows in the grid. The issue is that this is a hierarchical grid and so at any time, one folder may be expanded showing the child rows but all the other parent rows are collapsed (so their child rows are not visible). When the RowChecker "check all" checkbox in the column header is selected, all the rows are checked, even those that are collapsed and so are not visible. Is there a way to tell the RowChecker to only check the child rows that are visible and to not check the child rows that are in a collapsed state and so are not visible?

Does new WebGrid support sorting?

Eric — Fri, 22 Oct 2010 04:01:28 GMT

We have a WebGrid which hierarchical content (tree like), loading subnodes on demand. Sorting is enabled. When clicking on the header, the sort up, sort down arrows appear, but the content is not resorted - nothing happens.

I would like to get the content resorted, only within each node of course. How would I do this?

We are using WebGrid version 6.0.7200.220 and I wonder if this is supported in a newer version and it would be worth upgrading. Please tell me if a newer version supports this natively. If not, how should I implement this?

Eric

Sample for WebGrid tree view wanted

Eric — Wed, 01 Sep 2010 05:42:24 GMT

Hi,

I need a sample for a simple tree-view using WebGrid version 6.0.7200.218.

It should use the event InitializeSelfReferenceDataSource to load the next node level data. And InitializeDataSource should load the root node data. And the columns are created in the code, not hardcoded in aspx page.

I think I have everything correct (too big to post here), but I just don't get the "plus" image to expand a node. How does WebGrid know if it needs to draw this plus image? What might be missing?

In any case such a sample would be great. I found the samples that use EnableLoadOnDemand (not supported in mentioned version) and the found samples mostly use data connectors in the aspx file, instead of creating the data in InitializeDataSource.

Thanks

Error when Adding A New Record Into Hierarchical grid

x-rookie — Thu, 04 Mar 2010 04:55:42 GMT

hi,

I have a grid containing three-hierarchical tables, they are Ship(table1) => ShipDailyWorkDetail(table2) => PZ(table3). when i try to add a new row into table3, it throws exception. Table3 containing a WebCombo and two input area.

The scenario is :

when table1 and table2 have existed, i try to add a new row in table3

1) click on "+" sign to expend the table (according to img1)

2) click "please click here to add a new record" of table3, there isn't anything but a block of blank

(according to img2). At this time i get a javascript error (according to img3)

'RelNames' is null or not an object
uri: WebGrid_Edit.js

3) click the "blank area" again, it seems get right (according to img4)

4) fill the row and enter "shift + enter" to save then

it throws exception (according to img5)

error msg is : System.NullReferenceException:object reference not set to an instance of an object

Could you tell me why? And how to resolve it?

Thank you very much.

btw. when i add a new row in table1 ,then table2, finally i add a new row in table3,it works fine.

All pictures and code are in the attachment. I keep down almost all the code, so it maybe looks a little complex. I'm sorry for it if that incommode you.

WebGrid version:3.0.5000.751

Browser: IE8

WebGrid Hierarchical Data with ISLinqDataSource or LinqDataSources

cymdiaz — Mon, 15 Feb 2010 21:50:34 GMT

Greetings,

Can you tell me how to populate a hierarchical datagrid using LinqDataSources? Visual Studio 2010 RC, Windows 7,. As far as I can tell from the documentation this feature is not supported. I don't think this can be true for WebGrid 7, I must be mistaken, but cannot find how to do it.

Thanks

Carlos

Hierarchical Grid bound to WCF Service

Michael — Tue, 15 Dec 2009 13:09:20 GMT

I have bound WebGrid to DataSet. I get DataSet from a WCF Service.

Please have a look on attached picture.

In Listbox you can see all rows.

But the WebGrid shows only the roottable and the first childtable! Why?

I can reproduce this behavoir only if i get DataSet from a WCF Service! It works, if i copy the method ProductHierarchy_Sel() to local page.

What could be the problem?

        DataSet ds2;
        protected void Page_Load(object sender, EventArgs e)
        {
            using (proxyRelays.MasterdataClient proxyMasterdata = new QS_Client.proxyRelays.MasterdataClient())
            {
                ds2 = proxyMasterdata.ProductHierarchy_Sel();
            }
            foreach (DataRow family in ds2.Tables["ProductFamily"].Rows)
            {
                ListBox1.Items.Add(family["Name"].ToString());
                foreach (DataRow nr in family.GetChildRows("relFamilyContactNr"))
                {
                    ListBox1.Items.Add("...." + nr["Name"].ToString());
                    foreach (DataRow var in nr.GetChildRows("relContactNrContactVariant"))
                    {
                        ListBox1.Items.Add("........" + var["Name"].ToString());
                        foreach (DataRow c in var.GetChildRows("relContactVariantCoil"))
                        {
                            ListBox1.Items.Add("..........." + c["Name"].ToString());
                        }
                    }
                }
            }
        }

        protected void grd2_InitializeDataSource(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)
        {
            e.DataSource = ds2;
            grd2.DataMember = "ProductFamily";
            grd2.RootTable.DataMember = "ProductFamily";
        }

        protected void grd2_PrepareDataBinding(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)
        {
            if (!Page.IsPostBack)
            {
                grd2.ClearCachedDataSource();
                grd2.RetrieveHierarchicalStructure();
            }
        }

The method ProductHierarchy_Sel()

        public DataSet ProductHierarchy_Sel()
        {
            SqlConnection cn = new SqlConnection();
            cn.ConnectionString = ConfigurationManager.ConnectionStrings["QS-SYS"].ConnectionString;
            cn.Open();

            using (cn)
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = cn;
                cmd.CommandText = "EXEC Product.Family_SelWithDep;EXEC Product.ContactNr_SelWithDep;EXEC Product.ContactVariant_SelWithDep;EXEC Product.Coil_SelWithDep";

                SqlDataAdapter da = new SqlDataAdapter();
                da.SelectCommand = cmd;
                da.TableMappings.Add("Table", "ProductFamily");
                da.TableMappings.Add("Table1", "ProductContactNr");
                da.TableMappings.Add("Table2", "ProductContactVariant");
                da.TableMappings.Add("Table3", "ProductCoil");

                DataSet ds = new DataSet();
                da.Fill(ds);
                da.FillSchema(ds, SchemaType.Mapped);

                DataRelation rel;
                rel = new DataRelation("relFamilyContactNr",
                    ds.Tables["ProductFamily"].Columns["ID"],
                    ds.Tables["ProductContactNr"].Columns["FamilyID"]);
                ds.Relations.Add(rel);

                rel = new DataRelation("relContactNrContactVariant",
                    ds.Tables["ProductContactNr"].Columns["ID"],
                    ds.Tables["ProductContactVariant"].Columns["ContactNrID"]);
                ds.Relations.Add(rel);

                rel = new DataRelation("relContactVariantCoil",
                    ds.Tables["ProductContactVariant"].Columns["ID"],
                    ds.Tables["ProductCoil"].Columns["ContactVariantID"]);
                ds.Relations.Add(rel);

                return ds;
            }
        }

Can't insert Childrecords since Update October 2009 Hotfix

Michael — Thu, 08 Oct 2009 12:19:04 GMT

Today i have installed October 2009 Hotfix.

Now i can't insert Childrecords! I get always following Errormessage: Object reference not set to an instance of an object. I have not made any changes in the meantime.

I was able to reproduce the error with attached sample.

Thanks for the speedy treatment.

It is really important.

Michael