protected void btnApplyNumberFormats_Click(object sender, EventArgs e)
{
// ExStart:ApplyNumberFormats
// Accessing the reference of the worksheet that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
sheet.Cells.Clear();
sheet.Cells.SetColumnWidth(0, new Unit(200, UnitType.Point));
sheet.Cells.SetRowHeight(0, new Unit(50, UnitType.Point));
// Putting values to cells
sheet.Cells["A1"].PutValue("Currency1 Number Format");
sheet.Cells["A2"].PutValue("Custom Number Format");
sheet.Cells["B1"].PutValue(7800);
sheet.Cells["B2"].PutValue(2500);
// Setting the number format of "B1" cell to Currency1
Aspose.Cells.GridWeb.TableItemStyle style = sheet.Cells["B1"].GetStyle();
style.NumberType = NumberType.Currency1;
sheet.Cells["B1"].SetStyle(style);
// Setting the custom number format of "B2" cell
style = sheet.Cells["B2"].GetStyle();
style.Custom = "#,##0.0000";
sheet.Cells["B2"].SetStyle(style);
// ExEnd:ApplyNumberFormats
}
private void AddTextHyperlinks()
{
// ExStart:AddTextHyperlinks
//Accessing the reference of the worksheet that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Adds a text hyperlink that gos to Aspose site and opens in new window
Hyperlink link1 = sheet.Hyperlinks.AddHyperlink("B1");
link1.Target = "_blank";
// Setting text of the hyperlink
link1.Text = "Aspose";
// Setting URL of the hyperlink
link1.Url = "http://www.aspose.com";
// Setting tool tip of the hyperlink
link1.ToolTip = "Open Aspose Web Site in new window";
// Adding hyperlink to the worksheet to open in parent window
Hyperlink link2 = sheet.Hyperlinks.AddHyperlink("B2");
link2.Target = "_parent";
// Setting text of the hyperlink
link2.Text = "Aspose.Grid Docs";
// Setting URL of the hyperlink
link2.Url = "http://www.aspose.com/docs/display/cellsnet/Aspose.Cells.GridWeb";
// Setting tool tip of the hyperlink
link2.ToolTip = "Open Aspose.Grid Docs in parent window";
// ExEnd:AddTextHyperlinks
}
protected void btnAddListValidation_Click(object sender, EventArgs e)
{
// ExStart:AddListValidation
// Accessing the cells collection of the worksheet that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Accessing "B1" cell
WebCell cell = sheet.Cells[0, 1];
// Putting value to "B1" cell
cell.PutValue("Select Course:");
// Accessing "C1" cell
cell = sheet.Cells[0, 2];
// Creating List validation for the "C1" cell
cell.CreateValidation(ValidationType.List, true);
// Adding values to List validation
cell.Validation.ValueList.Add("Fortran");
cell.Validation.ValueList.Add("Pascal");
cell.Validation.ValueList.Add("C++");
cell.Validation.ValueList.Add("Visual Basic");
cell.Validation.ValueList.Add("Java");
cell.Validation.ValueList.Add("C#");
// ExEnd:AddListValidation
}
protected void btnApplyBorderStyles_Click(object sender, EventArgs e)
{
// ExStart:ApplyBorderStyles
// Accessing the reference of the worksheet that is currently active and resize first row and column
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
sheet.Cells.Clear();
sheet.Cells.SetColumnWidth(0, new Unit(200, UnitType.Point));
sheet.Cells.SetRowHeight(0, new Unit(50, UnitType.Point));
// Accessing a specific cell of the worksheet
WebCell cell = sheet.Cells["A1"];
Aspose.Cells.GridWeb.TableItemStyle style = cell.GetStyle();
// Setting the border style to Solid
style.BorderStyle = BorderStyle.Solid;
// Setting the border width to 2 pixels
style.BorderWidth = new Unit(2, UnitType.Pixel);
// Setting the border color to Blue
style.BorderColor = Color.Blue;
// Set the cell style
cell.SetStyle(style);
// ExEnd:ApplyBorderStyles
}
protected void btnCreate_Click(object sender, System.EventArgs e)
{
// Fill web worksheet object
WebWorksheet sheet = GridWeb1.WebWorksheets[0];
// Removes the created subtotal first.
//sheet.RemoveSubtotal();
// Creates the subtotal.
int groupByIndex;
if (ddlSort.SelectedItem.Value == "CategoryName")
{
groupByIndex = 1;
}
else
{
groupByIndex = 2;
}
// Creates GrandTotal and Subtotal style.
Aspose.Cells.GridWeb.TableItemStyle grandStyle = new Aspose.Cells.GridWeb.TableItemStyle();
grandStyle.BackColor = Color.Gray;
grandStyle.ForeColor = Color.Black;
Aspose.Cells.GridWeb.TableItemStyle subtotalStyle = new Aspose.Cells.GridWeb.TableItemStyle();
subtotalStyle.BackColor = Color.SkyBlue;
subtotalStyle.ForeColor = Color.Black;
// ExStart:CreateSubTotal
sheet.CreateSubtotal(0, sheet.Cells.MaxRow, groupByIndex, (SubtotalFunction)System.Enum.Parse(typeof(SubtotalFunction), ddlFunction.SelectedItem.Value), new int[] { 1, 2, 3, 4, 5 }
, ddlFunction.SelectedItem.Text, grandStyle, subtotalStyle, NumberType.General, null);
// ExEnd:CreateSubTotal
}
private void AddCellCommandHyperlinks()
{
// ExStart:AddCellCommandHyperlinks
// Accessing the reference of the worksheet that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Adding hyperlink to the worksheet
Hyperlink link1 = sheet.Hyperlinks.AddHyperlink("B8");
// Setting the action type of the link to CellCommand
link1.ActionType = HyperlinkActionType.CellCommand;
// Setting the cell command for the link
link1.CellCommand = "Click";
// Setting tool tip of the hyperlink
link1.ToolTip = "Click Here";
// Setting URL of the button image that will be displayed as hyperlink
link1.ImageUrl = "../Images/button.jpg";
// Resize the row to display image nicely
sheet.Cells.SetRowHeight(7, 30);
// ExEnd:AddCellCommandHyperlinks
}
protected void chkSelectedCells_CheckedChanged(object sender, EventArgs e)
{
chkAllCells.Checked = false;
if (chkSelectedCells.Checked)
{
// ExStart:MakeSelectedCellsEditable
// Accessing the reference of the worksheet that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Setting all cells of the worksheet to Readonly first
sheet.SetAllCellsReadonly();
// Finally, Setting selected cells of the worksheet to Editable
sheet.SetEditableRange(3, 2, 4, 1);
// ExEnd:MakeSelectedCellsEditable
Label1.Text = "4 rows and 1 column are editable starting from row 4 and column 3";
}
else
{
// ExStart:MakeSelectedCellsReadOnly
// Accessing the reference of the worksheet that is currently active
GridWorksheet sheet = GridWeb1.WorkSheets[GridWeb1.ActiveSheetIndex];
// Setting all cells of the worksheet to Editable first
sheet.SetAllCellsEditable();
// Finally, Setting selected cells of the worksheet to Readonly
sheet.SetReadonlyRange(3, 2, 4, 1);
// ExEnd:MakeSelectedCellsReadOnly
Label1.Text = "4 rows and 1 column are readonly starting from row 4 and column 3";
}
}
protected void chkMergeCells_CheckedChanged(object sender, EventArgs e)
{
if (chkMergeCells.Checked)
{
// ExStart:MergeCells
// Accessing the reference of the worksheet that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Merging cells starting from the cell with 3rd row and 3rd column.
// 2 rows and 2 columns will be merged from the starting cell
sheet.Cells.Merge(2, 2, 2, 2);
// ExEnd:MergeCells
Label1.Text = "2 rows and 2 columns are merged starting from row 3 and column 3";
}
else
{
// ExStart:UnmergeCells
// Accessing the reference of the worksheet that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Unmerging cells starting from the cell with 3rd row and 3rd column.
// 2 rows and 2 columns will be unmerged from the starting cell
sheet.Cells.UnMerge(2, 2, 2, 2);
// ExEnd:UnmergeCells
Label1.Text = "2 rows and 2 columns are unmerged starting from row 3 and column 3";
}
}
protected void btnAddCustomValidation_Click(object sender, EventArgs e)
{
// ExStart:AddCustomValidation
// Accessing the cells collection of the worksheet that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Accessing "B1" cell
WebCell cell = sheet.Cells[0, 1];
// Putting value to "B1" cell
cell.PutValue("Date (yyyy-mm-dd):");
// Accessing "C1" cell
cell = sheet.Cells[0, 2];
// Creating a custom expression validation for the "C1" cell
cell.CreateValidation(ValidationType.CustomExpression, true);
// Setting regular expression for the validation to accept dates in yyyy-mm-dd format
cell.Validation.RegEx = @"\d{4}-\d{2}-\d{2}";
// ExEnd:AddCustomValidation
sheet.Cells.SetColumnWidth(1, new Unit(100, UnitType.Point));
// Assigning the name of JavaScript function to OnValidationErrorClientFunction property of GridWeb
GridWeb1.OnValidationErrorClientFunction = "ValidationErrorFunction";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack && !GridWeb1.IsPostBack)
{
// Create dataset object
this.dataSet11 = new DataSet1();
// Create web worksheet object
WebWorksheet sheet = GridWeb1.WebWorksheets[0];
// Specifies the datasource for the sheet.
sheet.DataSource = dataSet11;
sheet.DataMember = "Products";
// Creates in-sheet column headers.
sheet.EnableCreateBindColumnHeader = true;
// Data cells begin at row 1;
sheet.BindStartRow = 1;
// Creates the data field column automatically.
sheet.CreateAutoGenratedColumns();
// Modifies a column's number type.
sheet.BindColumns["UnitPrice"].NumberType = NumberType.Currency3;
// The "product name" field is required.
Aspose.Cells.GridWeb.Validation v = new Aspose.Cells.GridWeb.Validation();
v.IsRequired = true;
sheet.BindColumns["ProductName"].Validation = v;
// Modifies column headers' background color.
for (int i = 0; i < sheet.BindColumns.Count; i++)
{
sheet.BindColumns[i].ColumnHeaderStyle.BackColor = Color.SkyBlue;
}
// Create demo database object
ExampleDatabase db = new ExampleDatabase();
// Create path to database file
string path = (this.Master as Site).GetDataDir();
// Create connection string
db.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "\\Miscellaneous\\Database\\demos.mdb";
try
{
// Loads data from database.
db.oleDbDataAdapter1.Fill(dataSet11);
}
finally
{
// Close connection
db.oleDbConnection1.Close();
}
// Binding.
sheet.DataBind();
}
}
private void InitGridWeb()
{
// ExStart:WriteClientSideScript
// Assigning the name of JavaScript function to OnSubmitClientFunction property of GridWeb
GridWeb1.OnSubmitClientFunction = "ConfirmFunction";
// Assigning the name of JavaScript function to OnValidationErrorClientFunction property of GridWeb
GridWeb1.OnValidationErrorClientFunction = "ValidationErrorFunction";
// Accessing the cells collection of the worksheet that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Accessing "B1" cell
WebCell cell = sheet.Cells[0, 1];
// Putting value to "B1" cell
cell.PutValue("Date (yyyy-mm-dd):");
// Accessing "C1" cell
cell = sheet.Cells[0, 2];
// Creating a custom expression validation for the "C1" cell
cell.CreateValidation(ValidationType.CustomExpression, true);
// Setting regular expression for the validation to accept dates in yyyy-mm-dd format
cell.Validation.RegEx = @"\d{4}-\d{2}-\d{2}";
// ExEnd:WriteClientSideScript
}
// Initialize new bind row.
private void GridWeb1_InitializeNewBindRow(WebWorksheet sender, object bindObject)
{
// Handles the initialize new bind row event.
MyCustomRecord rec = (MyCustomRecord)bindObject;
rec.DateField1 = DateTime.Now;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack && !GridWeb1.IsPostBack)
{
// Creates the collection.
MyCollection list = new MyCollection();
System.Random rand = new System.Random();
for (int i = 0; i < 5; i++)
{
// Create custom record object and set properties
MyCustomRecord rec = new MyCustomRecord();
rec.DateField1 = DateTime.Now;
rec.DoubleField1 = rand.NextDouble();
rec.IntField1 = rand.Next();
rec.StringField1 = "ABC_" + i;
((IList)list).Add(rec);
}
// Create web worksheet object
WebWorksheet sheet = GridWeb1.WebWorksheets[0];
// Uses the collection as datasource.
sheet.DataSource = list;
// Creates bind columns.
sheet.CreateAutoGenratedColumns();
// Sets the DateFiled1's validation to DateTime.
sheet.BindColumns["DateField1"].Validation.ValidationType = ValidationType.DateTime;
// Binding.
sheet.DataBind();
}
}
private void AccessCellByRowColumnIndex()
{
// ExStart:AccessCellByRowColumnIndex
// Accessing the worksheet of the Grid that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Accessing "B1" cell of the worksheet using its row and column indices
WebCell cell = sheet.Cells[0, 1];
// Display cell name and value
Label1.Text += "Cell Value of " + cell.Name + " is " + cell.StringValue + "<br/>";
// ExEnd:AccessCellByRowColumnIndex
}
private void AccessCellByName()
{
// ExStart:AccessCellByName
// Accessing the worksheet of the Grid that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Accessing "B1" cell of the worksheet
WebCell cell = sheet.Cells["A1"];
// Display cell name and value
Label1.Text += "Cell Value of " + cell.Name + " is " + cell.StringValue + "<br/>";
// ExEnd:AccessCellByName
}
private void AddIntValue()
{
// ExStart:AddCellIntValue
// Accessing the worksheet of the Grid that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Accessing "B3" cell of the worksheet
WebCell cell = sheet.Cells["B3"];
// Putting a value in "B3" cell
cell.PutValue(30);
// ExEnd:AddCellIntValue
}
private void AddStringValue()
{
// ExStart:AddCellStringValue
// Accessing the worksheet of the Grid that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Accessing "B1" cell of the worksheet
WebCell cell = sheet.Cells["B1"];
// Accessing & modifying the string value of "B1" cell
cell.StringValue = "Hello Aspose.Grid";
// ExEnd:AddCellStringValue
}
private void AddDoubleValue()
{
// ExStart:AddCellDoubleValue
// Accessing the worksheet of the Grid that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Accessing "B5" cell of the worksheet
WebCell cell = sheet.Cells["B5"];
// Putting a numeric value as string in "B5" cell that will be converted to a suitable data type automatically
cell.PutValue("19.4", true);
// ExEnd:AddCellDoubleValue
}
private void BindWithInSheetHeaders()
{
// Create dataset object
this.dataSet11 = new DataSet1();
// Create database object
ExampleDatabase db = new ExampleDatabase();
// Create path to database file
string path = (this.Master as Site).GetDataDir();
// Create connection string
db.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "\\Miscellaneous\\Database\\demos.mdb";
try
{
// Connects to database and fetches data.
db.oleDbDataAdapter1.Fill(dataSet11);
// Create webworksheet object
WebWorksheet sheet = GridWeb1.WebWorksheets[0];
// Clears the sheet.
sheet.Cells.Clear();
// Enables creating in-sheet headers.
sheet.EnableCreateBindColumnHeader = true;
// Data cells begin from row 2.
sheet.BindStartRow = 2;
// Creates some title cells.
sheet.Cells["A1"].PutValue("The Product Table");
sheet.Cells["A1"].GetStyle().Font.Size = new FontUnit("20pt");
sheet.Cells["A1"].GetStyle().HorizontalAlign = HorizontalAlign.Center;
sheet.Cells["A1"].GetStyle().VerticalAlign = VerticalAlign.Middle;
sheet.Cells["A1"].GetStyle().BackColor = Color.SkyBlue;
sheet.Cells["A1"].GetStyle().ForeColor = Color.Blue;
sheet.Cells.Merge(0, 0, 2, 11);
// Freezes the header rows.
sheet.FreezePanes(3, 0, 3, 0);
// Bind the sheet to the dataset.
sheet.DataBind();
}
finally
{
//Close connection
db.oleDbConnection1.Close();
}
}
private void BindWithoutInSheetHeaders()
{
//Create dataset object
this.dataSet21 = new DataSet2();
//Create demo database
DemoDatabase2 db = new DemoDatabase2();
//Create path to database file
string path = Server.MapPath("~");
path = path.Substring(0, path.LastIndexOf("\\"));
//Create connection to database
db.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "\\Database\\Northwind.mdb";
try
{
// Connects to database and fetches data.
// Customers Table.
db.oleDbDataAdapter1.Fill(dataSet21);
// Orders Table.
db.oleDbDataAdapter2.Fill(dataSet21);
// OrderDetailTable.
db.oleDbDataAdapter3.Fill(dataSet21);
// Filter data
//dataSet21.Customers.DefaultView.RowFilter = "CustomerID<'BSAAA'";
//Create web worksheet object
WebWorksheet sheet = GridWeb1.WebWorksheets[0];
// Clears the sheet.
sheet.Cells.Clear();
// Disables creating in-sheet headers.
sheet.EnableCreateBindColumnHeader = false;
// Data cells begin from row 0.
sheet.BindStartRow = 0;
// Bind the sheet to the dataset.
sheet.DataSource = dataSet21;
sheet.DataBind();
}
finally
{
//Close connection
db.oleDbConnection1.Close();
}
}
// ExStart:HandleCustomCommandEvent
// Creating Event Handler for CustomCommand event
protected void GridWeb1_CustomCommand(object sender, string command)
{
// Identifying a specific button by checking its command
if (command.Equals("MyButton"))
{
// Accessing the cells collection of the worksheet that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Putting value to "A1" cell
sheet.Cells["A1"].PutValue("My Custom Command Button is Clicked.");
// Set first column width to make the text visible
sheet.Cells.SetColumnWidth(0, new Unit(200, UnitType.Point));
}
}
// ExStart:HandleCellCommandHyperlinkEvent
// Event Handler for CellCommand event
protected void GridWeb1_CellCommand(object sender, Aspose.Cells.GridWeb.CellEventArgs e)
{
// Checking the CellCommand of the hyperlink
if (e.Argument.Equals("Click"))
{
// Accessing the reference of the worksheet that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Adding value to "C8" cell
sheet.Cells["C8"].PutValue("Cell Command Hyperlink Clicked");
// Resize the column to display message nicely
sheet.Cells.SetColumnWidth(2, 250);
}
}
protected void btnDeleteRow_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
// ExStart:DeleteRow
// Accessing the reference of the worksheet that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Get row index entered by user
int rowIndex = Convert.ToInt16(txtRowIndex.Text.Trim());
// Delete row at specified index
sheet.Cells.DeleteRow(rowIndex);
// ExEnd:DeleteRow
}
}
protected void btnAddColumn_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
// ExStart:AddColumn
// Accessing the reference of the worksheet that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Get column index entered by user
int columnIndex = Convert.ToInt16(txtColumnIndex.Text.Trim());
// Add column at specified index
sheet.Cells.InsertColumn(columnIndex);
// ExEnd:AddColumn
}
}
protected void btnExportDataTable_Click(object sender, EventArgs e)
{
// ExStart:ExportDataTable
// Creating a new DataTable object
DataTable dataTable = new DataTable();
// Adding specific columns to the DataTable object
dataTable.Columns.Add("Name", System.Type.GetType("System.String"));
dataTable.Columns.Add("Gender", System.Type.GetType("System.String"));
dataTable.Columns.Add("Age", System.Type.GetType("System.Int32"));
dataTable.Columns.Add("Class", System.Type.GetType("System.String"));
// Accessing the reference of the worksheet that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Getting the total number of rows and columns inside the worksheet
int totalColumns = sheet.Cells.MaxColumn + 1;
int totalRows = sheet.Cells.MaxRow + 1;
// Exporting the data of the active worksheet to a specific DataTable object
dataTable = sheet.Cells.Export(0, 0, totalRows, totalColumns, true, true);
// Display exported data table in GridView
GridView1.DataSource = dataTable;
GridView1.DataBind();
// ExEnd:ExportDataTable
// ExStart:ExportNewDataTable
// Accessing the reference of the worksheet that is currently active
WebWorksheet sheet1 = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Getting the total number of rows and columns inside the worksheet
int totalColumns1 = sheet.Cells.MaxColumn + 1;
int totalRows1 = sheet.Cells.MaxRow + 1;
// Exporting the data of the active worksheet to a new DataTable object
DataTable dt = sheet.Cells.Export(0, 0, totalRows1, totalColumns1, true, true);
// Display exported data table in GridView
GridView2.DataSource = dataTable;
GridView2.DataBind();
// ExEnd:ExportNewDataTable
trResult.Visible = true;
}
private void BindWithoutInSheetHeaders()
{
// Create dataset object
this.dataSet21 = new DataSet2();
// Create demo database
DemoDatabase2 db = new DemoDatabase2();
// Create path to database file
string path = (this.Master as Site).GetDataDir();
// Create connection string
db.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "\\Miscellaneous\\Database\\Northwind.mdb";
try
{
// Connects to database and fetches data.
// Customers Table.
db.oleDbDataAdapter1.Fill(dataSet21);
// Orders Table.
db.oleDbDataAdapter2.Fill(dataSet21);
// OrderDetailTable.
db.oleDbDataAdapter3.Fill(dataSet21);
// Create web worksheet object
WebWorksheet sheet = GridWeb1.WebWorksheets[0];
// Clears the sheet.
sheet.Cells.Clear();
// Disables creating in-sheet headers.
sheet.EnableCreateBindColumnHeader = false;
// Data cells begin from row 0.
sheet.BindStartRow = 0;
// Bind the sheet to the dataset.
sheet.DataSource = dataSet21;
sheet.DataBind();
}
finally
{
//Close connection
db.oleDbConnection1.Close();
}
}
private void BindWithoutInSheetHeaders()
{
// Create dataset object
this.dataSet11 = new DataSet1();
// Create database object
ExampleDatabase db = new ExampleDatabase();
// Create path to database file
string path = (this.Master as Site).GetDataDir();
// Create connection string
db.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "\\Miscellaneous\\Database\\demos.mdb";
try
{
// Connects to database and fetches data.
db.oleDbDataAdapter1.Fill(dataSet11);
// Create web worksheet object
WebWorksheet sheet = GridWeb1.WebWorksheets[0];
// Clears the sheet.
sheet.Cells.Clear();
sheet.Cells.UnMerge(0, 0, 2, 11);
// Disables creating in-sheet headers.
sheet.EnableCreateBindColumnHeader = false;
// Data cells begin from row 0.
sheet.BindStartRow = 0;
// Unfreezes the header rows.
sheet.UnfreezePanes();
// Bind the sheet to the dataset.
sheet.DataBind();
}
finally
{
// Close database connection
db.oleDbConnection1.Close();
}
}
private void BindWithoutInSheetHeaders()
{
//Create database object
this.dataSet11 = new Aspose.Cells.GridWeb.DemosCS.DataBind.DataSet1();
//Create demo database object
DemoDatabase db = new DemoDatabase();
//Create path to database file
string path = Server.MapPath("~");
path = path.Substring(0, path.LastIndexOf("\\"));
//Create connection string to database file
db.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "\\Database\\demos.mdb";
try
{
// Connects to database and fetches data.
db.oleDbDataAdapter1.Fill(dataSet11);
//Create web worksheet object
WebWorksheet sheet = GridWeb1.WebWorksheets[0];
// Clears the sheet.
sheet.Cells.Clear();
sheet.Cells.UnMerge(0, 0, 2, 11);
// Disables creating in-sheet headers.
sheet.EnableCreateBindColumnHeader = false;
// Data cells begin from row 0.
sheet.BindStartRow = 0;
// Unfreezes the header rows.
sheet.UnfreezePanes();
// Bind the sheet to the dataset.
sheet.DataBind();
}
finally
{
//Close database connection
db.oleDbConnection1.Close();
}
}
protected void btnUpdateHyperlinks_Click(object sender, EventArgs e)
{
// ExStart:AccessHyperlinks
// Accessing the reference of the worksheet that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Accessing a specific cell that contains hyperlink
WebCell cell = sheet.Cells["B1"];
// Accessing the hyperlink from the specific cell
Hyperlink link = sheet.Hyperlinks.GetHyperlink(cell);
if (link != null)
{
// Modifying the text and URL of hyperlink
link.Text = "Aspose.Blogs";
link.Url = "http://www.aspose.com/Community/Blogs";
}
// ExEnd:AccessHyperlinks
}
private void AddImageHyPerlinks()
{
// ExStart:AddImageHyperlinks
// Accessing the reference of the worksheet that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
// Adding hyperlink to the worksheet
Hyperlink link1 = sheet.Hyperlinks.AddHyperlink("B5");
link1.Target = "_blank";
// Setting URL of the image that will be displayed as hyperlink
link1.ImageUrl = "../Images/Aspose.Banner.gif";
// Setting URL of the hyperlink
link1.Url = "http://www.aspose.com";
// Setting tool tip of the hyperlink
link1.ToolTip = "Open Aspose Web Site in new window";
// Resize the row to display image nicely
sheet.Cells.SetRowHeight(4, 40);
// Adding hyperlink to the worksheet
Hyperlink link2 = sheet.Hyperlinks.AddHyperlink("B6");
link2.Target = "_blank";
// Setting URL of the image that will be displayed as hyperlink
link2.ImageUrl = "../Images/Aspose.Grid.gif";
// Setting URL of the hyperlink
link2.Url = "http://www.aspose.com/docs/display/cellsnet/Aspose.Cells.GridWeb";
// Setting tool tip of the hyperlink
link2.ToolTip = "Open Aspose.Grid Docs in new window";
// Setting text of the hyperlink. It will be displayed if image is not displayed due to some reason
link2.Text = "Open Aspose.Grid Docs Page in new window";
// ExEnd:AddImageHyperlinks
}
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;
}
// Initialize new bind row.
private void GridWeb1_InitializeNewBindRow(WebWorksheet sender, object bindObject)
{
// Handles the initialize new bind row event.
MyCustomRecord rec = (MyCustomRecord)bindObject;
rec.DateField1 = DateTime.Now;
}
