how to refresh datagrid after every 5 seconds ?

Question

Hi,

  i am developing an system in silverlight5 and where i need to show all the online users in datagrid and that datagrid will be refresh after every 5 seconds can somebody please help me...

Thanks in advanced.

Answer 1

<b> Report Date:&nbsp;&nbsp; 2016-11-21 &nbsp;&nbsp;Optometrist: &nbsp;&nbsp;start &nbsp;&nbsp;Time:&nbsp;&nbsp; Consultant: &nbsp;&nbsp;Dr.suresh</b>

Answer 2

Hi,

 

Please try below query - 

DECLARE @x XML = '<table WIDTH="100%" CELLPADDING="1" CELLSPACING="1">

<tr style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt;BACKGROUND-COLOR: #f2f2f2;">
   <td><b>Report Date : </b>2016-11-21 </td>
  <td><b>Optometrist : </b> </td>
  <td><b>Start Time : </b> </td>
</tr>

<tr style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt;BACKGROUND-COLOR: #f2f2f2;">
        <td><b>Consultant : </b>Dr.Suresh </td>
</tr>

</table>'

SELECT t.c.value('.', 'NVARCHAR(MAX)')
FROM @x.nodes('*') t(c)

 

Reference :

https://stackoverflow.com/questions/38868364/sql-remove-all-html-tags-in-a-string