or
<telerik:RadRotator ID="radRotator1" runat="server" EnableViewState="true" Width="940px" Height="550px" ItemWidth="900px" BorderStyle="None" BorderWidth="0" BorderColor="Transparent" WrapFrames="true" ScrollDirection="Left, Right" RotatorType="SlideShowButtons" OnItemDataBound="radRotator1_ItemDataBound" > <ItemTemplate><div style="overflow:scroll;"><asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"<asp:Panel ID="pnlTest1" runat="server" Visible="false"> Panel content test. </asp:Panel> </div> </ItemTemplate> </telerik:RadRotator>
ShowHeader="true" ShowFooter="false">
<Columns>
...
</Columns>
</asp:GridView>
Hi,
<telerik:GridBoundColumn DataField="Address1" UniqueName="Address1" HeaderText="<%$ Resources:lbl_Employee_Address1 %> " ShowFilterIcon="false"
EditFormColumnIndex="0" Visible="false" >
</telerik:GridBoundColumn>
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;
}
}
}