iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
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
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
3456 1001 11/18/2009
5 x
4554 11 11/12/2009
2 x
Thank you
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
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,
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.
grid.AddInput("ANALYZE","YES");
grid.RootTable.UpdateUI();
grid.Refresh();
Now, what grid EVENT shall contain the code that will generate my rows?
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
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname
Creating your account...