protected void Page_Load(object sender, EventArgs e) { grid1.ID = "Grid1"; grid1.DataSourceID = "SqlDataSource1"; grid1.AutoGenerateColumns = false; GridRuntimeTemplate CountryTemplate = new GridRuntimeTemplate(); CountryTemplate.ID = "Template1"; CountryTemplate.ControlID = "ComboBox1"; CountryTemplate.Template = new Obout.Grid.RuntimeTemplate(); CountryTemplate.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateCountryTemplate); //------------------------------------------------------------------------ grid1.Templates.Add(CountryTemplate); // creating the columns Column oCol1 = new Column(); oCol1.DataField = "OrderID"; oCol1.Visible = false; Column oCol2 = new Column(); oCol2.DataField = "ShipName"; oCol2.HeaderText = "NAME"; Column oCol3 = new Column(); oCol3.DataField = "ShipCity"; oCol3.HeaderText = "CITY"; Column oCol4 = new Column(); oCol4.DataField = "ShipCountry"; oCol4.HeaderText = "COUNTRY"; oCol4.TemplateSettings.EditTemplateId = "Template1"; Column oCol5 = new Column(); oCol5.DataField = "ShipPostalCode"; oCol5.HeaderText = "POSTAL CODE"; Column oCol6 = new Column(); oCol6.AllowEdit = true; oCol6.AllowDelete = true; // add the columns to the Columns collection of the grid grid1.Columns.Add(oCol1); grid1.Columns.Add(oCol2); grid1.Columns.Add(oCol3); grid1.Columns.Add(oCol4); grid1.Columns.Add(oCol5); grid1.Columns.Add(oCol6); // add the grid to the controls collection of the PlaceHolder phGrid1.Controls.Add(grid1); }
//Realiza la configuracion general de todo el diseƱo del Grid. protected void ConfigurarGrid() { grid1 = new Obout.Grid.Grid(); //Configuracion del Template para grupos. GridRuntimeTemplate TemplateEditAddress = new GridRuntimeTemplate(); TemplateEditAddress.ID = "TemplateEditAddress"; TemplateEditAddress.UseQuotes = true; TemplateEditAddress.Template = new Obout.Grid.RuntimeTemplate(); TemplateEditAddress.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateEditAddressTemplate); //Parametros de Grid generales. grid1.Templates.Add(TemplateEditAddress); grid1.TemplateSettings.GroupHeaderTemplateId = "TemplateEditAddress"; grid1.AllowAddingRecords = false; grid1.AllowColumnReordering = true; grid1.AllowColumnResizing = true; grid1.AllowGrouping = true; grid1.AutoGenerateColumns = true; grid1.CallbackMode = true; grid1.EnableRecordHover = true; grid1.FolderLocalization = "../grid/localization"; grid1.FolderStyle = "../grid/styles/style_4"; grid1.ID = "grid1"; grid1.Language = "es"; grid1.PageSize = 200; grid1.Serialize = true; grid1.ShowCollapsedGroups = true; grid1.ShowGroupsInfo = true; grid1.ShowMultiPageGroupsInfo = true; grid1.KeepSelectedRecords = true; }
protected void createRuntimeTemplate(string x) { GridRuntimeTemplate tpl1 = new GridRuntimeTemplate(); tpl1.ID = "MasterTemplate"; tpl1.ControlID = "ddl_master_pk"; tpl1.Template = new Obout.Grid.RuntimeTemplate(); tpl1.ControlPropertyName = "value"; tpl1.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateMasterPKTemplate); GridRuntimeTemplate tpl2 = new GridRuntimeTemplate(); tpl2.ID = "DetailTemplate"; tpl2.ControlID = "ddl_detail_pk"; tpl2.Template = new Obout.Grid.RuntimeTemplate(); tpl2.ControlPropertyName = "value"; tpl2.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateDetailPKTemplate); ogrid_detail.Templates.Add(tpl1); ogrid_detail.Templates.Add(tpl2); //return tpl; }
protected void Page_Load(object sender, EventArgs e) { grid1.ID = "Grid1"; grid1.DataSourceID = "SqlDataSource1"; grid1.AutoGenerateColumns = false; grid1.AllowAddingRecords = false; grid1.AllowFiltering = true; grid1.AllowPageSizeSelection = false; // creating the template for the Company name column (view mode) //------------------------------------------------------------------------ GridRuntimeTemplate Template1 = new GridRuntimeTemplate(); Template1.ID = "Template1"; Template1.ControlID = "ComboBox1"; Template1.Template = new Obout.Grid.RuntimeTemplate(); Template1.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateTemplate1); // adding the templates to the Templates collection grid1.Templates.Add(Template1); //------------------------------------------------------------------------ // creating the columns Column oCol1 = new Column(); oCol1.DataField = "OrderID"; oCol1.Visible = false; Column oCol2 = new Column(); oCol2.DataField = "ShipName"; oCol2.HeaderText = "NAME"; Column oCol3 = new Column(); oCol3.DataField = "ShipCity"; oCol3.HeaderText = "CITY"; Column oCol4 = new Column(); oCol4.DataField = "ShipCountry"; oCol4.HeaderText = "COUNTRY"; oCol4.ShowFilterCriterias = false; oCol4.TemplateSettings.FilterTemplateId = "Template1"; Column oCol5 = new Column(); oCol5.DataField = "ShipPostalCode"; oCol5.HeaderText = "POSTAL CODE"; // add the columns to the Columns collection of the grid grid1.Columns.Add(oCol1); grid1.Columns.Add(oCol2); grid1.Columns.Add(oCol3); grid1.Columns.Add(oCol4); grid1.Columns.Add(oCol5); phGrid1.Controls.Add(grid1); }
protected void Page_Load(object sender, EventArgs e) { grid1 = new Grid(); grid1.ID = "grid1"; grid1.DataSourceID = "SqlDataSource1"; grid1.AutoGenerateColumns = false; grid1.ClientSideEvents.OnBeforeClientDelete = "Grid1_BeforeDelete"; grid1.ClientSideEvents.ExposeSender = true; GridRuntimeTemplate TemplateEditCountry = new GridRuntimeTemplate(); TemplateEditCountry.ID = "Template1"; TemplateEditCountry.Template = new Obout.Grid.RuntimeTemplate(); TemplateEditCountry.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateEditCountryTemplate); TemplateEditCountry.ControlID = "ComboBox1"; TemplateEditCountry.ControlPropertyName = "value"; TemplateEditCountry.UseQuotes = true; grid1.Templates.Add(TemplateEditCountry); // creating the columns Column oCol1 = new Column(); oCol1.DataField = "OrderID"; oCol1.Visible = false; oCol1.HeaderText = "ORDER ID"; Column oCol2 = new Column(); oCol2.DataField = "ShipName"; oCol2.HeaderText = "NAME"; Column oCol3 = new Column(); oCol3.DataField = "ShipCity"; oCol3.HeaderText = "CITY"; Column oCol4 = new Column(); oCol4.DataField = "ShipPostalCode"; oCol4.HeaderText = "POSTAL CODE"; Column oCol5 = new Column(); oCol5.DataField = "ShipCountry"; oCol5.HeaderText = "COUNTRY"; oCol5.TemplateSettings.EditTemplateId = "Template1"; Column oCol6 = new Column(); oCol6.AllowEdit = true; oCol6.AllowDelete = true; // add the columns to the Columns collection of the grid grid1.Columns.Add(oCol1); grid1.Columns.Add(oCol2); grid1.Columns.Add(oCol3); grid1.Columns.Add(oCol4); grid1.Columns.Add(oCol5); grid1.Columns.Add(oCol6); Grid1Container.Controls.Add(grid1); }
protected void Page_Load(object sender, EventArgs e) { grid1.ID = "Grid1"; grid1.DataSourceID = "SqlDataSource1"; grid1.FolderStyle = "styles/black_glass"; grid1.AutoGenerateColumns = false; grid1.AllowAddingRecords = false; // creating the columns Column oCol1 = new Column(); oCol1.DataField = "OrderID"; oCol1.Visible = false; Column oCol2 = new Column(); oCol2.DataField = "ShipName"; oCol2.HeaderText = "SHIP NAME"; Column oCol3 = new Column(); oCol3.DataField = "ShipCity"; oCol3.HeaderText = "SHIP CITY"; Column oCol4 = new Column(); oCol4.DataField = "ShipPostalCode"; oCol4.HeaderText = "POSTAL CODE"; Column oCol5 = new Column(); oCol5.DataField = "ShipCountry"; oCol5.HeaderText = "SHIP COUNTRY"; GridRuntimeTemplate HeadingTemplate = new GridRuntimeTemplate(); HeadingTemplate.ID = "HeadingTemplate1"; HeadingTemplate.Template = new Obout.Grid.RuntimeTemplate(); HeadingTemplate.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateHeadingTemplate); //------------------------------------------------------------------------ grid1.Templates.Add(HeadingTemplate); // add the columns to the Columns collection of the grid grid1.Columns.Add(oCol1); grid1.Columns.Add(oCol2); grid1.Columns.Add(oCol3); grid1.Columns.Add(oCol4); grid1.Columns.Add(oCol5); grid1.TemplateSettings.HeadingTemplateId = "HeadingTemplate1"; // add the grid to the controls collection of the PlaceHolder phGrid1.Controls.Add(grid1); }
void Page_load(object sender, EventArgs e) { grid1 = new Grid(); grid1.ID = "Grid1"; grid1.DataSourceID = "SqlDataSource1"; grid1.Serialize = false; grid1.AutoGenerateColumns = false; grid1.TemplateSettings.RowEditTemplateId = "tplRowEdit"; // creating the Template for editing Rows //------------------------------------------------------------------------ GridRuntimeTemplate RowEditTemplate = new GridRuntimeTemplate(); RowEditTemplate.ID = "tplRowEdit"; RowEditTemplate.Template = new Obout.Grid.RuntimeTemplate(); RowEditTemplate.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateRowEditTemplate); grid1.Templates.Add(RowEditTemplate); // creating the columns Column oCol1 = new Column(); oCol1.DataField = "OrderID"; oCol1.ReadOnly = true; oCol1.HeaderText = "ORDER ID"; oCol1.Width = "150"; oCol1.Visible = false; oCol1.TemplateSettings.RowEditTemplateControlId = "OrderID"; oCol1.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol2 = new Column(); oCol2.DataField = "ShipName"; oCol2.HeaderText = "NAME"; oCol2.Width = "200"; oCol2.TemplateSettings.RowEditTemplateControlId = "SuperForm1_ShipName"; oCol2.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol3 = new Column(); oCol3.DataField = "ShipAddress"; oCol3.Visible = false; oCol3.HeaderText = "ADDRESS"; oCol3.Width = "125"; oCol3.TemplateSettings.RowEditTemplateControlId = "SuperForm1_ShipAddress"; oCol3.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol4 = new Column(); oCol4.DataField = "ShipCity"; oCol4.Visible = true; oCol4.HeaderText = "CITY"; oCol4.Width = "150"; oCol4.TemplateSettings.RowEditTemplateControlId = "SuperForm1_ShipCity"; oCol4.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol5 = new Column(); oCol5.DataField = "ShipRegion"; oCol5.Visible = false; oCol5.HeaderText = "REGION"; oCol5.Width = "150"; oCol5.TemplateSettings.RowEditTemplateControlId = "SuperForm1_ShipRegion"; oCol5.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol6 = new Column(); oCol6.DataField = "ShipPostalCode"; oCol6.Visible = true; oCol6.HeaderText = "POSTAL CODE"; oCol6.Width = "150"; oCol6.TemplateSettings.RowEditTemplateControlId = "SuperForm1_ShipPostalCode"; oCol6.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol7 = new Column(); oCol7.DataField = "ShipCountry"; oCol7.Visible = true; oCol7.HeaderText = "COUNTRY"; oCol7.Width = "125"; oCol7.TemplateSettings.RowEditTemplateControlId = "SuperForm1_ShipCountry"; oCol7.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol8 = new Column(); oCol8.DataField = "OrderDate"; oCol8.Visible = true; oCol8.HeaderText = "ORDER DATE"; oCol8.DataFormatString = "{0:MM/dd/yyyy}"; oCol8.ApplyFormatInEditMode = true; oCol8.Width = "125"; oCol8.TemplateSettings.RowEditTemplateControlId = "SuperForm1_OrderDate"; oCol8.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol9 = new Column(); oCol9.DataField = "RequiredDate"; oCol9.Visible = false; oCol9.HeaderText = "REQUIRED DATE"; oCol9.ApplyFormatInEditMode = true; oCol9.Width = "200"; oCol9.TemplateSettings.RowEditTemplateControlId = "SuperForm1_RequiredDate"; oCol9.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol10 = new Column(); oCol10.DataField = "ShippedDate"; oCol10.Visible = false; oCol10.ApplyFormatInEditMode = true; oCol10.HeaderText = "SHIPPED DATE"; oCol10.Width = "200"; oCol10.TemplateSettings.RowEditTemplateControlId = "SuperForm1_ShippedDate"; oCol10.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol11 = new Column(); oCol11.DataField = "ShipVia"; oCol11.Visible = false; oCol11.HeaderText = "SHIP VIA"; oCol11.Width = "200"; oCol11.TemplateSettings.RowEditTemplateControlId = "SuperForm1_ShipVia"; oCol11.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol12 = new Column(); oCol12.DataField = "Sent"; oCol12.Visible = false; oCol12.HeaderText = "SENT"; oCol12.Width = "175"; oCol12.TemplateSettings.RowEditTemplateControlId = "SuperForm1_Sent"; oCol12.TemplateSettings.RowEditTemplateControlPropertyName = "checked"; oCol12.TemplateSettings.RowEditTemplateUseQuotes = false; Column oCol13 = new Column(); oCol13.DataField = "AdditionalInformation"; oCol13.Visible = false; oCol13.HeaderText = "ADDITIONAL INFORMATION"; oCol13.Width = "200"; oCol13.TemplateSettings.RowEditTemplateControlId = "SuperForm1_AdditionalInformation"; oCol13.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol14 = new Column(); oCol14.DataField = ""; oCol14.Visible = true; oCol14.HeaderText = "EDIT"; oCol14.Width = "200"; oCol14.AllowEdit = true; oCol14.AllowDelete = true; // add the columns to the Columns collection of the grid grid1.Columns.Add(oCol1); grid1.Columns.Add(oCol2); grid1.Columns.Add(oCol3); grid1.Columns.Add(oCol4); grid1.Columns.Add(oCol5); grid1.Columns.Add(oCol6); grid1.Columns.Add(oCol7); grid1.Columns.Add(oCol8); grid1.Columns.Add(oCol9); grid1.Columns.Add(oCol10); grid1.Columns.Add(oCol11); grid1.Columns.Add(oCol12); grid1.Columns.Add(oCol13); grid1.Columns.Add(oCol14); // add the grid to the controls collection of the PlaceHolder SuperForm1Container.Controls.Add(grid1); }
protected void Page_Load(object sender, EventArgs e) { // Creating grid1 grid1.ID = "grid1"; grid1.AutoGenerateColumns = false; grid1.DataSourceID = "sds1"; grid1.FolderStyle = "styles/black_glass"; grid1.AllowAddingRecords = false; grid1.MasterDetailSettings.LoadingMode = DetailGridLoadingMode.OnCallback; // creating the template for the Company name column (view mode) //------------------------------------------------------------------------ GridRuntimeTemplate Template1 = new GridRuntimeTemplate(); Template1.ID = "Template1"; Template1.Template = new Obout.Grid.RuntimeTemplate(); Template1.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateTemplate1); //------------------------------------------------------------------------ GridRuntimeTemplate Template2 = new GridRuntimeTemplate(); Template2.ID = "Template2"; Template2.Template = new Obout.Grid.RuntimeTemplate(); Template2.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateTemplate2); //------------------------------------------------------------------------ GridRuntimeTemplate Template3 = new GridRuntimeTemplate(); Template3.ID = "Template3"; Template3.Template = new Obout.Grid.RuntimeTemplate(); Template3.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateTemplate3); //------------------------------------------------------------------------ grid1.Templates.Add(Template1); grid2.Templates.Add(Template2); grid3.Templates.Add(Template3); // creating the columns Column oCol1 = new Column(); oCol1.DataField = "CustomerID"; oCol1.HeaderText = "CUSTOMER ID"; oCol1.Visible = false; Column oCol2 = new Column(); oCol2.DataField = "CompanyName"; oCol2.HeaderText = "COMPANY NAME"; oCol2.Width = "250"; Column oCol3 = new Column(); oCol3.DataField = "ContactName"; oCol3.HeaderText = "CONTACT NAME"; Column oCol4 = new Column(); oCol4.DataField = "Country"; oCol4.HeaderText = "COUNTRY"; Column oCol5 = new Column(); oCol5.HeaderText = "INFO"; oCol5.Width = "115"; oCol5.TemplateSettings.TemplateId = "Template1"; // add the columns to the Columns collection of the grid grid1.Columns.Add(oCol1); grid1.Columns.Add(oCol2); grid1.Columns.Add(oCol3); grid1.Columns.Add(oCol4); grid1.Columns.Add(oCol5); // Creating grid2 grid2.ID = "grid2"; grid2.AutoGenerateColumns = false; grid2.FolderStyle = "styles/black_glass"; grid2.AllowAddingRecords = false; grid2.ShowFooter = true; grid2.AllowPageSizeSelection = false; grid2.DataSourceID = "sds2"; grid2.ForeignKeys = "CustomerID"; grid2.AllowPaging = false; grid2.MasterDetailSettings.LoadingMode = DetailGridLoadingMode.OnCallback; // creating the columns Column oCol2_1 = new Column(); oCol2_1.DataField = "CustomerID"; oCol2_1.HeaderText = "CUSTOMER ID"; oCol2_1.Visible = false; oCol2_1.ReadOnly = true; Column oCol2_2 = new Column(); oCol2_2.DataField = "OrderID"; oCol2_2.HeaderText = "ORDER ID"; oCol2_2.Visible = false; oCol2_1.ReadOnly = true; Column oCol2_3 = new Column(); oCol2_3.DataField = "OrderDate"; oCol2_3.HeaderText = "ORDER DATE"; oCol2_3.DataFormatString = "{0:MM/dd/yyyy}"; oCol2_3.Width = "220"; Column oCol2_4 = new Column(); oCol2_4.DataField = "ShippedDate"; oCol2_4.HeaderText = "SHIPPED DATE"; oCol2_4.DataFormatString = "{0:MM/dd/yyyy}"; Column oCol2_5 = new Column(); oCol2_5.DataField = "Freight"; oCol2_5.HeaderText = "FREIGHT"; oCol2_5.DataFormatString = "{0:C2}"; Column oCol2_6 = new Column(); oCol2_6.HeaderText = "INFO"; oCol2_6.Width = "115"; oCol2_6.TemplateSettings.TemplateId = "Template2"; // add the columns to the Columns collection of the grid grid2.Columns.Add(oCol2_1); grid2.Columns.Add(oCol2_2); grid2.Columns.Add(oCol2_3); grid2.Columns.Add(oCol2_4); grid2.Columns.Add(oCol2_5); grid2.Columns.Add(oCol2_6); grid1.DetailGrids.Add(grid2); // Creating grid3 grid3.ID = "grid3"; grid3.AutoGenerateColumns = false; grid3.FolderStyle = "styles/black_glass"; grid3.AllowAddingRecords = false; grid3.ShowFooter = true; grid3.AllowPageSizeSelection = false; grid3.DataSourceID = "sds3"; grid3.ForeignKeys = "OrderID"; grid3.AllowPaging = false; // creating the columns Column oCol3_1 = new Column(); oCol3_1.DataField = "OrderID"; oCol3_1.HeaderText = "ORDER ID"; oCol3_1.Visible = false; oCol3_1.ReadOnly = true; Column oCol3_2 = new Column(); oCol3_2.DataField = "ProductID"; oCol3_2.HeaderText = "PRODUCT ID"; oCol3_2.Visible = false; oCol3_2.ReadOnly = true; Column oCol3_3 = new Column(); oCol3_3.DataField = "UnitPrice"; oCol3_3.HeaderText = "UNIT PRICE"; oCol3_3.DataFormatString = "{0:C2}"; oCol3_3.Width = "180"; Column oCol3_4 = new Column(); oCol3_4.DataField = "Quantity"; oCol3_4.HeaderText = "QUANTITY"; oCol3_4.Width = "185"; Column oCol3_5 = new Column(); oCol3_5.DataField = "Discount"; oCol3_5.HeaderText = "DISCOUNT"; oCol3_5.DataFormatString = "{0:F2}%"; oCol3_5.Width = "175"; Column oCol3_6 = new Column(); oCol3_6.HeaderText = "INFO"; oCol3_6.Width = "115"; oCol3_6.TemplateSettings.TemplateId = "Template3"; // add the columns to the Columns collection of the grid grid3.Columns.Add(oCol3_1); grid3.Columns.Add(oCol3_2); grid3.Columns.Add(oCol3_3); grid3.Columns.Add(oCol3_4); grid3.Columns.Add(oCol3_5); grid3.Columns.Add(oCol3_6); grid2.DetailGrids.Add(grid3); // add the grid to the controls collection of the PlaceHolder phGrid1.Controls.Add(grid1); }
protected void Page_Load(object sender, EventArgs e) { // Creating grid1 grid1.ID = "Grid1"; grid1.AutoGenerateColumns = false; grid1.PageSize = 5; grid1.AllowAddingRecords = false; grid1.DataSourceID = "sds1"; grid1.AllowPageSizeSelection = false; grid1.MasterDetailSettings.LoadingMode = DetailGridLoadingMode.OnCallback; // creating the Template for editing Rows //------------------------------------------------------------------------ GridRuntimeTemplate ExpandTemplate = new GridRuntimeTemplate(); ExpandTemplate.ID = "TemplateExpand"; ExpandTemplate.Template = new Obout.Grid.RuntimeTemplate(); ExpandTemplate.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateExpandTemplate); //------------------------------------------------------------------------ grid1.Templates.Add(ExpandTemplate); // creating the columns Column oCol0 = new Column(); oCol0.HeaderText = ""; oCol0.Width = "110"; oCol0.TemplateSettings.TemplateId = "TemplateExpand"; Column oCol1 = new Column(); oCol1.DataField = "CustomerID"; oCol1.HeaderText = "CUSTOMER ID"; oCol1.Visible = false; Column oCol2 = new Column(); oCol2.DataField = "CompanyName"; oCol2.HeaderText = "COMPANY NAME"; oCol2.Width = "200"; Column oCol3 = new Column(); oCol3.DataField = "ContactName"; oCol3.HeaderText = "CONTACT NAME"; Column oCol4 = new Column(); oCol4.DataField = "Country"; oCol4.HeaderText = "COUNTRY"; oCol4.Width = "125"; // add the columns to the Columns collection of the grid grid1.Columns.Add(oCol0); grid1.Columns.Add(oCol1); grid1.Columns.Add(oCol2); grid1.Columns.Add(oCol3); grid1.Columns.Add(oCol4); // Creating grid2 grid2.ID = "Grid2"; grid2.AutoGenerateColumns = false; grid2.EnableTypeValidation = false; grid2.AllowAddingRecords = false; grid2.ShowFooter = true; grid2.PageSize = 5; grid2.DataSourceID = "sds2"; grid2.ForeignKeys = "CustomerID"; grid2.AllowPageSizeSelection = false; grid2.ClientSideEvents.ExposeSender = true; grid2.MasterDetailSettings.LoadingMode = DetailGridLoadingMode.OnCallback; // creating the columns Column oCol2_1 = new Column(); oCol2_1.DataField = "CustomerID"; oCol2_1.HeaderText = "CUSTOMER ID"; oCol2_1.Visible = false; oCol2_1.ReadOnly = false; Column oCol2_2 = new Column(); oCol2_2.DataField = "OrderID"; oCol2_2.HeaderText = "ORDER ID"; oCol2_2.Visible = false; oCol2_2.ReadOnly = false; Column oCol2_3 = new Column(); oCol2_3.DataField = "ShipName"; oCol2_3.HeaderText = "NAME"; oCol2_3.Width = "250"; Column oCol2_4 = new Column(); oCol2_4.DataField = "ShipCity"; oCol2_4.HeaderText = "CITY"; oCol2_4.Width = "170"; Column oCol2_5 = new Column(); oCol2_5.DataField = "ShipCountry"; oCol2_5.HeaderText = "COUNTRY"; oCol2_5.DataFormatString = "{0:C2}"; oCol2_5.Width = "150"; // add the columns to the Columns collection of the grid grid2.Columns.Add(oCol2_1); grid2.Columns.Add(oCol2_2); grid2.Columns.Add(oCol2_3); grid2.Columns.Add(oCol2_4); grid2.Columns.Add(oCol2_5); grid1.DetailGrids.Add(grid2); // add the grid to the controls collection of the PlaceHolder phGrid1.Controls.Add(grid1); }
protected void Page_Load(object sender, EventArgs e) { grid1.ID = "Grid1"; grid1.AutoGenerateColumns = false; grid1.AllowAddingRecords = false; grid1.DataSourceID = "SqlDataSource3"; grid1.FolderStyle = "styles/black_glass"; grid1.PageSize = 5; grid1.Exporting += Grid1_Exporting; grid1.Exported += Grid1_Exported; grid1.TemplateSettings.HeadingTemplateId = "Template1"; grid1.ExportingSettings.ExportHiddenColumns = false; GridRuntimeTemplate Template1 = new GridRuntimeTemplate(); Template1.ID = "Template1"; Template1.Template = new Obout.Grid.RuntimeTemplate(); Template1.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateTemplate1); //------------------------------------------------------------------------ GridRuntimeTemplate Template2 = new GridRuntimeTemplate(); Template2.ID = "Template2"; Template2.Template = new Obout.Grid.RuntimeTemplate(); Template2.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateTemplate2); //------------------------------------------------------------------------ GridRuntimeTemplate Template3 = new GridRuntimeTemplate(); Template3.ID = "Template3"; Template3.Template = new Obout.Grid.RuntimeTemplate(); Template3.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateTemplate3); //------------------------------------------------------------------------ // adding the templates to the Templates collection grid1.Templates.Add(Template1); grid2.Templates.Add(Template2); grid3.Templates.Add(Template3); // creating the columns Column g1Col1 = new Column(); g1Col1.DataField = "CustomerID"; g1Col1.Visible = false; g1Col1.Width = "150"; g1Col1.ReadOnly = true; Column g1Col2 = new Column(); g1Col2.DataField = "CompanyName"; g1Col2.HeaderText = "COMPANY NAME"; Column g1Col3 = new Column(); g1Col3.DataField = "Address"; g1Col3.HeaderText = "ADDRESS"; Column g1Col4 = new Column(); g1Col4.DataField = "City"; g1Col4.HeaderText = "CITY"; Column g1Col5 = new Column(); g1Col5.DataField = "Country"; g1Col5.HeaderText = "COUNTRY"; // add the columns to the Columns collection of the grid grid1.Columns.Add(g1Col1); grid1.Columns.Add(g1Col2); grid1.Columns.Add(g1Col3); grid1.Columns.Add(g1Col4); grid1.Columns.Add(g1Col5); grid2.ID = "Grid2"; grid2.AutoGenerateColumns = false; grid2.AllowAddingRecords = false; grid2.DataSourceID = "SqlDataSource2"; grid2.FolderStyle = "styles/black_glass"; grid2.PageSize = 5; grid2.TemplateSettings.HeadingTemplateId = "Template2"; grid2.ExportingSettings.ExportHiddenColumns = false; // creating the columns Column g2Col1 = new Column(); g2Col1.DataField = "OrderID"; g2Col1.Visible = false; g2Col1.Width = "150"; g2Col1.ReadOnly = true; Column g2Col2 = new Column(); g2Col2.DataField = "ShipName"; g2Col2.HeaderText = "SHIP NAME"; Column g2Col3 = new Column(); g2Col3.DataField = "ShipCity"; g2Col3.HeaderText = "SHIP CITY"; Column g2Col4 = new Column(); g2Col4.DataField = "ShipRegion"; g2Col4.HeaderText = "REGION"; Column g2Col5 = new Column(); g2Col5.DataField = "ShipCountry"; g2Col5.HeaderText = "SHIP COUNTRY"; // add the columns to the Columns collection of the grid grid2.Columns.Add(g2Col1); grid2.Columns.Add(g2Col2); grid2.Columns.Add(g2Col3); grid2.Columns.Add(g2Col4); grid2.Columns.Add(g2Col5); grid3.ID = "Grid3"; grid3.AutoGenerateColumns = false; grid3.AllowAddingRecords = false; grid3.DataSourceID = "SqlDataSource1"; grid3.FolderStyle = "styles/black_glass"; grid3.PageSize = 5; grid3.TemplateSettings.HeadingTemplateId = "Template3"; grid3.ExportingSettings.ExportHiddenColumns = false; // creating the columns Column g3Col1 = new Column(); g3Col1.DataField = "ProductID"; g3Col1.Visible = false; g3Col1.Width = "150"; g3Col1.ReadOnly = true; Column g3Col2 = new Column(); g3Col2.DataField = "CategoryID"; g3Col2.HeaderText = "CATEGORY ID"; g3Col2.Visible = false; g3Col2.Width = "150"; g3Col2.ReadOnly = true; Column g3Col3 = new Column(); g3Col3.DataField = "ProductName"; g3Col3.HeaderText = "PRODUCT NAME"; Column g3Col4 = new Column(); g3Col4.DataField = "UnitPrice"; g3Col4.HeaderText = "PRICE"; Column g3Col5 = new Column(); g3Col5.DataField = "UnitsInStock"; g3Col5.HeaderText = "SUNITS IN STOCK"; Column g3Col6 = new Column(); g3Col6.DataField = "UnitsOnOrder"; g3Col6.HeaderText = "UNITS ON ORDER"; // add the columns to the Columns collection of the grid grid3.Columns.Add(g3Col1); grid3.Columns.Add(g3Col2); grid3.Columns.Add(g3Col3); grid3.Columns.Add(g3Col4); grid3.Columns.Add(g3Col5); grid3.Columns.Add(g3Col6); // add the grid to the controls collection of the PlaceHolder phGrid1.Controls.Add(grid1); phGrid2.Controls.Add(grid2); phGrid3.Controls.Add(grid3); }
protected void Page_Load(object sender, EventArgs e) { // Creating grid1 grid1.ID = "Grid1"; grid1.AutoGenerateColumns = false; grid1.PageSize = 5; grid1.AllowAddingRecords = true; grid1.DataSourceID = "sds1"; grid1.AllowPageSizeSelection = false; grid1.MasterDetailSettings.LoadingMode = DetailGridLoadingMode.OnCallback; grid1.TemplateSettings.RowEditTemplateId = "tplRowEditMaster"; // creating the Template for editing Rows //------------------------------------------------------------------------ GridRuntimeTemplate RowEditTemplate = new GridRuntimeTemplate(); RowEditTemplate.ID = "tplRowEditMaster"; RowEditTemplate.Template = new Obout.Grid.RuntimeTemplate(); RowEditTemplate.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateRowEditTemplate); //------------------------------------------------------------------------ grid1.Templates.Add(RowEditTemplate); // creating the columns Column oCol1 = new Column(); oCol1.DataField = "CustomerID"; oCol1.HeaderText = "CUSTOMER ID"; oCol1.Visible = false; oCol1.TemplateSettings.RowEditTemplateControlId = "txtCustomerID"; oCol1.TemplateSettings.RowEditTemplateControlPropertyName = "innerHTML"; Column oCol2 = new Column(); oCol2.DataField = "CompanyName"; oCol2.HeaderText = "COMPANY NAME"; oCol2.Width = "200"; oCol2.TemplateSettings.RowEditTemplateControlId = "txtCompanyName"; oCol2.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol3 = new Column(); oCol3.DataField = "ContactName"; oCol3.HeaderText = "CONTACT NAME"; oCol3.TemplateSettings.RowEditTemplateControlId = "txtContactName"; oCol3.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol4 = new Column(); oCol4.DataField = "Country"; oCol4.HeaderText = "COUNTRY"; oCol4.TemplateSettings.RowEditTemplateControlId = "ddlCountries"; oCol4.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol5 = new Column(); oCol5.DataField = ""; oCol5.HeaderText = ""; oCol5.AllowEdit = true; oCol5.AllowDelete = true; oCol5.Width = "145"; // add the columns to the Columns collection of the grid grid1.Columns.Add(oCol1); grid1.Columns.Add(oCol2); grid1.Columns.Add(oCol3); grid1.Columns.Add(oCol4); grid1.Columns.Add(oCol5); // Creating grid2 grid2.ID = "Grid2"; grid2.AutoGenerateColumns = false; grid2.EnableTypeValidation = false; grid2.AllowAddingRecords = true; grid2.ShowFooter = true; grid2.PageSize = 5; grid2.RowCreated += grid2_RowCreated; grid2.DataSourceID = "sds2"; grid2.ForeignKeys = "CustomerID"; grid2.AllowPageSizeSelection = false; grid2.ClientSideEvents.ExposeSender = true; grid2.ClientSideEvents.OnClientPopulateControls = "onPopulateControls"; grid2.MasterDetailSettings.LoadingMode = DetailGridLoadingMode.OnCallback; grid2.TemplateSettings.RowEditTemplateId = "tplRowEditDetail"; // creating the Template for editing Rows //------------------------------------------------------------------------ GridRuntimeTemplate RowEditTemplateDetail = new GridRuntimeTemplate(); RowEditTemplateDetail.ID = "tplRowEditDetail"; RowEditTemplateDetail.Template = new Obout.Grid.RuntimeTemplate(); RowEditTemplateDetail.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateRowEditTemplateDetail); //------------------------------------------------------------------------ grid2.Templates.Add(RowEditTemplateDetail); // creating the columns Column oCol2_1 = new Column(); oCol2_1.DataField = "CustomerID"; oCol2_1.HeaderText = "CUSTOMER ID"; oCol2_1.Visible = false; oCol2_1.ReadOnly = false; oCol2_1.TemplateSettings.RowEditTemplateControlId = "hiddenCustomerID"; oCol2_1.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol2_2 = new Column(); oCol2_2.DataField = "OrderID"; oCol2_2.HeaderText = "ORDER ID"; oCol2_2.Visible = false; oCol2_2.ReadOnly = false; oCol2_2.TemplateSettings.RowEditTemplateControlId = "hiddenOrderID"; oCol2_2.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol2_3 = new Column(); oCol2_3.DataField = "ShipName"; oCol2_3.HeaderText = "NAME"; oCol2_3.TemplateSettings.RowEditTemplateControlId = "txtShipName"; oCol2_3.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol2_4 = new Column(); oCol2_4.DataField = "ShipCity"; oCol2_4.HeaderText = "CITY"; oCol2_4.TemplateSettings.RowEditTemplateControlId = "txtShipCity"; oCol2_4.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol2_5 = new Column(); oCol2_5.DataField = "ShipCountry"; oCol2_5.HeaderText = "COUNTRY"; oCol2_5.DataFormatString = "{0:C2}"; oCol2_5.Width = "125"; oCol2_5.TemplateSettings.RowEditTemplateControlId = "ddlShipCountries"; oCol2_5.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol2_6 = new Column(); oCol2_6.DataField = ""; oCol2_6.HeaderText = "EDIT"; oCol2_6.Width = "140"; oCol2_6.AllowEdit = true; oCol2_6.AllowDelete = true; // add the columns to the Columns collection of the grid grid2.Columns.Add(oCol2_1); grid2.Columns.Add(oCol2_2); grid2.Columns.Add(oCol2_3); grid2.Columns.Add(oCol2_4); grid2.Columns.Add(oCol2_5); grid2.Columns.Add(oCol2_6); grid1.DetailGrids.Add(grid2); // add the grid to the controls collection of the PlaceHolder phGrid1.Controls.Add(grid1); }
protected void Page_Load(object sender, EventArgs e) { grid1.ID = "Grid1"; grid1.DataSourceID = "SqlDataSource1"; grid1.AutoGenerateColumns = false; grid1.ShowLoadingMessage = false; grid1.AutoGenerateColumns = false; grid1.AllowAddingRecords = false; grid1.UpdateCommand += Grid1_UpdateCommand; grid1.AllowMultiRecordSelection = false; grid1.AllowSorting = false; //------------------------------------------------------------------------ GridRuntimeTemplate Template1 = new GridRuntimeTemplate(); Template1.ID = "Template1"; Template1.Template = new Obout.Grid.RuntimeTemplate(); Template1.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateTemplate1); //------------------------------------------------------------------------ grid1.Templates.Add(Template1); // creating the columns Column oCol1 = new Column(); oCol1.DataField = "OrderID"; oCol1.Visible = false; Column oCol2 = new Column(); oCol2.DataField = "RowPosition"; oCol2.Visible = false; Column oCol3 = new Column(); oCol3.DataField = "ShipName"; oCol3.HeaderText = "SHIP NAME"; Column oCol4 = new Column(); oCol4.DataField = "ShipCity"; oCol4.HeaderText = "SHIP CITY"; Column oCol5 = new Column(); oCol5.DataField = "ShipPostalCode"; oCol5.HeaderText = "POSTAL CODE"; Column oCol6 = new Column(); oCol6.DataField = "ShipCountry"; oCol6.HeaderText = "SHIP COUNTRY"; Column oCol7 = new Column(); oCol7.Width = "90"; oCol7.TemplateSettings.TemplateId = "Template1"; // add the columns to the Columns collection of the grid grid1.Columns.Add(oCol1); grid1.Columns.Add(oCol2); grid1.Columns.Add(oCol3); grid1.Columns.Add(oCol4); grid1.Columns.Add(oCol5); grid1.Columns.Add(oCol6); grid1.Columns.Add(oCol7); // add the grid to the controls collection of the PlaceHolder phGrid1.Controls.Add(grid1); }
protected void Page_Load(object sender, EventArgs e) { grid1.ID = "Grid1"; grid1.DataSourceID = "SqlDataSource1"; grid1.AutoGenerateColumns = false; GridRuntimeTemplate ViewEmployeeTemplate = new GridRuntimeTemplate(); ViewEmployeeTemplate.ID = "ViewEmployeeTemplate"; ViewEmployeeTemplate.Template = new Obout.Grid.RuntimeTemplate(); ViewEmployeeTemplate.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateViewEmployeeTemplate); //------------------------------------------------------------------------ GridRuntimeTemplate EditEmployeeTemplate = new GridRuntimeTemplate(); EditEmployeeTemplate.ID = "EditEmployeeTemplate"; EditEmployeeTemplate.ControlID = "EmployeesCombo"; EditEmployeeTemplate.Template = new Obout.Grid.RuntimeTemplate(); EditEmployeeTemplate.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateEditEmployeeTemplate); //------------------------------------------------------------------------ grid1.Templates.Add(ViewEmployeeTemplate); grid1.Templates.Add(EditEmployeeTemplate); // creating the columns Column oCol1 = new Column(); oCol1.DataField = "OrderID"; oCol1.Visible = false; Column oCol2 = new Column(); oCol2.DataField = "ShipName"; oCol2.HeaderText = "NAME"; Column oCol3 = new Column(); oCol3.DataField = "ShipCity"; oCol3.HeaderText = "CITY"; Column oCol4 = new Column(); oCol4.DataField = "ShipCountry"; oCol4.HeaderText = "COUNTRY"; Column oCol5 = new Column(); oCol5.DataField = "EmployeeName"; oCol5.Visible = false; Column oCol6 = new Column(); oCol6.DataField = "PositionID"; oCol6.Visible = false; Column oCol7 = new Column(); oCol7.DataField = "EmployeeID"; oCol7.HeaderText = "EMPLOYEE"; oCol7.TemplateSettings.TemplateId = "ViewEmployeeTemplate"; oCol7.TemplateSettings.EditTemplateId = "EditEmployeeTemplate"; Column oCol8 = new Column(); oCol8.AllowEdit = true; oCol8.AllowDelete = true; grid1.ClientSideEvents.OnBeforeClientEdit = "Grid1_Edit"; grid1.ClientSideEvents.ExposeSender = true; // add the columns to the Columns collection of the grid grid1.Columns.Add(oCol1); grid1.Columns.Add(oCol2); grid1.Columns.Add(oCol3); grid1.Columns.Add(oCol4); grid1.Columns.Add(oCol5); grid1.Columns.Add(oCol6); grid1.Columns.Add(oCol7); grid1.Columns.Add(oCol8); // add the grid to the controls collection of the PlaceHolder phGrid1.Controls.Add(grid1); }
protected void Page_Load(object sender, EventArgs e) { grid1.ID = "grid1"; grid1.CallbackMode = true; grid1.Serialize = false; grid1.AutoGenerateColumns = false; grid1.AllowRecordSelection = false; grid1.AllowAddingRecords = false; grid1.FolderStyle = "styles/premiere_blue"; // creating the Templates //------------------------------------------------------------------------ GridRuntimeTemplate PlainEditTemplate = new GridRuntimeTemplate(); PlainEditTemplate.ID = "PlainEditTemplate"; PlainEditTemplate.Template = new Obout.Grid.RuntimeTemplate(); PlainEditTemplate.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreatePlainEditTemplate); GridRuntimeTemplate CheckBoxEditTemplate = new GridRuntimeTemplate(); CheckBoxEditTemplate.ID = "CheckBoxEditTemplate"; CheckBoxEditTemplate.Template = new Obout.Grid.RuntimeTemplate(); CheckBoxEditTemplate.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateCheckBoxEditTemplate); //------------------------------------------------------------------------ // adding the templates to the Templates collection grid1.Templates.Add(PlainEditTemplate); grid1.Templates.Add(CheckBoxEditTemplate); // creating the columns Column oCol1 = new Column(); oCol1.DataField = "OrderID"; oCol1.ReadOnly = true; oCol1.HeaderText = "ORDER ID"; oCol1.Width = "100"; Column oCol2 = new Column(); oCol2.DataField = "OrderDate"; oCol2.HeaderText = "DATE"; oCol2.Width = "100"; oCol2.DataFormatString = "{0:MM/dd/yyyy}"; oCol2.TemplateSettings.TemplateId = "PlainEditTemplate"; Column oCol3 = new Column(); oCol3.DataField = "ShipName"; oCol3.HeaderText = "NAME"; oCol3.Width = "200"; oCol3.TemplateSettings.TemplateId = "PlainEditTemplate"; Column oCol4 = new Column(); oCol4.DataField = "ShipCity"; oCol4.HeaderText = "CITY"; oCol4.Width = "150"; oCol4.TemplateSettings.TemplateId = "PlainEditTemplate"; Column oCol5 = new Column(); oCol5.DataField = "ShipPostalCode"; oCol5.HeaderText = "POSTAL CODE"; oCol5.Width = "150"; oCol5.TemplateSettings.TemplateId = "PlainEditTemplate"; Column oCol6 = new Column(); oCol6.DataField = "ShipRegion"; oCol6.HeaderText = "REGION"; oCol6.Width = "150"; oCol6.TemplateSettings.TemplateId = "PlainEditTemplate"; Column oCol7 = new Column(); oCol7.DataField = "ShipCountry"; oCol7.HeaderText = "COUNTRY"; oCol7.Width = "150"; oCol7.TemplateSettings.TemplateId = "PlainEditTemplate"; Column oCol8 = new Column(); oCol8.DataField = "Sent"; oCol8.HeaderText = "SENT"; oCol8.Width = "100"; oCol8.TemplateSettings.TemplateId = "CheckBoxEditTemplate"; // add the columns to the Columns collection of the grid grid1.Columns.Add(oCol1); grid1.Columns.Add(oCol2); grid1.Columns.Add(oCol3); grid1.Columns.Add(oCol4); grid1.Columns.Add(oCol5); grid1.Columns.Add(oCol6); grid1.Columns.Add(oCol7); grid1.Columns.Add(oCol8); // add the grid to the controls collection of the PlaceHolder phGrid1.Controls.Add(grid1); PopulateGrid(); }
protected void Page_Load(object sender, EventArgs e) { grid1.ID = "Grid1"; grid1.DataSourceID = "SqlDataSource1"; grid1.AutoGenerateColumns = false; grid1.AllowFiltering = true; grid1.AllowAddingRecords = false; // creating the Templates //------------------------------------------------------------------------ GridRuntimeTemplate tplOrderDate = new GridRuntimeTemplate(); tplOrderDate.ID = "tplOrderDate"; tplOrderDate.Template = new Obout.Grid.RuntimeTemplate(); tplOrderDate.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateOrderDateTemplate); tplOrderDate.ControlID = "txtOrderDate"; //------------------------------------------------------------------------ GridRuntimeTemplate tplShippedDate = new GridRuntimeTemplate(); tplShippedDate.ID = "tplShippedDate"; tplShippedDate.Template = new Obout.Grid.RuntimeTemplate(); tplShippedDate.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateShippedDateTemplate); tplShippedDate.ControlID = "txtShippedDate"; //------------------------------------------------------------------------ GridRuntimeTemplate tplRequiredDate = new GridRuntimeTemplate(); tplRequiredDate.ID = "tplRequiredDate"; tplRequiredDate.Template = new Obout.Grid.RuntimeTemplate(); tplRequiredDate.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateRequiredDateTemplate); tplRequiredDate.ControlID = "txtRequiredDate"; //------------------------------------------------------------------------ // adding the templates to the Templates collection grid1.Templates.Add(tplOrderDate); grid1.Templates.Add(tplShippedDate); grid1.Templates.Add(tplRequiredDate); // creating the columns Column oCol1 = new Column(); oCol1.DataField = "OrderID"; oCol1.Visible = false; Column oCol2 = new Column(); oCol2.DataField = "ShipName"; oCol2.HeaderText = "SHIP NAME"; oCol2.ShowFilterCriterias = false; oCol2.Width = "200"; Column oCol3 = new Column(); oCol3.DataField = "OrderDate"; oCol3.HeaderText = "ORDER DATE"; oCol3.DataFormatString = "{0:M/d/yyyy}"; oCol3.ShowFilterCriterias = false; oCol3.Width = "200"; oCol3.TemplateSettings.FilterTemplateId = "tplOrderDate"; Column oCol4 = new Column(); oCol4.DataField = "ShippedDate"; oCol4.HeaderText = "SHIPPED DATE"; oCol4.DataFormatString = "{0:M/d/yyyy}"; oCol4.ShowFilterCriterias = false; oCol4.Width = "200"; oCol4.TemplateSettings.FilterTemplateId = "tplShippedDate"; Column oCol5 = new Column(); oCol5.DataField = "RequiredDate"; oCol5.HeaderText = "REQUIRED DATE"; oCol5.DataFormatString = "{0:M/d/yyyy}"; oCol5.ShowFilterCriterias = false; oCol5.Width = "200"; oCol5.TemplateSettings.FilterTemplateId = "tplRequiredDate"; // add the columns to the Columns collection of the grid grid1.Columns.Add(oCol1); grid1.Columns.Add(oCol2); grid1.Columns.Add(oCol3); grid1.Columns.Add(oCol4); grid1.Columns.Add(oCol5); // add the grid to the controls collection of the PlaceHolder phGrid1.Controls.Add(grid1); }
protected void Page_Load(object sender, EventArgs e) { grid1 = new Grid(); grid1.ID = "Grid1"; grid1.Serialize = false; grid1.AutoGenerateColumns = false; grid1.DataSourceID = "SqlDataSource1"; grid1.ClientSideEvents.OnBeforeClientUpdate = "Grid1_BeforeUpdate"; grid1.ClientSideEvents.OnBeforeClientInsert = "Grid1_BeforeInsert"; grid1.ClientSideEvents.OnClientEdit = "validate"; // creating the Templates //------------------------------------------------------------------------ GridRuntimeTemplate tplRowEdit = new GridRuntimeTemplate(); tplRowEdit.ID = "tplRowEdit"; tplRowEdit.Template = new Obout.Grid.RuntimeTemplate(); tplRowEdit.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreatetplRowEdit); //------------------------------------------------------------------------ // adding the templates to the Templates collection grid1.Templates.Add(tplRowEdit); // creating the columns Column oCol1 = new Column(); oCol1.DataField = "OrderID"; oCol1.ReadOnly = true; oCol1.Visible = false; oCol1.HeaderText = "ID"; oCol1.Width = "150"; oCol1.TemplateSettings.RowEditTemplateControlId = "OrderID"; oCol1.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol2 = new Column(); oCol2.DataField = "ShipName"; oCol2.HeaderText = "NAME"; oCol2.Width = "200"; oCol2.TemplateSettings.RowEditTemplateControlId = "SuperForm1_ShipName"; oCol2.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol3 = new Column(); oCol3.DataField = "ShipAddress"; oCol3.HeaderText = "ADDRESS"; oCol3.Visible = false; oCol3.Width = "125"; oCol3.TemplateSettings.RowEditTemplateControlId = "SuperForm1_ShipAddress"; oCol3.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol4 = new Column(); oCol4.DataField = "ShipCity"; oCol4.HeaderText = "CITY"; oCol4.Width = "150"; oCol4.TemplateSettings.RowEditTemplateControlId = "SuperForm1_ShipCity"; oCol4.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol5 = new Column(); oCol5.DataField = "ShipRegion"; oCol5.HeaderText = "REGION"; oCol5.Visible = false; oCol5.Width = "150"; oCol5.TemplateSettings.RowEditTemplateControlId = "SuperForm1_ShipRegion"; oCol5.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol6 = new Column(); oCol6.DataField = "ShipPostalCode"; oCol6.HeaderText = "POSTAL CODE"; oCol6.Width = "150"; oCol6.TemplateSettings.RowEditTemplateControlId = "SuperForm1_ShipPostalCode"; oCol6.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol7 = new Column(); oCol7.DataField = "ShipCountry"; oCol7.HeaderText = "COUNTRY"; oCol7.Width = "125"; oCol7.Wrap = false; oCol7.TemplateSettings.RowEditTemplateControlId = "SuperForm1_ShipCountry"; oCol7.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol8 = new Column(); oCol8.DataField = "OrderDate"; oCol8.HeaderText = "ORDER DATE"; oCol8.Width = "125"; oCol8.DataFormatString = "{0:MM/dd/yyyy}"; oCol8.ApplyFormatInEditMode = true; oCol8.TemplateSettings.RowEditTemplateControlId = "SuperForm1_OrderDate"; oCol8.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol9 = new Column(); oCol9.DataField = "RequiredDate"; oCol9.HeaderText = "REQUIRED DATE"; oCol9.Width = "200"; oCol9.Visible = false; oCol9.DataFormatString = "{0:MM/dd/yyyy}"; oCol9.ApplyFormatInEditMode = true; oCol9.TemplateSettings.RowEditTemplateControlId = "SuperForm1_RequiredDate"; oCol9.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol10 = new Column(); oCol10.DataField = "ShippedDate"; oCol10.HeaderText = "SHIPPED DATE"; oCol10.Width = "200"; oCol10.Visible = false; oCol10.DataFormatString = "{0:MM/dd/yyyy}"; oCol10.ApplyFormatInEditMode = true; oCol10.TemplateSettings.RowEditTemplateControlId = "SuperForm1_ShippedDate"; oCol10.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol11 = new Column(); oCol11.DataField = "ShipVia"; oCol11.HeaderText = "SHIP VIA"; oCol11.Width = "200"; oCol11.Visible = false; oCol11.TemplateSettings.RowEditTemplateControlId = "SuperForm1_ShipVia"; oCol11.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol12 = new Column(); oCol12.DataField = "Sent"; oCol12.HeaderText = "SENT"; oCol12.Width = "175"; oCol12.Visible = false; oCol12.TemplateSettings.RowEditTemplateControlId = "SuperForm1_Sent"; oCol12.TemplateSettings.RowEditTemplateControlPropertyName = "checked"; Column oCol13 = new Column(); oCol13.DataField = "AdditionalInformation"; oCol13.HeaderText = "ADDITIONAL INFORMATION"; oCol13.Width = "200"; oCol13.Visible = false; oCol13.TemplateSettings.RowEditTemplateControlId = "SuperForm1_AdditionalInformation"; oCol13.TemplateSettings.RowEditTemplateControlPropertyName = "value"; Column oCol14 = new Column(); oCol14.HeaderText = "EDIT"; oCol14.Width = "150"; oCol14.AllowEdit = true; oCol14.AllowDelete = true; grid1.TemplateSettings.RowEditTemplateId = "tplRowEdit"; // add the columns to the Columns collection of the grid grid1.Columns.Add(oCol1); grid1.Columns.Add(oCol2); grid1.Columns.Add(oCol3); grid1.Columns.Add(oCol4); grid1.Columns.Add(oCol5); grid1.Columns.Add(oCol6); grid1.Columns.Add(oCol7); grid1.Columns.Add(oCol8); grid1.Columns.Add(oCol9); grid1.Columns.Add(oCol10); grid1.Columns.Add(oCol11); grid1.Columns.Add(oCol12); grid1.Columns.Add(oCol13); grid1.Columns.Add(oCol14); // add the grid to the controls collection of the PlaceHolder Grid1Container.Controls.Add(grid1); }
protected void Page_Load(object sender, EventArgs e) { // Creating grid1 grid1.ID = "grid1"; grid1.AutoGenerateColumns = false; grid1.DataSourceID = "sds1"; grid1.FolderStyle = "styles/black_glass"; grid1.AllowAddingRecords = false; grid1.MasterDetailSettings.LoadingMode = DetailGridLoadingMode.OnCallback; // creating the template for the Company name column (view mode) //------------------------------------------------------------------------ GridRuntimeTemplate Template1 = new GridRuntimeTemplate(); Template1.ID = "Template1"; Template1.Template = new Obout.Grid.RuntimeTemplate(); Template1.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateTemplate1); //------------------------------------------------------------------------ GridRuntimeTemplate Template2 = new GridRuntimeTemplate(); Template2.ID = "Template2"; Template2.Template = new Obout.Grid.RuntimeTemplate(); Template2.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateTemplate2); //------------------------------------------------------------------------ GridRuntimeTemplate Template3 = new GridRuntimeTemplate(); Template3.ID = "Template3"; Template3.Template = new Obout.Grid.RuntimeTemplate(); Template3.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateTemplate3); //------------------------------------------------------------------------ grid1.Templates.Add(Template1); grid2.Templates.Add(Template2); grid3.Templates.Add(Template3); // creating the columns Column oCol1 = new Column(); oCol1.DataField = "CustomerID"; oCol1.HeaderText = "CUSTOMER ID"; oCol1.Visible = false; Column oCol2 = new Column(); oCol2.DataField = "CompanyName"; oCol2.HeaderText = "COMPANY NAME"; oCol2.Width = "250"; Column oCol3 = new Column(); oCol3.DataField = "ContactName"; oCol3.HeaderText = "CONTACT NAME"; Column oCol4 = new Column(); oCol4.DataField = "Country"; oCol4.HeaderText = "COUNTRY"; Column oCol5 = new Column(); oCol5.HeaderText = "INFO"; oCol5.Width = "115"; oCol5.TemplateSettings.TemplateId = "Template1"; // add the columns to the Columns collection of the grid grid1.Columns.Add(oCol1); grid1.Columns.Add(oCol2); grid1.Columns.Add(oCol3); grid1.Columns.Add(oCol4); grid1.Columns.Add(oCol5); // Creating grid2 grid2.ID = "grid2"; grid2.AutoGenerateColumns = false; grid2.FolderStyle = "styles/black_glass"; grid2.AllowAddingRecords = false; grid2.ShowFooter = true; grid2.AllowPageSizeSelection = false; grid2.DataSourceID = "sds2"; grid2.ForeignKeys = "CustomerID"; grid2.AllowPaging = false; grid2.MasterDetailSettings.LoadingMode = DetailGridLoadingMode.OnCallback; // creating the columns Column oCol2_1 = new Column(); oCol2_1.DataField = "CustomerID"; oCol2_1.HeaderText = "CUSTOMER ID"; oCol2_1.Visible = false; oCol2_1.ReadOnly = true; Column oCol2_2 = new Column(); oCol2_2.DataField = "OrderID"; oCol2_2.HeaderText = "ORDER ID"; oCol2_2.Visible = false; oCol2_1.ReadOnly = true; Column oCol2_3 = new Column(); oCol2_3.DataField = "OrderDate"; oCol2_3.HeaderText = "ORDER DATE"; oCol2_3.DataFormatString = "{0:MM/dd/yyyy}"; oCol2_3.Width="220"; Column oCol2_4 = new Column(); oCol2_4.DataField = "ShippedDate"; oCol2_4.HeaderText = "SHIPPED DATE"; oCol2_4.DataFormatString = "{0:MM/dd/yyyy}"; Column oCol2_5 = new Column(); oCol2_5.DataField = "Freight"; oCol2_5.HeaderText = "FREIGHT"; oCol2_5.DataFormatString = "{0:C2}"; Column oCol2_6 = new Column(); oCol2_6.HeaderText = "INFO"; oCol2_6.Width="115"; oCol2_6.TemplateSettings.TemplateId = "Template2"; // add the columns to the Columns collection of the grid grid2.Columns.Add(oCol2_1); grid2.Columns.Add(oCol2_2); grid2.Columns.Add(oCol2_3); grid2.Columns.Add(oCol2_4); grid2.Columns.Add(oCol2_5); grid2.Columns.Add(oCol2_6); grid1.DetailGrids.Add(grid2); // Creating grid3 grid3.ID = "grid3"; grid3.AutoGenerateColumns = false; grid3.FolderStyle = "styles/black_glass"; grid3.AllowAddingRecords = false; grid3.ShowFooter = true; grid3.AllowPageSizeSelection = false; grid3.DataSourceID = "sds3"; grid3.ForeignKeys = "OrderID"; grid3.AllowPaging = false; // creating the columns Column oCol3_1 = new Column(); oCol3_1.DataField = "OrderID"; oCol3_1.HeaderText = "ORDER ID"; oCol3_1.Visible = false; oCol3_1.ReadOnly = true; Column oCol3_2 = new Column(); oCol3_2.DataField = "ProductID"; oCol3_2.HeaderText = "PRODUCT ID"; oCol3_2.Visible = false; oCol3_2.ReadOnly = true; Column oCol3_3 = new Column(); oCol3_3.DataField = "UnitPrice"; oCol3_3.HeaderText = "UNIT PRICE"; oCol3_3.DataFormatString = "{0:C2}"; oCol3_3.Width = "180"; Column oCol3_4 = new Column(); oCol3_4.DataField = "Quantity"; oCol3_4.HeaderText = "QUANTITY"; oCol3_4.Width = "185"; Column oCol3_5 = new Column(); oCol3_5.DataField = "Discount"; oCol3_5.HeaderText = "DISCOUNT"; oCol3_5.DataFormatString = "{0:F2}%"; oCol3_5.Width = "175"; Column oCol3_6 = new Column(); oCol3_6.HeaderText = "INFO"; oCol3_6.Width = "115"; oCol3_6.TemplateSettings.TemplateId = "Template3"; // add the columns to the Columns collection of the grid grid3.Columns.Add(oCol3_1); grid3.Columns.Add(oCol3_2); grid3.Columns.Add(oCol3_3); grid3.Columns.Add(oCol3_4); grid3.Columns.Add(oCol3_5); grid3.Columns.Add(oCol3_6); grid2.DetailGrids.Add(grid3); // add the grid to the controls collection of the PlaceHolder phGrid1.Controls.Add(grid1); }
protected void Page_Load(object sender, EventArgs e) { grid1.ID = "Grid1"; grid1.DataSourceID = "sds1"; grid1.AutoGenerateColumns = false; grid1.CallbackMode = true; grid1.AllowAddingRecords = false; grid1.Serialize = true; grid1.AllowFiltering = true; grid1.ShowLoadingMessage = false; grid1.AllowPageSizeSelection = false; grid1.FilteringSettings.InitialState = GridFilterState.Visible; grid1.FilteringSettings.FilterPosition = GridFilterPosition.Top; // creating the Templates //------------------------------------------------------------------------ GridRuntimeTemplate NameFilter = new GridRuntimeTemplate(); NameFilter.ID = "NameFilter"; NameFilter.Template = new Obout.Grid.RuntimeTemplate(); NameFilter.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateNameFilter); NameFilter.ControlID = "Name"; //------------------------------------------------------------------------ //------------------------------------------------------------------------ GridRuntimeTemplate CityFilter = new GridRuntimeTemplate(); CityFilter.ID = "CityFilter"; CityFilter.Template = new Obout.Grid.RuntimeTemplate(); CityFilter.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateCityFilter); CityFilter.ControlID = "City"; //------------------------------------------------------------------------ //------------------------------------------------------------------------ GridRuntimeTemplate ZipFilter = new GridRuntimeTemplate(); ZipFilter.ID = "ZipFilter"; ZipFilter.Template = new Obout.Grid.RuntimeTemplate(); ZipFilter.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateZipFilter); ZipFilter.ControlID = "Zip"; //------------------------------------------------------------------------ //------------------------------------------------------------------------ GridRuntimeTemplate CountryFilter = new GridRuntimeTemplate(); CountryFilter.ID = "CountryFilter"; CountryFilter.Template = new Obout.Grid.RuntimeTemplate(); CountryFilter.Template.CreateTemplate += new Obout.Grid.GridRuntimeTemplateEventHandler(CreateCountryFilter); CountryFilter.ControlID = "Country"; //------------------------------------------------------------------------ // adding the templates to the Templates collection grid1.Templates.Add(NameFilter); grid1.Templates.Add(CityFilter); grid1.Templates.Add(ZipFilter); grid1.Templates.Add(CountryFilter); // creating the columns Column oCol1 = new Column(); oCol1.DataField = "OrderID"; oCol1.Visible = false; oCol1.HeaderText = "ORDER ID"; oCol1.Width = "100"; Column oCol2 = new Column(); oCol2.DataField = "ShipName"; oCol2.HeaderText = "NAME"; oCol2.Width = "200"; oCol2.TemplateSettings.FilterTemplateId = "NameFilter"; oCol2.ShowFilterCriterias = false; FilterOption NameFilterOption = new FilterOption(); NameFilterOption.Type = FilterOptionType.StartsWith; NameFilterOption.IsDefault = true; oCol2.FilterOptions.Add(NameFilterOption); Column oCol3 = new Column(); oCol3.DataField = "ShipCity"; oCol3.HeaderText = "CITY"; oCol3.Width = "150"; oCol3.TemplateSettings.FilterTemplateId = "CityFilter"; oCol3.ShowFilterCriterias = false; FilterOption CityFilterOption = new FilterOption(); CityFilterOption.Type = FilterOptionType.StartsWith; CityFilterOption.IsDefault = true; oCol3.FilterOptions.Add(CityFilterOption); Column oCol4 = new Column(); oCol4.DataField = "ShipPostalCode"; oCol4.HeaderText = "POSTAL CODE"; oCol4.Width = "150"; oCol4.TemplateSettings.FilterTemplateId = "ZipFilter"; oCol4.ShowFilterCriterias = false; FilterOption ZipFilterOption = new FilterOption(); ZipFilterOption.Type = FilterOptionType.StartsWith; ZipFilterOption.IsDefault = true; oCol4.FilterOptions.Add(ZipFilterOption); Column oCol5 = new Column(); oCol5.DataField = "ShipCountry"; oCol5.HeaderText = "COUNTRY"; oCol5.Width = "150"; oCol5.TemplateSettings.FilterTemplateId = "CountryFilter"; oCol5.ShowFilterCriterias = false; FilterOption CountryFilterOption = new FilterOption(); CountryFilterOption.Type = FilterOptionType.StartsWith; CountryFilterOption.IsDefault = true; oCol5.FilterOptions.Add(CountryFilterOption); // add the columns to the Columns collection of the grid grid1.Columns.Add(oCol1); grid1.Columns.Add(oCol2); grid1.Columns.Add(oCol3); grid1.Columns.Add(oCol4); grid1.Columns.Add(oCol5); // add the grid to the controls collection of the PlaceHolder phGrid1.Controls.Add(grid1); }