Aspose.Cells.GridWeb.Examples.CSharp.Worksheets.ImportDataView.Button1_Click C# (CSharp) Method

        protected void Button1_Click(object sender, EventArgs e)
        {
            // ExStart:ImportDataView
            // Connect database
            System.Data.OleDb.OleDbConnection oleDbConnection1 = new OleDbConnection();
            System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1 = new OleDbDataAdapter();
            System.Data.OleDb.OleDbCommand oleDbSelectCommand1 = new OleDbCommand();
            string path = (this.Master as Site).GetDataDir();
            oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "\\Worksheets\\Database\\Northwind.mdb";
            oleDbSelectCommand1.Connection = oleDbConnection1;
            oleDbDataAdapter1.SelectCommand = oleDbSelectCommand1;

            DataTable dataTable1 = new DataTable();
            dataTable1.Reset();

            // Queries database.
            try
            {
                oleDbSelectCommand1.CommandText = "SELECT CategoryID, CategoryName, Description FROM Categories";
                oleDbDataAdapter1.Fill(dataTable1);
            }
            catch
            {           
            }
            finally
            {
                oleDbConnection1.Close();
            }
                        
            // Imports data from dataview object.
            dataTable1.TableName = "Categories";
            GridWeb1.WorkSheets.Clear();
            GridWeb1.WorkSheets.ImportDataView(dataTable1.DefaultView, null, null);

            // Imports data from dataview object with sheet name and position specified.
            GridWeb1.WorkSheets.ImportDataView(dataTable1.DefaultView, null, null, "SpecifiedName&Position", 2, 1);
            // ExEnd:ImportDataView

            // Resize cells
            GridCells cells = GridWeb1.WorkSheets[0].Cells;
            // Sets column width.
            cells.SetColumnWidth(0, 10);
            cells.SetColumnWidth(1, 10);
            cells.SetColumnWidth(2, 30);
            cells.SetRowHeight(2, 30);
            GridCells cellsb = GridWeb1.WorkSheets[1].Cells;
            cellsb.SetColumnWidth(1, 10);
            cellsb.SetColumnWidth(2, 10);
            cellsb.SetColumnWidth(3, 30);
            cellsb.SetRowHeight(4, 30);

            // Add style to cells
            GridTableItemStyle style = new GridTableItemStyle();
            style.HorizontalAlign = HorizontalAlign.Center;
            style.BorderStyle = BorderStyle.Solid;
            style.BorderColor = Color.Black;
            style.BorderWidth = 1;

            for (int i = 1; i <= cells.MaxRow; i++)
            {
                for (int j = 0; j <= cells.MaxColumn; j++)
                {
                    GridCell cell = cells[i, j];
                    cell.CopyStyle(style);

                }
            }
            for (int i = 3; i <= cellsb.MaxRow; i++)
            {
                for (int j = 1; j <= cellsb.MaxColumn; j++)
                {
                    GridCell cell = cellsb[i, j];
                    cell.CopyStyle(style);

                }
            }
        }