or
private void GetSchema() { // Clear the list out. _charFieldLength.Clear(); DataTable dt = new DataTable(); string connString = Util.GetConnectionString(); SqlConnection conn = new SqlConnection(connString); conn.Open(); try { // Retrieve the schema info from the DB. string[] restriction = { Util.GetDBName(), null, lstReference.Items[lstReference.SelectedIndex].Value, null }; dt = conn.GetSchema("Columns", restriction); } catch (Exception ex) { // Log error } finally { if (conn.State == ConnectionState.Open) conn.Close(); } // Populate the list with the schema info we're interested in. foreach (DataRow row in dt.Rows) { if (row["DATA_TYPE"].ToString() == "varchar" || row["DATA_TYPE"].ToString() == "nvarchar") { FieldInfo fi = new FieldInfo(); fi.FieldName = row["COLUMN_NAME"].ToString(); fi.DataLength = int.Parse(row["CHARACTER_MAXIMUM_LENGTH"].ToString()); _charFieldLength.Add(fi); } } }private struct FieldInfo { public string FieldName; public int DataLength; public FieldInfo(string fieldName, int dataLength) { FieldName = fieldName; DataLength = dataLength; } } List<FieldInfo> _charFieldLength = new List<FieldInfo>();protected void gridActivity_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item is GridEditableItem && e.Item.IsInEditMode) { GridEditableItem form = (GridEditableItem)e.Item; for (int i = 0; i < _charFieldLength.Count; i++) { TextBox dataField = (TextBox)form[_charFieldLength[i].FieldName].Controls[0]; dataField.MaxLength = _charFieldLength[i].DataLength; } } }[ Category("Grid"), Description("Columns for a grid."), DesignerSerializationVisibility(DesignerSerializationVisibility.Content), PersistenceMode(PersistenceMode.InnerProperty) ] public GridColumnCollection GridColumns { get { EnsureChildControls(); return grid.MasterTableView.Columns; } set { EnsureChildControls(); grid.MasterTableView.Columns = value; } }[ Category("Grid"), Description("Columns for a grid."), DesignerSerializationVisibility(DesignerSerializationVisibility.Content), PersistenceMode(PersistenceMode.InnerProperty) ] public GridColumnCollection GridColumns { get { EnsureChildControls(); return grid.MasterTableView.Columns; } set { EnsureChildControls(); foreach(GridColumn col in value) { grid.MasterTableView.Columns.Add(col); } } } <telerik:RadGrid ID="rdgParamDatiAziendali" AllowPaging="true" DataSourceID="edsGridParam" runat="server" OnUpdateCommand="rdgParamDatiAziendalie_UpdateCommand" GridLines="None" Width="97%" AllowSorting="true" PageSize="20" OnItemDataBound ="rdgParamDatiAziendali_ItemDataBound"> <MasterTableView AutoGenerateColumns="False" EditMode="InPlace" DataKeyNames="IdConfigurazioneProgrammaCultura" OverrideDataSourceControlSorting="true" TableLayout="Auto"> <CommandItemTemplate> </CommandItemTemplate> <Columns> <telerik:GridEditCommandColumn ButtonType="ImageButton" CancelImageUrl="~/Images/ImagesGrid/Cancel.gif" EditImageUrl="~/Images/ImagesGrid/Edit.gif" UpdateImageUrl="~/Images/ImagesGrid/Update.gif" InsertImageUrl="~/Images/ImagesGrid/Update.gif" UniqueName="EditCommandColumn" ItemStyle-Width="50px" HeaderStyle-Width="50px" /> <telerik:GridBoundColumn DataField="IdCultura" DataType="System.Int64" HeaderText="IdCultura" SortExpression="IdCultura" UniqueName="IdCultura" ReadOnly="true" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="IdConfigurazioneProgrammaCultura" DataType="System.Int64" HeaderText="Id" SortExpression="IdConfigurazioneProgrammaCultura" UniqueName="IdConfigurazioneProgrammaCultura" Display="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Descrizione" DataType="System.String" HeaderText="Descrizione" SortExpression="Descrizione" UniqueName="Descrizione" ReadOnly="true" HeaderStyle-Width="405px" ItemStyle-Height="13px"> </telerik:GridBoundColumn> <mwc:GridBoundColumn DataField="Id" DataType="System.Int64" HeaderText="Id" SortExpression="Id" UniqueName="Id" Display="false"></mwc:GridBoundColumn> <mwc:GridBoundColumn DataField="IdParametroAzienda" DataType="System.Int64" HeaderText="IdParametroAzienda" SortExpression="IdParametroAzienda" UniqueName="IdParametroAzienda" Display="false"> </mwc:GridBoundColumn> <telerik:GridTemplateColumn Resizable="true" HeaderStyle-Width="275px" UniqueName="ValoreTextBoxComboBox" SortExpression="ValoreTextBoxComboBox" ItemStyle-Height="13px"> <HeaderTemplate> <mwc:Label ID="LabelUnificata" runat="server" LabelResources="valore_simi" ParentType="RadGrid" Height="13px"></mwc:Label> </HeaderTemplate> <ItemTemplate> <mwc:Label ID="LabelDescrizioneI" runat="server" Text='<%# Bind("DescrizioneTextBox") %> ' Width="270px" ReadOnly="true" ParentType="RadGrid" Height="13px"></mwc:Label> <telerik:RadComboBox ID="RadComboBoxValore" runat="server" Width="270px" AutoPostBack="false" ParentType="RadGrid" ReadOnly="true" Height="13px"> </telerik:RadComboBox> <mwc:HiddenField ID="HiddenFieldQueryRiga" runat="server" Value='<%# Bind("QueryComboBox") %>' /> <mwc:HiddenField ID="HiddenFieldTipoControllo" runat="server" Value='<%# Bind("IdTipoParametro") %>' /> <mwc:HiddenField ID="HiddenFieldSelectedValueRadComboBoxValore" runat="server" Value='<%# Bind("ValoreComboBox") %>' /> </ItemTemplate> <EditItemTemplate> <mwc:TextBox ID="TextBoxDescrizione" runat="server" Width="300px" Text='<%# Bind("DescrizioneTextBox") %>'></mwc:TextBox> <telerik:RadComboBox ID="RadComboBoxValore" runat="server" Width="300px" AutoPostBack="false"> </telerik:RadComboBox> <mwc:HiddenField ID="HiddenFieldQueryRiga" runat="server" Value='<%# Bind("QueryComboBox") %>' /> <mwc:HiddenField ID="HiddenFieldTipoControllo" runat="server" Value='<%# Bind("IdTipoParametro") %>' /> <mwc:HiddenField ID="HiddenFieldSelectedValueRadComboBoxValore" runat="server" Value='<%# Bind("ValoreComboBox") %>' /> </EditItemTemplate> </telerik:GridTemplateColumn> <mwc:GridTemplateColumn Resizable="false" HeaderStyle-Width="60px" UniqueName="Abilitato" ItemStyle-Height="13px"> <HeaderTemplate> <mwc:Label ID="LabelAbilitato" runat="server" LabelResources="abilitato_simi" ParentType="RadGrid" Width="60px" Height="13px"></mwc:Label> </HeaderTemplate> <ItemTemplate> <div style="text-align: center;"> <mwc:CheckBox ID="CheckBoxAbilitatoI" runat="server" Checked='<%# Bind("Abilitato") %>' Enabled="false" Width="55px" Height="13px" /> </div> </ItemTemplate> <EditItemTemplate> <mwc:CheckBox ID="CheckBoxAbilitatoE" runat="server" Checked='<%# Bind("Abilitato") %>' Width="55px" Height="13px" /> </EditItemTemplate> </mwc:GridTemplateColumn> </Columns> </MasterTableView> </telerik:RadGrid>protected void rdgParamDatiAziendali_ItemDataBound(object source, GridItemEventArgs e) { GridDataItem dataBoundItem = e.Item as GridDataItem; if (!(e.Item is GridDataInsertItem) && e.Item.IsInEditMode) //item is about to be edit { long tipoParametro = long.Parse(((HiddenField)e.Item.FindControl("HiddenFieldTipoControllo")).Value); if (tipoParametro == (int)CommonParameters.TipoParamDatiAziendali.CheckBox_ComboBox || tipoParametro == (int)CommonParameters.TipoParamDatiAziendali.ComboBox) //RadComboBoxValore load values and selectedvalue ((RadComboBox)e.Item.FindControl("RadComboBoxValore")).DataSource = Utility.ValoriComboBox(((HiddenField)e.Item.FindControl("HiddenFieldQueryRiga")).Value, long.Parse(hdfIdCultura.Value)); ((RadComboBox)e.Item.FindControl("RadComboBoxValore")).DataValueField = "Valore"; ((RadComboBox)e.Item.FindControl("RadComboBoxValore")).DataTextField = "Descrizione"; ((RadComboBox)e.Item.FindControl("RadComboBoxValore")).SelectedValue = ((HiddenField)e.Item.FindControl("HiddenFieldSelectedValueRadComboBoxValore")).Value; try { ((RadComboBox)e.Item.FindControl("RadComboBoxValore")).DataBind(); } catch (ArgumentOutOfRangeException exc) { ErrorMessage.generatePopUpError(RadWindowErrori, ((SessionInformation)Session["sessionData"]).IdCultura, exc, null); } try { switch (tipoParametro) { case (int)CommonParameters.TipoParamDatiAziendali.CheckBox : //CheckBox ((RadComboBox)e.Item.FindControl("RadComboBoxValore")).Visible = false; ((TextBox)e.Item.FindControl("TextBoxDescrizione")).Visible = false; ((CheckBox)e.Item.FindControl("CheckBoxAbilitatoE")).Visible = true; break; case (int)CommonParameters.TipoParamDatiAziendali.CheckBox_ComboBox : //CheckBox-ComboBox ((RadComboBox)e.Item.FindControl("RadComboBoxValore")).Visible = true; ((TextBox)e.Item.FindControl("TextBoxDescrizione")).Visible = false; ((CheckBox)e.Item.FindControl("CheckBoxAbilitatoE")).Visible = true; break; case (int)CommonParameters.TipoParamDatiAziendali.TextBox : //TextBox ((RadComboBox)e.Item.FindControl("RadComboBoxValore")).Visible = false; ((TextBox)e.Item.FindControl("TextBoxDescrizione")).Visible = true; ((CheckBox)e.Item.FindControl("CheckBoxAbilitatoE")).Visible = false; break; case (int)CommonParameters.TipoParamDatiAziendali.ComboBox : //ComboBox ((RadComboBox)e.Item.FindControl("RadComboBoxValore")).Visible = true; ((TextBox)e.Item.FindControl("TextBoxDescrizione")).Visible = false; ((CheckBox)e.Item.FindControl("CheckBoxAbilitatoE")).Visible = false; break; case (int)CommonParameters.TipoParamDatiAziendali.CheckBox_TextBox : //CheckBox-TextBox ((RadComboBox)e.Item.FindControl("RadComboBoxValore")).Visible = false; ((TextBox)e.Item.FindControl("TextBoxDescrizione")).Visible = true; ((CheckBox)e.Item.FindControl("CheckBoxAbilitatoE")).Visible = true; break; } } catch (NullReferenceException) { } } else if (e.Item is GridDataItem) { //RadComboBoxValore load values and selectedvalue if (!String.IsNullOrEmpty(((HiddenField)e.Item.FindControl("HiddenFieldQueryRiga")).Value) && (((HiddenField)e.Item.FindControl("HiddenFieldTipoControllo")).Value == "4")) { ((RadComboBox)e.Item.FindControl("RadComboBoxValore")).DataSource = Utility.ValoriComboBox(((HiddenField)e.Item.FindControl("HiddenFieldQueryRiga")).Value, 0); ((RadComboBox)e.Item.FindControl("RadComboBoxValore")).DataValueField = "Key"; ((RadComboBox)e.Item.FindControl("RadComboBoxValore")).DataTextField = "Value"; ((RadComboBox)e.Item.FindControl("RadComboBoxValore")).SelectedValue = ((HiddenField)e.Item.FindControl("HiddenFieldSelectedValueRadComboBoxValore")).Value; ((Label)e.Item.FindControl("LabelDescrizioneI")).Visible = false; ((RadComboBox)e.Item.FindControl("RadComboBoxValore")).DataBind(); } else { ((RadComboBox)e.Item.FindControl("RadComboBoxValore")).Visible = false; } } }
Private
Sub button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles button1.Click
Dim rw As New RadWindow
rw.ShowContentDuringLoad =
True
rw.Width = Unit.Pixel(1200)
rw.Height = Unit.Pixel(600)
rw.KeepInScreenBounds =
True
rw.Modal =
True
rw.NavigateUrl =
"test.aspx"
rw.VisibleOnPageLoad =
True
RadWindowManager1.Windows.Add(rw)
End Sub
protected void rgDesigLevel_UpdateCommand(object sender, GridCommandEventArgs e) { switch (e.Item.OwnerTableView.Name) { case "Master": string Level1Notes=""; CustomerFileHistoryManager cfhm = new CustomerFileHistoryManager(); foreach (GridDataItem item in rgDesigLevel.EditItems) { Int32 AuditCustomerId = Convert.ToInt32(item.GetDataKeyValue("ID")); GridEditManager editMan = item.EditManager; GridTextBoxColumnEditor editor = (GridTextBoxColumnEditor)editMan.GetColumnEditor("Notes"); Level1Notes = editor.TextBoxControl.Text; cfhm.UpdatePreProcNotes(AuditCustomerId, Level1Notes); } break; } } }string tmp = String.Empty; if (rg.SelectedItems.Count > 0) { int i = 0; foreach (GridDataItem DataItem in RadGrid.SelectedItems) { TableCell cell = DataItem[columnName]; if (cell.Text.Length > 0 && cell.Text != " ") { tmp = String.Format("{0}{1}{2}", tmp, i > 0 ? ";" : "", cell.Text); } i++; } } return tmp;