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
GridWorksheet sheet = GridWeb1.WorkSheets[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();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack && !GridWeb1.IsPostBack)
{
// Create dataset object
this.dataSet11 = new DataSet1();
// Create web worksheet object
GridWorksheet sheet = GridWeb1.WorkSheets[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;
// 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 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
GridWorksheet sheet = GridWeb1.WorkSheets[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"].Style.Font.Size = new FontUnit("20pt");
sheet.Cells["A1"].Style.HorizontalAlign = HorizontalAlign.Center;
sheet.Cells["A1"].Style.VerticalAlign = VerticalAlign.Middle;
sheet.Cells["A1"].Style.BackColor = Color.SkyBlue;
sheet.Cells["A1"].Style.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 = (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
GridWorksheet sheet = GridWeb1.WorkSheets[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
GridWorksheet sheet = GridWeb1.WorkSheets[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();
}
}