hi ,
I have problem when creating webdate chooser inside webgrid.i am not getting the webdatechooser while editing webgrid.Here I provide my design and code behind code.Plz help me..
Thanks in Advance,
Reagan.J
<div><igtbl:UltraWebGrid style="LEFT: 67px; TOP: 0px" id="grid" tabIndex=1 InitializeLayout="grid_InitializeLayout" InitializeDataSource="grid_InitializeDataSource" runat="server" Browser="Xml" Width="100%" Height="160px" __designer:wfdid="w3"> <Bands> <igtbl:UltraGridBand AllowSorting="No"> <AddNewRow View="NotSet" Visible="NotSet"> </AddNewRow> </igtbl:UltraGridBand> </Bands> <DisplayLayout ScrollBarView="Vertical" AllowColSizingDefault="Free" AllowColumnMovingDefault="OnServer" AllowDeleteDefault="Yes" BorderCollapseDefault="Separate" HeaderClickActionDefault="SortMulti" Name="grid" RowHeightDefault="20px" RowSelectorsDefault="No" SelectTypeRowDefault="Extended" StationaryMargins="Header" StationaryMarginsOutlookGroupBy="True" TableLayout="Fixed" Version="4.00" LoadOnDemand="Xml"> <GroupByBox> <BoxStyle BackColor="ActiveBorder" BorderColor="Window"> </BoxStyle> </GroupByBox> <GroupByRowStyleDefault BackColor="Control" BorderColor="Window"> </GroupByRowStyleDefault> <ActivationObject BorderColor="" BorderWidth=""> </ActivationObject> <FooterStyleDefault BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px"> <BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" WidthTop="1px" /> </FooterStyleDefault> <RowStyleDefault BackColor="Window" BorderColor="Silver" BorderStyle="Solid" BorderWidth="1px" Font-Names="Microsoft Sans Serif" Font-Size="8.25pt"> <BorderDetails ColorLeft="Window" ColorTop="Window" /> <Padding Left="3px" /> </RowStyleDefault> <FilterOptionsDefault> <FilterOperandDropDownStyle BackColor="White" BorderColor="Silver" BorderStyle="Solid" BorderWidth="1px" CustomRules="overflow:auto;" Font-Names="Verdana,Arial,Helvetica,sans-serif" Font-Size="11px"> <Padding Left="2px" /> </FilterOperandDropDownStyle> <FilterHighlightRowStyle BackColor="#151C55" ForeColor="White"> </FilterHighlightRowStyle> <FilterDropDownStyle BackColor="White" BorderColor="Silver" BorderStyle="Solid" BorderWidth="1px" CustomRules="overflow:auto;" Font-Names="Verdana,Arial,Helvetica,sans-serif" Font-Size="11px" Height="160px" Width="200px"> <Padding Left="2px" /> </FilterDropDownStyle> </FilterOptionsDefault> <HeaderStyleDefault BackColor="#8CAED0" BorderStyle="Solid" HorizontalAlign="Left" Font-Names="Arial" Font-Size="Small"> <BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" WidthTop="1px" /> </HeaderStyleDefault> <EditCellStyleDefault BorderStyle="None" BorderWidth="0px"> </EditCellStyleDefault> <FrameStyle Font-Names="Microsoft Sans Serif" Font-Size="8.25pt" Height="150px" Width="100%" BackColor="White"> </FrameStyle> <AddNewBox Hidden="False"> <BoxStyle BackColor="Window" BorderColor="InactiveCaption" BorderStyle="Solid" BorderWidth="1px"> </BoxStyle> </AddNewBox> <FixedHeaderStyleDefault BackColor="#8CAED0"> </FixedHeaderStyleDefault> </DisplayLayout> </igtbl:UltraWebGrid> </div><igsch:WebDateChooser id="fromDate" runat="server" Width="200px" Height="150px" Font-Size="8pt" Font-Names="Verdana"> </igsch:WebDateChooser>
code behind code:::
private void grid_InitializeDataSource(object sender,Infragistics.WebUI.UltraWebGrid.UltraGridEventArgs e) { try { LoadGrid(); } catch (Exception ex) { throw ex; } } private void grid_InitializeLayout(object sender,Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e) { try { this.grid.DisplayLayout.AllowColumnMovingDefault = AllowColumnMoving.None; this.grid.DisplayLayout.AllowColSizingDefault = AllowSizing.Fixed; this.grid.DisplayLayout.AllowSortingDefault = AllowSorting.No; this.grid.DisplayLayout.CellClickActionDefault = CellClickAction.RowSelect; this.grid.DisplayLayout.AllowColumnMovingDefault = AllowColumnMoving.None; this.grid.DisplayLayout.SelectTypeRowDefault = SelectType.Single; this.grid.Bands[0].AllowColSizing = Infragistics.WebUI.UltraWebGrid.AllowSizing.Fixed; this.grid.Width = Unit.Percentage(100);
grid.Bands[0].Columns.Clear(); UltraGridColumn GridColumn;
GridColumn = new UltraGridColumn(); GridColumn.BaseColumnName = "Id"; GridColumn.Key = "UserRoleId"; grid.Bands[0].Columns.Add(GridColumn); GridColumn.Header.RowLayoutColumnInfo.OriginY = 0; GridColumn.Width = 1; GridColumn.Hidden = true;
GridColumn = new UltraGridColumn(); GridColumn.BaseColumnName = "A"; GridColumn.Key = "Id"; GridColumn.Header.Caption = "A"; GridColumn.Header.RowLayoutColumnInfo.OriginY = 0; GridColumn.Width = Unit.Percentage(25); GridColumn.Type = ColumnType.DropDownList; grid.Bands[0].Columns.Add(GridColumn); //Load the column ValueList AList = new ValueList(); DataTable ds = new DataTable(); ds = Value From DB; int rowCount = ds.Rows.Count; for (int j = 0; j < rowCount; j++) { AList.ValueListItems.Add(ds.Rows[j]["Id"].ToString(),ds.Rows[j]["A"].ToString()); } grid.Columns[1].ValueList = AList;
GridColumn = new UltraGridColumn(); GridColumn.BaseColumnName = "B"; GridColumn.Key = "Id"; GridColumn.Header.Caption = "B"; GridColumn.Header.RowLayoutColumnInfo.OriginY = 0; GridColumn.Width = Unit.Percentage(25); GridColumn.Type = ColumnType.DropDownList; grid.Bands[0].Columns.Add(GridColumn); //Load the column ValueList BList = new ValueList(); DataTable ds1 = new DataTable(); ds1 =Value From DB; int rowCount = ds1.Rows.Count; for (int j = 0; j < rowCount ; j++) { RoleNameList.ValueListItems.Add(ds1.Rows[j]["Id"].ToString(), ds1.Rows[j]["B"].ToString()); } grid.Columns[2].ValueList = BList;
GridColumn = new UltraGridColumn(); GridColumn.BaseColumnName = "FromDate"; GridColumn.Header.Caption = "From Date"; GridColumn.Header.RowLayoutColumnInfo.OriginY = 0; GridColumn.Width = Unit.Percentage(25); GridColumn.Key = "FromDate"; grid.Bands[0].Columns.Add(GridColumn); grid.DisplayLayout.AllowUpdateDefault = AllowUpdate.Yes; grid.DisplayLayout.Bands[0].Columns[3].EditorControlID = fromDate.UniqueID; grid.DisplayLayout.Bands[0].Columns[3].Type = ColumnType.Custom; fromDate.DropDownStyle.BackColor = System.Drawing.Color.Blue; GridColumn.DataType = "System.DateTime"; fromDate.Format = Infragistics.WebUI.WebSchedule.DateFormat.Short;
GridColumn = new UltraGridColumn(); GridColumn.BaseColumnName = "ToDate"; GridColumn.Header.Caption = "To Date"; GridColumn.Header.RowLayoutColumnInfo.OriginY = 0; GridColumn.Width = Unit.Percentage(25); GridColumn.Key = "ToDate"; grid.Bands[0].Columns.Add(GridColumn); GridColumn.Type = ColumnType.Custom; GridColumn.EditorControlID = toDate.ID; GridColumn.Width = Unit.Percentage(23); GridColumn.FieldLen = 10; GridColumn.AllowUpdate = AllowUpdate.Yes; GridColumn.HTMLEncodeContent = true;
GridColumn = new UltraGridColumn(); GridColumn.Key = "Status"; grid.Bands[0].Columns.Add(GridColumn); GridColumn.Header.RowLayoutColumnInfo.OriginY = 0; GridColumn.Width = 1; GridColumn.Hidden = true;
// set the DataKeyField for the band e.Layout.Bands[0].DataKeyField = "Id";
// turn on paging e.Layout.Pager.AllowPaging = false; } catch (Exception ex) { throw ex; } }
private void LoadGrid() { try { // Clear rows in grid grid.Rows.Clear(); DataSet ds = new DataSet(); try { ds= Value from DB; } catch (Exception) { throw new Exception("NoRecord")); } // Clear columns in grid grid.Columns.Clear(); if (ds.Tables[0].Rows.Count == 0) { // Add empty column header grid.Columns.Add("id"); grid.Columns.Add("A"); grid.Columns.Add("RoleName"); grid.Columns.Add("FromDate"); grid.Columns.Add("ToDate); grid.Columns[0].Hidden = true; return; } else { // Clear columns in grid grid.Columns.Clear(); grid.DataSource = ds.Tables[0]; grid.DataBind(); } } catch (Exception ex) { throw ex; } }
Take out Browser="xml"