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; }