protected void btnLoad_Click(object sender, EventArgs e)
{
// Loads data from access database.
DataSet ds = new DataSet();
//Create demo database object
DemoDatabase db = new DemoDatabase();
string path = Server.MapPath("~");
path = path.Substring(0, path.LastIndexOf("\\"));
//Create connection string to database
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(ds);
//Import data from database to grid web
GridWeb1.WorkSheets.ImportDataView(ds.Tables["Products"].DefaultView, null, null);
}
finally
{
//Close connection
db.oleDbConnection1.Close();
}
}
private void BindWithInSheetHeaders()
{
//Create dataset object
this.dataSet11 = new Aspose.Cells.GridWeb.DemosCS.DataBind.DataSet1();
//Create demo database object
DemoDatabase db = new DemoDatabase();
//Create pathe to database file
string path = Server.MapPath("~");
path = path.Substring(0, path.LastIndexOf("\\"));
//Create connection string
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 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 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();
}
}
private void BindWithoutInSheetHeaders()
{
//Create dataset 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
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);
db.oleDbDataAdapter2.Fill(dataSet11);
//Create web worksheet object
WebWorksheet sheet = GridWeb1.WebWorksheets[0];
// Create the "CategoryID" field dropdownlist value list.
sheet.BindColumns["CategoryID"].Validation.ValidationType = ValidationType.List;
sheet.BindColumns["CategoryID"].Validation.LoadValueList(dataSet11.Categories.DefaultView, "CategoryID", "CategoryName", true);
// Bind the sheet to the dataset.
sheet.DataSource = dataSet11;
sheet.DataBind();
}
finally
{
//Close database connection
db.oleDbConnection1.Close();
}
}
// Handles the custom command button's click event.
protected void GridWeb1_CustomCommand(object sender, string command)
{
switch (command)
{
case "UPDATE":
// Only available for local users.
if (Request.UserHostAddress == "127.0.0.1")
{
//Create path to database file
DemoDatabase db = new DemoDatabase();
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
{
//Update database
db.oleDbDataAdapter1.Update((DataSet)GridWeb1.WebWorksheets[0].DataSource);
}
finally
{
//Close connection
db.oleDbConnection1.Close();
}
}
else
{
//Det error message
ShowErrorMsg("Can't update from remote machine!");
}
break;
case "ADD":
if (GridWeb1.ActiveSheetIndex == 0)
{
//Create new active row
GridWeb1.WebWorksheets.ActiveSheet.CreateNewBindRow();
// Scrolls the panel to the bottom.
GridWeb1.ViewPanelScrollTop = "1200";
}
break;
case "DELETE":
if (GridWeb1.ActiveSheetIndex == 0)
{
if (GridWeb1.ActiveCell != null)
//Delete bind row
GridWeb1.WebWorksheets.ActiveSheet.DeleteBindRow(GridWeb1.ActiveCell.Row);
}
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack&&!GridWeb1.IsPostBack)
{
//Create dataset object
this.dataSet11 = new Aspose.Cells.GridWeb.DemosCS.DataBind.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
DemoDatabase db = new DemoDatabase();
//Create path to database file
string path = Server.MapPath("~");
path = path.Substring(0, path.LastIndexOf("\\"));
//Create connection string
db.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "\\Database\\demos.mdb";
try
{
// Loads data from database.
db.oleDbDataAdapter1.Fill(dataSet11);
}
finally
{
//Close connection
db.oleDbConnection1.Close();
}
// Binding.
sheet.DataBind();
}
}
