Intersoft Community - serverside

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

How to:get the value of a selected Column on serverside?

qq397472251 — Mon, 16 Aug 2010 04:10:18 GMT

How to:get the value of a selected Column on serverside?

Help!

Remove selected Items from Grid serverside

p.kidd@btinternet.com — Thu, 20 Aug 2009 07:33:12 GMT

I use the ObjectDataSource to bind the grid to my business layer.

My users will filter the returned data and then set the checked row checkbox for multiple entries.

They then select an external to grid update button to update the database with the changes.

I tried webGrid1.databind server side, but no luck.

How do I now get the grid to refresh with the entries now removed?

For Each keyValue As String In WebGrid1.RootTable.GetCheckedRows()

clsExtractManager.Save(CInt(keyValue), "Sideline", True, intUserID)

WebGrid1.Databind()