protected void GridWeb1_CustomCommand(object sender, string command)
{
// Groups Rows or Ungroup Rows.
if (GridWeb1.ActiveSheetIndex == 0)
{
switch (command)
{
case "GROUP":
if (GridWeb1.SelectCells != null && GridWeb1.SelectCells.Count > 0)
{
// Get Cell Selected CellArea
WebCellArea SelectedCells = (WebCellArea)GridWeb1.SelectCells[0];
// Group rows from starting cell to ending cell
GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex].GroupRows(SelectedCells.StartRow, SelectedCells.EndRow);
}
break;
case "UNGROUP":
if (GridWeb1.SelectCells != null && GridWeb1.SelectCells.Count > 0)
{
// Get Cell Selected CellArea
WebCellArea SelectedCells = (WebCellArea)GridWeb1.SelectCells[0];
// Group rows from starting cell to ending cell
GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex].UngroupRows(SelectedCells.StartRow, SelectedCells.EndRow);;
}
break;
}
}
}
private DataTable CreateDataTable(WebWorksheet sheet, WebCellArea area)
{
// Create a new DataTable.
System.Data.DataTable myDataTable = new DataTable("FromDataTable");
// Declare variables for DataColumn and DataRow objects.
DataColumn myDataColumn;
DataRow myDataRow;
for (int i = area.StartColumn; i < area.EndColumn; i++)
{
// Create new DataColumn, set DataType, ColumnName and add to DataTable.
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = sheet.Cells[area.StartRow, i].Value.ToString();
// Add the Column to the DataColumnCollection.
myDataTable.Columns.Add(myDataColumn);
}
// Create six column.
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.Int32");
myDataColumn.ColumnName = sheet.Cells[area.StartRow, area.EndColumn].Value.ToString();
// Add the column to the table.
myDataTable.Columns.Add(myDataColumn);
for (int i = area.StartRow + 1; i <= area.EndRow; i++)
{
myDataRow = myDataTable.NewRow();
for (int j = area.StartColumn; j <= area.EndColumn; j++)
{
myDataRow[sheet.Cells[0, j].Value.ToString()] = sheet.Cells[i, j].Value;
}
myDataTable.Rows.Add(myDataRow);
}
return(myDataTable);
}
private DataTable CreateDataTable(WebWorksheet sheet, WebCellArea area)
{
// Create a new DataTable.
System.Data.DataTable myDataTable = new DataTable("FromDataTable");
// Declare variables for DataColumn and DataRow objects.
DataColumn myDataColumn;
DataRow myDataRow;
for (int i = area.StartColumn; i < area.EndColumn; i++)
{
// Create new DataColumn, set DataType, ColumnName and add to DataTable.
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = sheet.Cells[area.StartRow, i].Value.ToString();
// Add the Column to the DataColumnCollection.
myDataTable.Columns.Add(myDataColumn);
}
// Create six column.
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.Int32");
myDataColumn.ColumnName = sheet.Cells[area.StartRow, area.EndColumn].Value.ToString();
// Add the column to the table.
myDataTable.Columns.Add(myDataColumn);
for (int i = area.StartRow + 1; i <= area.EndRow; i++)
{
myDataRow = myDataTable.NewRow();
for (int j = area.StartColumn; j <= area.EndColumn; j++)
{
myDataRow[sheet.Cells[0, j].Value.ToString()] = sheet.Cells[i, j].Value;
}
myDataTable.Rows.Add(myDataRow);
}
return myDataTable;
}
