Intersoft Community - WebGrid Enterprise - SaveLayour and CheckedRows array

SaveLayour and CheckedRows array

leo.c — Thu, 18 Jun 2015 02:53:09 GMT

Hi John,

You're welcome. Glad that it worked for you.

Best Regards,
Leo

SaveLayour and CheckedRows array

John.Bonin@dot.gov — Wed, 17 Jun 2015 11:02:38 GMT

Thank you so much, this solves the problem. We are 3 weeks away from release and this was a major feature that all users were requesting. Again THANK YOU.

SaveLayour and CheckedRows array

leo.c — Wed, 17 Jun 2015 04:11:01 GMT

Hi John,

I have look at your sample. Changing your sample WebGrid1_PrepareDataBinding to the following should solved your issue:

Protected Sub WebGrid1_PrepareDataBinding(ByVal sender As Object, ByVal e As ISNet.WebUI.WebGrid.DataSourceEventArgs) Handles WebGrid1.PrepareDataBinding
	' This function will restore to the Filter Row the saved filter
	If Not IsPostBack Then
		Dim _file As String = Server.MapPath("~/App_Data/UserLayout/UserStructure.xml")
		If IO.File.Exists(_file) Then
			With Me.WebGrid1
				.LoadTablesStructureFromXml(_file)
				.RootTable.FilteredColumns.Clear()
				.RootTable.GroupedColumns.Clear()
			End With
		End If
                // Add Following Line
		WebGrid1.RootTable.DataKeyField = "CustomerID"
	End If
End Sub

Hope this help could help you.

Best Regards,
Leo

SaveLayour and CheckedRows array

John.Bonin@dot.gov — Wed, 10 Jun 2015 14:33:07 GMT

"Support requests are answered in less than 48-hours, guaranteed."

Well....

SaveLayour and CheckedRows array

John.Bonin@dot.gov — Tue, 09 Jun 2015 11:56:52 GMT

Its been over 6 days and still no word from intersoft! Why?

SaveLayour and CheckedRows array

John.Bonin@dot.gov — Wed, 03 Jun 2015 11:53:27 GMT

Support?

I can reproduce this is with the 2014 R2 samples. Replace the attached files to the WebGrid samples and run. First off using the Column Select Action, Select Columns and hide one or 2 columns from Grid, then click on Save Layout button. Next you need to refresh page or better still close browser and rerun. Then select a few rows and click on Get Checked Row in Server button and you will see the error. If you look at the CheckRows array list you will notice that the values for each row is empty.

Please look as I need to get this fixed.

thanks

SaveLayour and CheckedRows array

John.Bonin@dot.gov — Mon, 01 Jun 2015 15:49:23 GMT

Hi,

I am using the SaveLayout functionality to allow user to save the current grid's layout. In most cases it works fine. I do have one problem.

The grid uses a RowChecker column that allows the user to select multiple rows and then do something to all checked rows. It creates an ArrayList of the CheckedRows using:

Dim checkedRows As ArrayList = WebGrid1.RootTable.GetCheckedRows()

If the layout is not saved, the array list (checkedRows) contains a list of all the DataKeyField values for each row (The DataKeyField is set in the RootTable tag). If I save the layout and select a few rows, using the RowChecker column, the array list will contain a list of empty strings. For example if I select 2 rows, the array list will have a count of 2, but the values are empty.

So using the code below, keyValue is an empty string, so gettting the value of a column in the select row returns an error, since keyValue is empty. Again this only fails if I have save/restore the layout.

For Each keyValue As String In checkedRows
xname = WebGrid1.RootTable.GetUngrouppedRows().GetRowByKeyValue(keyValue).Cells.GetNamedItem("xName").Text
Next

I've attached the SaveLayout XML files that are created if they help.

Any ideas?