Intersoft Community - Server-side

Create WebGrid in Server-side programmatically but Error in Sorting

uwei — Thu, 30 Mar 2017 03:31:50 GMT

I want to sort when user click colums, but there is error when it clicked. (see attach: Error01.png)

I write the code by http://www.intersoftsolutions.com/Support/WebGrid/Tutorial/Text/Create-WebGrid-in-Server-Side-programmatically/

There is not struncture of root table in webgrid.

only the code like:

<ISWebGrid:WebGrid>
<LayoutSettings RowHeightDefault="26px" AllowSorting="Yes">
...
</LayoutSettings>
</ISWebGrid:WebGrid>

How can I fix it?

Remove column defined in aspx markup, from server-side

sinan.biondic@gmail.com — Tue, 16 Apr 2013 16:03:03 GMT

Hi,

I am trying to implement webgrid but the problem exists when I'm binding it to datasource. I have a stored procedure that returns some data.However, I don't know how many columns will be returned in that procedure, but I know the names of all columns that can be returned. So what I wanted to do, is to define all possible columns in aspx page, and in server-side PrepareDataBinding method remove columns from webgrid's column collection that don't have their match in datasource datatable that I'm binding it to.

This doesn't really work as I get an error stating that columne "XYZ" which is defined in aspx can't be found in datasource, although it was removed (I checked with debugger) in PrepareDataBinding event handler.

I presume this then is not possible, or am I wrong? The reason I am not creating columns from codebehind is simply that I would have to check datasource for every column to see if it exists and then create that column dynamically and add it to the column collection of webgrid. We did that in old version of our application and that PrepareDataBinding method has over 1600 lines of code, so I am looking for a better way of doing this. Please help me for the love of god!

This is my PrepareDataBinding method (column named "Check" is rowchecker column so i don't want it removed):

Dim dt As DataTable = CType(e.DataSource, DataTable)
 Dim grid As WebGrid = CType(sender, WebGrid)
 Dim colName As String
 For Each col As WebGridColumn In grid.RootTable.Columns
 colName = col.DataMember
 If Not colName = "Check" AndAlso Not dt.Columns.Contains(colName) Then
 grid.RootTable.Columns.Remove(col)
 End If
 Next

Unbound WebGrid example wanted / Help on common design

Eric — Mon, 07 Jun 2010 12:13:20 GMT

Hi, I have a screen with lots of controls and one list of items. This item list is shown in a WebGrid. I have two buttons to add and remove items into/from that list. When adding, another modal dialog pops up to select the correct item. When deleting, this is done by a checkbox column in the grid. And there's a save button on the form to save all data together back to the database. When a new row gets added to the WebGrid, this may not be saved to the database at that time, only later, if the user clicks on Save.

I had to make bigger changes of this existing (working) page, because of bad design. Actually I almost had to rewrite it.

In Page.Load I read in all data from the database (including the list of items) and store this in a local structure. I do not want to use session variables. Storing data in ViewState would be ok.

What is the correct way of implementing something like this? It seems to be a standard problem. Is there a demo for this available somewhere? Should I make the WebGrid somehow unbound?

In Page.Load I read in the data. And in grid.InitializeDataSource I set the e.DataSource to the values from what I read in Page.Load earlier (by creating a table and assigning it). On Postback, I cannot read in the data again, because this would overwrite the current data. So after a Postback, the internal variable doesn't contain any data anymore. When clicking on Save, I save all fields back to the database. Is this design correct so far?

But how would I implement the insert/delete of the rows to the WebGrid? For the Add button (<asp:Button>) I have an attribute like this: OnClientClick="ModalDialog(...

In the click handler on the server side I read the ID of the selected item from a session variable (still bad design, but unchanged), which was set in the selection dialog, then get some more info from the DB and I think then I should add this data as a row to the WebGrid. Is that correct? How would I add this row? In the Button click event adding a row to the grid.RootTable? And even if this would work, how should I afterwards refresh the grid?

Please help getting this designed correct with your control. We are using WebGrid version 6.0.7200.218. An example would be even better. But just help on the design is also ok. I think because this is a common problem, maybe there is already an example somewhere.

Thanks

Unbound Server and client side creation

twor — Fri, 12 Feb 2010 12:16:35 GMT

Hello,

Im trying a cenario with webcombo box, and til now a could get all running correctly.

I was wondering if someone could give me an example of a unboud combo that gets its rows added in client side and another example in server side.

But i want this example of data:

text: item 1, value:1

text: item 2, value:2

and then i wanto to be able in client side and server side to get the onselecteditem the value of combo.

Can anyone help me?

Tanks

Expanded property row server-side

cymap — Wed, 19 Aug 2009 06:47:26 GMT

Thank you very much,

but I needed to know if there is a server-side property.

Greetings.

Agustin.

--------------------------------------------------------------------------------

Tuesday, August 18, 2009 3:10 AM

Carlos Gimenez CYMAP S.L. Joined on Nov 20, 2007 Spain	Expanded property row
	Hello. I would like to know which rows are expanded in a grid. I have searched properties in wedgrid.Rootable.rows (0) but not property that can be, and I suspect that all are false. Use LoadOnDemand. Thank you very much. Agustin.

Wednesday, August 19, 2009 3:05 AM

Handy Surya
Intersoft Solutions

Joined on Jun 5, 2007
Indonesia

Re: Expanded property row

Hello Agustin,

For now, we don't have special method about that. Only property. You will need to loop the first row until the last row and check the property if it is expanded or not.

grid.RootTable.GetRow(i).ChildExpanded;

Btw, thanks for your posting in here. However, for the next time issue, could you please post your questions in our new forum? We'll answer your questions there. http://www.intersoftpt.com/Community

Regards,
Handy