Posted 0 minutes ago (permalink)
Dim column As Telerik.Web.UI.GridBoundColumn
For Each column In theGrid.Columns
If column.DataField.Length > 0 And column.OrderIndex > 0 Then
strSQL = "INSERT INTO wt264PageSettingsColumns (ColumnID, Text, Format, DataFormat, Visible, Value, OrderIndex, Aggregate, FooterText) SELECT '" & ColID & "', '" & RTrim(column.HeaderText) & "', '" & column.DataType.ToString & "', '" & RTrim(column.DataFormatString) & "', '" & column.Display & "', '" & RTrim(column.DataField) & "', '" & column.OrderIndex & "', CASE WHEN '" & Len(RTrim(column.FooterText)) & "' > 0 THEN 1 ELSE 0 END, '" & RTrim(column.FooterText) & "' "
Dim Command000e As SqlClient.SqlCommand = New SqlClient.SqlCommand(strSQL, myComponent.SqlConnection1)
Command000e.CommandTimeout = 5000
Command000e.ExecuteNonQuery()
End If
Next
Thanks in advance
S Watton
<
asp:ControlParameter ControlID="cboState" Name="State" PropertyName="SelectedValue" Type="String" DefaultValue="WI" />
<
asp:ControlParameter ControlID="NamesDDL" Name="EquipmentCategory" PropertyName="SelectedValue" Type="Empty" DefaultValue="6fd56151-7b0a-43e9-beba-f55032e5a7a4" />
<
telerik:RadScriptManager
ID
=
"RSM"
runat
=
"server"
></
telerik:RadScriptManager
>
<
telerik:RadFileExplorer
Width
=
"400"
ID
=
"RadFileExplorer1"
Runat
=
"server"
>
<
configuration
DeletePaths
=
"~/Images/CMS"
UploadPaths
=
"~/Images/CMS"
MaxUploadFileSize
=
"200000"
ViewPaths
=
"~/Images/CMS"
/>
<
Configuration
/>
</
telerik:RadFileExplorer
>
<location allowOverride="true" path="~/Admin">
<system.web>
<trust level="Full" originUrl="" />
</system.web>
</location>