Intersoft Community - WebGrid Enterprise - Unbound Hierarchical Webgrid

Unbound Hierarchical Webgrid

andi@intersoftpt.com — Fri, 20 Nov 2009 02:45:44 GMT

Hi Mark,

Sorry to tell you, but there are no codes Event that can trigger to refresh the WebGrid, since we are using Unbound WebGrid. Because with Unbound WebGrid we are not allowed to do certain procedures, e.g. Refresh, Filter, Grouping, etc, since it has a static data where we set the data manually on the server side.

My advices, if you persist on using an Unbound WebGrid, we can using a filter query on database when the button is invoked (e.g SELECT * from Invoice_table where <<Condition>>), but, this is not a flyPostBack, it is a FullPostBack.

Or, you can just use a Bound WebGrid as a second option. On Bound WebGrid, we can use a Grouping and Filter function to get a similiar output as you requested or if you want to, you have to divide the database based on your category. If so, then we can make it as a hierarchical WebGrid.

Thank you,

Andi Santoso

Unbound Hierarchical Webgrid

msilka — Thu, 19 Nov 2009 08:29:22 GMT

Andi,

Thank you for your prompt response.

What I need to do is to filter my SQL view then load the contents into the grid.

On the client side I execute this code to refresh the grid to do ontheflypostback.

var grid = ISGetObject("wbgResults");

grid.AddInput("ANALYZE","YES");

"ANALYZE","YES");

grid.RootTable.UpdateUI();

grid.Refresh();

Now, what grid EVENT shall contain the code that will generate my rows?

Thank you

I also attached a modified form with what I am intending to do.

The grid does not refresh itself even though I placed a ClientAction.Refresh() in the code.

Please advise

Unbound Hierarchical Webgrid

andi@intersoftpt.com — Thu, 19 Nov 2009 06:14:03 GMT

Hi Mark Silka,

I have created a sample (VB) of WebGrid using Unbound Hierarchical and retrieve the database from Microsoft SQL Server.

First, we need to make a connection to SQL database and set a query to retrieve the data. Then, we have to assign each column to specific variable. After that, from this variable we can assign the value from database into WebGrid manually(Unbound).

For futher information, you can see my sample.

Thank You,

Andi Santoso

Unbound Hierarchical Webgrid

msilka — Wed, 18 Nov 2009 16:14:04 GMT

I have an SQL View and I wish to make an Unbound Hierarchical Webgrid from it.

The table is as such

InvoiceID CustomerID InvoiceDate LineItemNumber ItemCat1 ItemCat2 ItemCat3 ItemCat4

It is basically and invoice detail table with invoice header info on each line.

This is because I do searches on both items in the header table and detail table.

This one table speeds up my search.

Now, I want to use an unbound hierarchical grid and fill it with these items.

When I do a the client action for Grid.Refresh(); in which grid procedure do I set up the parent and child table rows?

I am using Visual Basic for my programming language.

Here is an example

The search is for Dates between 11/1/2009-11/18/2009 with a matching ItemCat1

InvoiceID CustomerID InvoiceDate LineItemNumber ItemCat1 ItemCat2 ItemCat3 ItemCat4

1234 99 11/18/2009 1 x

1234 99 11/18/2009 3 x

3456 1001 11/16/2009 5 x

4554 11 11/12/2009 1 x

4554 11 11/12/2009 2

The webgrid would like look this

InvoiceID CustomerID InvoiceDate

1234 99 11/6/2009

LineItemNumber ItemCat1 ItemCat2 ItemCat3 ItemCat4

1 x

3 x

InvoiceID CustomerID InvoiceDate

3456 1001 11/18/2009

LineItemNumber ItemCat1 ItemCat2 ItemCat3 ItemCat4

5 x

InvoiceID CustomerID InvoiceDate

4554 11 11/12/2009

LineItemNumber ItemCat1 ItemCat2 ItemCat3 ItemCat4

1 x

2 x

Thank you