| <?xml version="1.0"?> | |
| <configuration> | |
| <configSections> | |
| <sectionGroup name="system.web.extensions" | |
| type="System.Web.Configuration.SystemWebExtensionsSectionGroup, | |
| System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, | |
| PublicKeyToken=31bf3856ad364e35"> | |
| <sectionGroup name="scripting" | |
| type="System.Web.Configuration.ScriptingSectionGroup, | |
| System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, | |
| PublicKeyToken=31bf3856ad364e35"> | |
| <section name="scriptResourceHandler" | |
| type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, | |
| System.Web.Extensions, Version=1.0.61025.0, | |
| Culture=neutral, PublicKeyToken=31bf3856ad364e35" | |
| requirePermission="false" | |
| allowDefinition="MachineToApplication"/> | |
| <sectionGroup name="webServices" | |
| type="System.Web.Configuration.ScriptingWebServicesSectionGroup, | |
| System.Web.Extensions, Version=1.0.61025.0, | |
| Culture=neutral, PublicKeyToken=31bf3856ad364e35"> | |
| <section name="jsonSerialization" | |
| type="System.Web.Configuration.ScriptingJsonSerializationSection, | |
| System.Web.Extensions, Version=1.0.61025.0, | |
| Culture=neutral, PublicKeyToken=31bf3856ad364e35" | |
| requirePermission="false" allowDefinition="Everywhere" /> | |
| <section name="profileService" | |
| type="System.Web.Configuration.ScriptingProfileServiceSection, | |
| System.Web.Extensions, Version=1.0.61025.0, | |
| Culture=neutral, PublicKeyToken=31bf3856ad364e35" | |
| requirePermission="false" | |
| allowDefinition="MachineToApplication" /> | |
| <section name="authenticationService" | |
| type="System.Web.Configuration.ScriptingAuthenticationServiceSection, | |
| System.Web.Extensions, Version=1.0.61025.0, | |
| Culture=neutral, PublicKeyToken=31bf3856ad364e35" | |
| requirePermission="false" | |
| allowDefinition="MachineToApplication" /> | |
| </sectionGroup> | |
| </sectionGroup> | |
| </sectionGroup> | |
| </configSections> | |
| <appSettings/> | |
| <connectionStrings/> | |
| <system.web> | |
| <pages> | |
| <controls> | |
| <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> | |
| </controls> | |
| </pages> | |
| <!-- | |
| Set compilation debug="true" to insert debugging | |
| symbols into the compiled page. Because this | |
| affects performance, set this value to true only | |
| during development. | |
| --> | |
| <compilation> | |
| <assemblies> | |
| <add assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> | |
| </assemblies> | |
| <httpHandlers> | |
| <remove verb="*" path="*.asmx"/> | |
| <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> | |
| <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> | |
| <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/> | |
| </httpHandlers> | |
| <httpModules> | |
| <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> | |
| </httpModules> | |
| </compilation> | |
| <system.web.extensions> | |
| <scripting> | |
| <webServices> | |
| <!-- Uncomment this line to customize maxJsonLength and add a | |
| custom converter --> | |
| <!-- | |
| <jsonSerialization maxJsonLength="500"> | |
| <converters> | |
| <add name="ConvertMe" | |
| type="Acme.SubAcme.ConvertMeTypeConverter"/> | |
| </converters> | |
| </jsonSerialization> | |
| --> | |
| <!-- Uncomment this line to enable the authentication service. | |
| Include requireSSL="true" if appropriate. --> | |
| <!-- | |
| <authenticationService enabled="true" requireSSL = "true|false"/> | |
| --> | |
| <!-- Uncomment these lines to enable the profile service. To | |
| allow profile properties to be retrieved | |
| and modified in ASP.NET AJAX applications, you need to add | |
| each property name to the readAccessProperties and | |
| writeAccessProperties attributes. --> | |
| <!-- | |
| <profileService enabled="true" | |
| readAccessProperties="propertyname1,propertyname2" | |
| writeAccessProperties="propertyname1,propertyname2" /> | |
| --> | |
| </webServices> | |
| <!-- | |
| <scriptResourceHandler enableCompression="true" | |
| enableCaching="true" /> | |
| --> | |
| </scripting> | |
| </system.web.extensions> | |
| <!-- | |
| The <authentication> section enables configuration | |
| of the security authentication mode used by | |
| ASP.NET to identify an incoming user. | |
| --> | |
| <authentication mode="Windows"/> | |
| <!-- | |
| The <customErrors> section enables configuration | |
| of what to do if/when an unhandled error occurs | |
| during the execution of a request. Specifically, | |
| it enables developers to configure html error pages | |
| to be displayed in place of a error stack trace. | |
| <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm"> | |
| <error statusCode="403" redirect="NoAccess.htm" /> | |
| <error statusCode="404" redirect="FileNotFound.htm" /> | |
| </customErrors> | |
| --> | |
| </system.web> | |
| <system.codedom> | |
| </system.codedom> | |
| <!-- | |
| The system.webServer section is required for running ASP.NET AJAX under Internet | |
| Information Services 7.0. It is not necessary for previous version of IIS. | |
| --> | |
| <system.webServer> | |
| <validation validateIntegratedModeConfiguration="false" /> | |
| <modules> | |
| <add name="ScriptModule" | |
| preCondition="integratedMode" | |
| type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> | |
| </modules> | |
| <handlers> | |
| <remove name="WebServiceHandlerFactory-ISAPI-2.0"/> | |
| <add name="ScriptHandlerFactory" verb="*" path="*.asmx" | |
| preCondition="integratedMode" | |
| type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> | |
| <add name="ScriptHandlerFactoryAppServices" verb="*" | |
| path="*_AppService.axd" preCondition="integratedMode" | |
| type="System.Web.Script.Services.ScriptHandlerFactory, | |
| System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, | |
| PublicKeyToken=31bf3856ad364e35"/> | |
| <add name="ScriptResource" preCondition="integratedMode" | |
| verb="GET,HEAD" path="ScriptResource.axd" | |
| type="System.Web.Handlers.ScriptResourceHandler, | |
| System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, | |
| PublicKeyToken=31bf3856ad364e35" /> | |
| </handlers> | |
| </system.webServer> | |
| </configuration> | |
| <telerik:RadSlider ID="RadSlider1" runat="server" ItemType="tick" TrackPosition="TopRight" |
| SlideStep="5" MaximumValue="20" MinimumValue="5" Skin="Vista" Width="100px" onvaluechanged="RadSlider1_ValueChanged" /> |
| <telerik:RadSlider runat="server" ID="RadSlider3" Orientation="Horizontal" Height="50" |
| ItemType="Item" TrackPosition="BottomRight"> |
| <Items> |
| <telerik:RadSliderItem Text="Item" Value="1" ToolTip="Very bad" runat="server"></telerik:RadSliderItem> |
| <telerik:RadSliderItem Text="Item" Value="2" runat="server"></telerik:RadSliderItem> |
| <telerik:RadSliderItem Text="Item" Value="3" runat="server"></telerik:RadSliderItem> |
| <telerik:RadSliderItem Text="Item" Value="4" runat="server"></telerik:RadSliderItem> |
| <telerik:RadSliderItem Text="Item" Value="5" runat="server"></telerik:RadSliderItem> |
| </Items> |
| </telerik:RadSlider> |
Hi All
I have a select query like:
SELECT
case when EMPHOSPCD=00 then 'NMC'when EMPHOSPCD=01 then 'RCH' when EMPHOSPCD=02 then 'RNH'end as Hospital,
EMPNO
,CERTIFICATE,PURPOSE,EXTENSION,DESTINATIONADDRS,ACCOMPANY,TELEPHONE,TRAVEL_DATE,RETURN_DATE
from APPS.DM_STAFFREQUEST where
CRT_HOSPCD
='00' and CRT_EMPNO=600989 order by CRT_DATE desc
I want to bind it to radgrid with gridbouncolumns.
CERTIFICATE field have string values seperated by comma,and if one of these values is (travel permit),
fields(DESTINATIONADDRS,ACCOMPANY,TELEPHONE,TRAVEL_DATE,RETURN_DATE ) have value , otherewise they will be empty
my question is, is there any way to write aquery to select these field just if CERTIFICATE field contain (travel permit) value
or away to bind columns to radgrid depend on the value of other column
please help me ASAP
ghadeer

