WebWorksheet overview

Public Instance Constructors

WebWorksheet

Overloaded. Initializes a new instance of the WebWorksheet class.

Public Instance Properties

AppRelativeTemplateSourceDirectory (inherited from Control)	Gets or sets the application-relative virtual directory of the Page or UserControl object that contains this control.
BindColumns	Bind columns collection.
BindingContainer (inherited from Control)	Gets the control that contains this control's data binding.
BindingSource	The actually binding datasource object at run-time. It is a DataView object when the DataSource property is a DataSet, DataTable or DataView object.
BindStartColumn	In data-binding mode, BindStartRow and BindStartColumn indicate the position of the grid to bind bo the datasource.
BindStartRow	In data-binding mode, BindStartRow and BindStartColumn indicate the position of the grid to bind bo the datasource.
CellImages	Gets the CellImage and Hyperlink collection object.
Cells	Gets the WebCells.
ClientID (inherited from Control)	Gets the server control identifier generated by ASP.NET.
Comments	Gets the comment collection object.
Controls (inherited from Control)	Gets a ControlCollection object that represents the child controls for a specified server control in the UI hierarchy.
CurrentBindRows	Gets the binding rows number in data-binding mode.
DataMember	Gets or sets the DataMember from the multi-member DataSource. Generally it represents a DataTable object of a DataSet.
DataSource	Gets or sets the DataSource. Generally it's a DataSet object.
EnableCreateBindColumnHeader	In data-binding mode, indicates whether to create bind column header captions in the sheet.
EnableExpandChildView	In data-binding mode, indicates whether to enable user to expand rows that have child views.
EnableRowAddDelete	In data-binding mode, indicates whether to enable user add/delete row from client-side.
EnableTheming (inherited from Control)	Gets or sets a value indicating whether themes apply to this control.
EnableViewState (inherited from Control)	Gets or sets a value indicating whether the server control persists its view state, and the view state of any child controls it contains, to the requesting client.
ExcelShowDefaultGridLines	Indicates whether to show the default grid lines when export to an Excel file and view in MS-EXCEL.
ExcelShowHeaders	Indicates whether to show the row and column headers when export to an Excel file and view in MS-EXCEL.
FreezePaneInfo	Gets the freeze pane information.
Hyperlinks	Gets the Hyperlink collection object.
ID (inherited from Control)	Gets or sets the programmatic identifier assigned to the server control.
Index	Gets the index of itself within the WebWorksheets.
IsProtected	Gets or sets whether the worksheet is protected. When a worksheet is protected, all the cells can not be edit except the cell whose IsLocked property is false.
IsSummaryRowBelow	Indicates if the summary row will be positioned below the detail rows in the outline.
Name	Gets or sets the name of the sheet.
NamingContainer (inherited from Control)	Gets a reference to the server control's naming container, which creates a unique namespace for differentiating between server controls with the same ID property value.
Page (inherited from Control)	Gets a reference to the Page instance that contains the server control.
Parent (inherited from Control)	Gets a reference to the server control's parent control in the page control hierarchy.
RowFilter	Gets the RowFilterSettings object of the sheet.
Site (inherited from Control)	Gets information about the container that hosts the current control when rendered on a design surface.
SkinID (inherited from Control)	Gets or sets the skin to apply to the control.
TemplateControl (inherited from Control)	Gets or sets a reference to the template that contains this control.
TemplateSourceDirectory (inherited from Control)	Gets the virtual directory of the Page or UserControl that contains the current server control.
UniqueID (inherited from Control)	Gets the unique, hierarchically qualified identifier for the server control.
Visible	Indicates whether this sheet's name is shown in the sheet tabs of the control.

Public Instance Methods

ApplyStyleSheetSkin (inherited from Control)	Applies the style properties defined in the page style sheet to the control.
CancelNewBindRow	Cancels and deletes the new added bind row.
CommitNewBindRow	Commits the new added bind row and add it to the datasource.
Copy	Copies from another worksheet object.
CreateAutoGenratedColumns	After setting a datasource for the worksheet, call this method to generate the bind columns automatically.
CreateNewBindRow	Creates a new bind row and bind to the datasource.
CreateSubtotal	Overloaded. Creates subtotal in the sheet.
DataBind	Overloaded. Bind the sheet to the DataSource.
DeleteBindRow	Deletes a bind row.
Dispose (inherited from Control)	Enables a server control to perform final clean up before it is released from memory.
Equals (inherited from Object)	Determines whether the specified Object is equal to the current Object.
FindControl (inherited from Control)	Overloaded. Searches the current naming container for a server control with the specified id parameter.
Focus (inherited from Control)	Sets input focus to a control.
FreezePanes	Sets the freeze pane.
GetColumnHeaderHyperlink	Gets the hyperlink object of the column header.
GetColumnHeaderToolTip	Gets the columnheader's tooltip text.
GetHashCode (inherited from Object)	Serves as a hash function for a particular type. GetHashCode is suitable for use in hashing algorithms and data structures like a hash table.
GetRowBindObject	Gets the binding object of the row in binding mode. Generally it's a DataRowView object.
GetRowExpand	Gets a bool value that indicates whether the row is expanded and showing the child view content in the databinding mode.
GetRowHeaderToolTip	Gets the rowheader's tooltip text.
GetType (inherited from Object)	Gets the Type of the current instance.
GroupRows	Groups rows.
HasControls (inherited from Control)	Determines if the server control contains any child controls.
RemoveSubtotal	Removes subtotal created by the CreateSubtotal method in the sheet.
RenderControl (inherited from Control)	Overloaded. Outputs server control content to a provided HtmlTextWriter object and stores tracing information about the control if tracing is enabled.
ResolveClientUrl (inherited from Control)	Gets a URL that can be used by the browser.
ResolveUrl (inherited from Control)	Converts a URL into one that is usable on the requesting client.
SetAllCellsEditable	Makes all cells editable.
SetAllCellsReadonly	Makes all cells readonly.
SetColumnHeaderHyperlink	Sets the hyperlink object for the column header.
SetColumnHeaderToolTip	Sets the columnheader's tooltip text.
SetEditableRange	Makes a range of cells editable.
SetReadonlyRange	Makes a range of cells readonly.
SetRenderMethodDelegate (inherited from Control)	Assigns an event handler delegate to render the server control and its content into its parent control.
SetRowExpand	Sets whether the row is expanded and showing the child view content in the databinding mode.
SetRowHeaderToolTip	Sets the rowheader's tooltip text.
ToString (inherited from Object)	Returns a String that represents the current Object.
UnfreezePanes	Resets freeze pane(unfreeze).
UngroupRows	Ungroups rows.
UpdateBindCellValue	Updates the binding datasource record's property value according to the cell's value.

Public Instance Events

DataBinding (inherited from Control)	Occurs when the server control binds to a data source.
Disposed (inherited from Control)	Occurs when a server control is released from memory, which is the last stage of the server control lifecycle when an ASP.NET page is requested.
Init (inherited from Control)	Occurs when the server control is initialized, which is the first step in its lifecycle.
Load (inherited from Control)	Occurs when the server control is loaded into the Page object.
PreRender (inherited from Control)	Occurs after the Control object is loaded but prior to rendering.
Unload (inherited from Control)	Occurs when the server control is unloaded from memory.

Protected Instance Constructors

WebWorksheet

Overloaded. Initializes a new instance of the WebWorksheet class.

Protected Instance Properties

Adapter (inherited from Control)	Gets the browser-specific adapter for the control.
ChildControlsCreated (inherited from Control)	Gets a value that indicates whether the server control's child controls have been created.
ClientIDSeparator (inherited from Control)	Gets a character value representing the separator character used in the ClientID property.
Events (inherited from Control)	Gets a list of event handler delegates for the control. This property is read-only.
HasChildViewState (inherited from Control)	Gets a value indicating whether the current server control's child controls have any saved view-state settings.
IdSeparator (inherited from Control)	Gets the character used to separate control identifiers.
IsTrackingViewState (inherited from Control)	Gets a value that indicates whether the server control is saving changes to its view state.
LoadViewStateByID (inherited from Control)	Gets a value indicating whether the control participates in loading its view state by ID instead of index.
ViewState (inherited from Control)	Gets a dictionary of state information that allows you to save and restore the view state of a server control across multiple requests for the same page.
ViewStateIgnoresCase (inherited from Control)	Gets a value that indicates whether the StateBag object is case-insensitive.

Protected Instance Methods

AddParsedSubObject (inherited from Control)	Notifies the server control that an element, either XML or HTML, was parsed, and adds the element to the server control's ControlCollection object.
BuildProfileTree (inherited from Control)	Gathers information about the server control and delivers it to the Trace property to be displayed when tracing is enabled for the page.
ClearChildControlState (inherited from Control)	Deletes the control-state information for the server control's child controls.
ClearChildState (inherited from Control)	Deletes the view-state and control-state information for all the server control's child controls.
ClearChildViewState (inherited from Control)	Deletes the view-state information for all the server control's child controls.
CreateControlCollection (inherited from Control)	Creates a new ControlCollection object to hold the child controls (both literal and server) of the server control.
DataBind (inherited from Control)	Overloaded. Binds a data source to the invoked server control and all its child controls with an option to raise the DataBinding event.
DataBindChildren (inherited from Control)	Binds a data source to the server control's child controls.
EnsureChildControls (inherited from Control)	Determines whether the server control contains child controls. If it does not, it creates child controls.
EnsureID (inherited from Control)	Creates an identifier for controls that do not have an identifier assigned.
Finalize (inherited from Object)	Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
FindControl (inherited from Control)	Overloaded. Searches the current naming container for a server control with the specified id and an integer, specified in the pathOffset parameter, which aids in the search. You should not override this version of the FindControl method.
GetDesignModeState (inherited from Control)	Gets design-time data for a control.
HasEvents (inherited from Control)	Returns a value indicating whether events are registered for the control or any child controls.
IsLiteralContent (inherited from Control)	Determines if the server control holds only literal content.
LoadViewState (inherited from Control)	Restores view-state information from a previous page request that was saved by the SaveViewState method.
MemberwiseClone (inherited from Object)	Creates a shallow copy of the current Object.
OnBubbleEvent (inherited from Control)	Determines whether the event for the server control is passed up the page's UI server control hierarchy.
OnDataBinding	Internal used only.
RaiseBubbleEvent (inherited from Control)	Assigns any sources of the event and its information to the control's parent.
RenderControl (inherited from Control)	Overloaded. Outputs server control content to a provided HtmlTextWriter object using a provided ControlAdapter object.
ResolveAdapter (inherited from Control)	Gets the control adapter responsible for rendering the specified control.
SaveViewState (inherited from Control)	Saves any server control view-state changes that have occurred since the time the page was posted back to the server.
SetDesignModeState (inherited from Control)	Sets design-time data for a control.
TrackViewState (inherited from Control)	Causes tracking of view-state changes to the server control so they can be stored in the server control's StateBag object. This object is accessible through the ViewState property.

Protected Internal Instance Properties

Context (inherited from Control)	Gets the HttpContext object associated with the server control for the current Web request.
DesignMode (inherited from Control)	Gets a value indicating whether a control is being used on a design surface.
IsChildControlStateCleared (inherited from Control)	Gets a value indicating whether controls contained within this control have control state.
IsViewStateEnabled (inherited from Control)	Gets a value indicating whether view state is enabled for this control.

Protected Internal Instance Methods

AddedControl (inherited from Control)	Called after a child control is added to the Controls collection of the Control object.
CreateChildControls (inherited from Control)	Called by the ASP.NET page framework to notify server controls that use composition-based implementation to create any child controls they contain in preparation for posting back or rendering.
LoadControlState (inherited from Control)	Restores control-state information from a previous page request that was saved by the SaveControlState method.
MapPathSecure (inherited from Control)	Retrieves the physical path that a virtual path, either absolute or relative, maps to.
OnInit (inherited from Control)	Raises the Init event.
OnLoad (inherited from Control)	Raises the Load event.
OnPreRender (inherited from Control)	Raises the PreRender event.
OnUnload (inherited from Control)	Raises the Unload event.
OpenFile (inherited from Control)	Gets a Stream used to read a file.
RemovedControl (inherited from Control)	Called after a control is removed from the Controls collection of another control.
Render (inherited from Control)	Sends server control content to a provided HtmlTextWriter object, which writes the content to be rendered on the client.
RenderChildren (inherited from Control)	Outputs the content of a server control's children to a provided HtmlTextWriter object, which writes the content to be rendered on the client.
SaveControlState (inherited from Control)	Saves any server control state changes that have occurred since the time the page was posted back to the server.

See Also

WebWorksheet Class | Aspose.Grid.Web.Data Namespace