I failed to attach the database you send. Which SQL server are you using? Do you mind sending us a SQL script for the database? This way we could avoid any version mismatch issue.

We already have some sample regarding WebScheduler data editing, such as DataEditing.aspx, which you could try the adding, editing, and deleting operation. Does the issue also occurs in the provided sample?

Attached is a simple sample of WebGrid with programatic data bind and retrieve structure functionality. It is demonstrated that adding the field to sorted column collection after retrieve structure will sort the WebGrid data.

The data binding is performed in the InitializeDataSource server side event handler, while the retrieve structure will be performed during the PrepareDataBinding server side event handler.

I am using northwind.mdb employees table in order to recreate the scenario youe facing, self reference with update enabled WebGrid. However I could not replicate the paging edit issue.

Do you mind sending us a simple sample of the WebPart so we could replicate the issue? This way we could also have a clearer picture for the issue #1. Did you use other feature in the WebGrid; batch update, unbound grid? If the sample contains proprietary information, you could send them to technical@intersoftpt.com with a reference for this thread.

The required resource and deployment in Sharepoint has already discussed in our whitepaper titled Using WebGrid.NET Enterprise 6.0 in Microsoft SharePoint Designer 2007 and Using WebGrid.NET Enterprise 6.0 as WebPart in Microsoft Office SharePoint Server 2007 which you could download in our support site under WebGrid -> White Paper section

We have already provide an ActivateEdit function on the cell level, you could use that function instead of ActivateEditMode on the grid level to focus on individual row. Here is a snippet for such scenario, focusing on the first cell:

function wgTest_OnRowValidate(rowElem)
{
    var grid = ISGetObject("wgTest");
    var rowObj = grid.GetRowByElement(rowElem);
    
    rowObj.GetCell(0).ActivateEdit();

    return false;
}

We call the area Drop Zone, and in order to show the field in the drop zone you will need to fill the collection during page load server side event handler. You could determine if the grid is in charting mode by inspecting the ActionMode property. Here is the snippet for C#:

protected void Page_Load(object sender, EventArgs e)
{     
    if (wgTest.ActionName == "Charting")
    {
        wgTest.ChartCategoryCollection.Add(new ChartPivotFilterConfig() { DataMember = "Interest" });
        wgTest.ChartDataCollection.Add(new ChartPivotDataConfig() { DataMember = "ID" });
    }
}

In my previous snippet, I use lambda expression in order to fill the property of the ChartPivotDataConfig and ChartPivotFilterConfig property, for example:

New ChartPivotDataConfig() With {.DataMember = "ID"}
New ChartPivotFilterConfig() With {.DataMember = "Interest"}

From your snippet this will be:

New ChartPivotDataConfig() With {.DataMember = "quantity", .AutoCalc = AutoCalc.Sum}
New ChartPivotFilterConfig() With {.DataMember = "ubicacion"}