Solve Code

Code : DECLARE @id_list VARCHAR(MAX) = '21100010004,21100010008,21100010011' DECLARE @table TABLE ( id VARCHAR(50) ) DECLARE @x INT = 0 DECLARE @firstcomma INT = 0 DECLARE @nextcomma INT = 0 SET @x = LEN(@id_list) - LEN(REPLACE(@id_list, ',', '')) + 1 -- number of ids in id_list WHILE @x > 0     BEGIN         SET @nextcomma = CASE WHEN CHARINDEX(',', @id_list, @firstcomma + 1) = 0                               THEN LEN(@id_list) + 1                               ELSE CHARINDEX(',', @id_list, @firstcomma + 1)                          END         INSERT  INTO @table         VALUES  ( SUBSTRING(@id_list, @firstcomma + 1, (@nextcomma - @firstcomma) - 1) )         SET @firstcomma = CHARINDEX(',', @id_list, @firstcomma + 1)         SET @x = @x - 1     END SELECT  RTRIM(LTRIM(id)) FROM    @table

COde: DECLARE @bb VARCHAR(MAX) SELECT @bb= COALESCE(@bb+',','')+CONVERT(VARCHAR,RegistrationNumber) FROM dbo.odlStudentTermPromotion WHERE TermSession='2014-1' AND isactive=1 SELECT @bb

Code : Just set NavigateUrl = "javascript:void(0)"; During binding Done :)

Code : <asp:TreeView ID="treeviewspcode" runat="server" ShowCheckBoxes="All" OnClick="OnTreeClick(event)" ShowLines="True" Width="100%">                     <HoverNodeStyle BackColor="Yellow" BorderColor="#FF0066" BorderStyle="Solid" BorderWidth="1px" />                     <SelectedNodeStyle BackColor="#FFFF99" BorderColor="#FF3300" BorderStyle="Dotted" BorderWidth="1px" />                 </asp:TreeView> JAVASCRIPT CODE HERE :   <script type="text/javascript">         function OnTreeClick(evt) {             var src = window.event != window.undefined ? window.event.srcElement : evt.target;                       var isChkBoxClick = (src.tagName.toLowerCase() == "input" && src.type == "checkbox");             if (isChkBoxClick) {                 if (src.checked == tr

Code   DispatcherTimer dispatchedtimer;         protected override void OnNavigatedTo(NavigationEventArgs e)         {             dispatchedtimer = new DispatcherTimer();             dispatchedtimer.Tick += dispatchedtimer_Tick;             dispatchedtimer.Interval = new TimeSpan(1000);             dispatchedtimer.Start();         }         void dispatchedtimer_Tick(object sender,object e)         {             //timer event to perform on timer         }