Intersoft Community - dynamically

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

WebPaneManager - Finding Dynamic Controls

ezekiel571 — Sat, 03 Sep 2011 00:47:43 GMT

Im using the WebPaneManager and building expanding panes with checkboxes dynamically using values from a database. Each pane expands with another dynamically created datagrid in the subpane.

I saw a post saying that there is no need to use findcontrol inside webpanemanager, just call the control directly. What should I do in my situation where I wont know the name of the control until page load? Can I force it to find my control somehow?

Thanks in advance!

Ez571

How to enable / disable freezing depending on data

Eric — Fri, 03 Sep 2010 09:41:51 GMT

There is a related sample in this thread: http://www.intersoftpt.com/Community/WebGrid/WebGrid-crash-scrolling-freeze-column-hidden/

When I have no data for the grid, I want to hide all columns, create my own dataset add a row and write the text "no data" into this first row's first column. This is done in the InitializeDataSource event.

In PreRender event I check if there is only this one row with this special text. If yes, I hide all columns (now works after you fixed the crash mentioned in the other thread).

Problem is now that I cannot dynamically enable/disable the column freezing. For normal display, I want the first column to freeze (not modifiable by user). But when I hide all columns when no data is present, I get the error message "Freeze Pane cannot be activated on this column because it has exceeded the maximum size of scrollable viewport."

I assume this is because there is nothing to show (message is probably slightly wrong). So I should disable the frozen columns in the PreRender event somehow. I couldn't get that working. Or leave freezing away in aspx page and enable it for normal data.

In grid's LayoutSettings I have:

<FreezePaneSettings AbsoluteScrolling="true" ActiveFrozenColumns="1" MaxFrozenColumns="1" ShowSplitterLine="False" /> In PreRender I tried to disable these values without success. I also tried leaving the above tag away and adding these values in PreRender.

I also tried to set/change the value grdResult.LayoutSettings.AllowColumnFreezing. But that caused WebGrid to crash in some JavaScript.

How do I disable/enable column freezing depending on the data I have?

WebDesktop - Programmatically Create Shortcuts

alex@millhorn.com — Tue, 13 Oct 2009 15:40:39 GMT

Good day,

I'd like to make our WebDesktop shortcuts / taskbar items populate dynamically based upon the privs of the currently logged in user. Can you kindly provide C# examples for programmatically creating a shortcut, specifying its targetURL, iconURL, and window properties.

Thank you in advance.